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:
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.
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.