Purpose
Returned after a Success, OK, or StatementStatus 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).
Flavor
|
Mnemonic
|
TRDSPBRT
|
||
Field |
Length |
Value |
||
172 |
TRDSPFRT |
PBRTRNUM |
8-byte 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 |
2-byte 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 may be obtained using the DBCHQE SQL‑limits query. |
|
|
PBRTPN |
2-byte 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 may be obtained using the DBCHQE SQL‑limits query. |