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
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

ResultSet Cursor

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.