17.10 - ResultSet Cursor - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

Sent to identify the last row fetched by an External Stored Procedure for a response being propagated to the caller or application.

The following table lists ResultSetCursor parcel information.

Flavor Mnemonic TRDSPBRK
Field Length Value
175 TRDSPFRK PBRKSNUM 2 byte unsigned integer statement number containing the last row fetched by the procedure
    PBRKNUM 8 byte unsigned integer row number of the last row fetched by the procedure for the statement

If the ResultSetCursor parcel is sent multiple times, the last one is honored.

Upon successful completion, an EndRequest parcel is returned. Upon unsuccessful completion, either an Error or Failure parcel is returned. For Error, if the problem can be corrected, the ResultSetCursor parcel may be resent; for Failure, the ResultSetCursor may not be resent.