ResultSet Cursor - Call-Level Interface Version 2

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-06-12
dita:mapPath
zws1641280432166.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2418
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.