ResultSetSelection - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
pxm1544831938750.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2416
lifecycle
previous
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.