ResultSetSelection - 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

Sent to identify which statement responses to a request from an External Stored Procedure will be propagated to the caller or application.

Parcel Data

Field information for the ResultSetSelection parcel is as follows:

ResultSetSelection Parcel Information 
Flavor Mnemonic TRDSPBRL
Field Length Value
179 TRDSPFRL PBRLSLCT 2 byte 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.

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.