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).
Parcel Data
The following information applies to the ResultSet parcel.
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. |