ResultSet - Teradata Director Program

Teradata® Director Program Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Director Program
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-17
dita:mapPath
cki1641301536147.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
frc1470439950465
Product Category
Teradata Tools and Utilities

Purpose

The ResultSet parcel is returned after a Success, OK, or ResultSummary 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).

Parcel Data

Field information for the ResultSet parcel is as follows:

Flavor Mnemonic TRDSPBRT
Field Length Value
172 TRDSPFRT PBRTRNUM 8byte 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 2byte 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 can be obtained using the DBCHQE SQL-limits query.
    PBRTPN 2byte 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 can be obtained using the DBCHQE SQL-limits query.