Parcel Data - Teradata Director Program

Teradata Director Program Reference

Product
Teradata Director Program
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2416
lifecycle
previous
Product Category
Teradata Tools and Utilities

Parcel Data

Table 24 provides field information for the ResultSetSelection parcel.

 

Table 24: ResultSet Selection Parcel Information 

Flavor

 

Mnemonic

 

TRDSPBRL

 

Field

Length

Value

179

TRDSPFRL

PBRLSLCT

2byte unsigned integer

set to 0 if all statement responses for the External Stored Procedure are to be propagated

set to 1 if only one statement response is to be propagated

set to 2 if more than one statement responses ares to be propagated

 

 

 

zero or more bytes

Optional selection cursors

If PBRLSLCT is set to 1, one selection cursor is required; set to 2, one or more selection cursors are required; otherwise no selection cursors might be present.

 

Table 25: Selection Cursor Information 

TRDSPALK

 

Field

Length

Value

PBRLLKSNM

2byte unsigned integer

statement number containing the last row fetched by the procedure

 

2byte unsigned integer

unused (must be zero)

PBRLKQNM

4byte unsigned integer

request number

PBRLKRNM

8byte unsigned integer

row number of the last row fetched by the procedure for the statement

Upon successful completion, an EndRequest parcel is returned. Upon unsuccessful completion, a Failure parcel is returned.