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.00
Published
June 2020
Language
English (United States)
Last Update
2021-04-19
dita:mapPath
xen1544831946512.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.