15.10 - ResultSet - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

Purpose

Returned after a Success, OK, or StatementStatus parcel to introduce parcels returned from a CALLed stored procedure when Result‑sets‑OK 'Y' was specified (corresponding to the Options parcel (flavor 85) DynamicResultSets 'Y' option).

 

Table 72: ResultSet Parcel Information 

Flavor

 

Mnemonic

 

TRDSPBRT

 

Field

Length

Value

172

TRDSPFRT

PBRTRNUM

8-byte unsigned integer.

row number contained in the first response parcel returned for this statement.

A value of zero corresponds to parcels before those for the actual first row's data (Success, for example) while a value one greater then the number of rows corresponds to parcels after those for the actual last row's data (EndRequest).

 

 

PBRTDB

2-byte unsigned integer, plus the number of bytes specified by that integer

Stored procedure database, consisting of the length in bytes of the name, followed by that name in characters from the current session character set. The maximum length of a name may be obtained using the DBCHQE SQLlimits query.

 

 

PBRTPN

2-byte unsigned integer, plus the number of bytes specified by that integer

Stored procedure name, consisting of the length in bytes of the name, followed by that name in characters from the current session character set. The maximum length of a name may be obtained using the DBCHQE SQLlimits query.