ResultSet Cursor - Call-Level Interface Version 2

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
ft:locale
en-US
ft:lastEdition
2024-11-15
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
lifecycle
latest
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.