Purpose
The ResultSet parcel is returned after a Success, OK, or ResultSummary 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
Field information for the ResultSet parcel is as follows:
| Flavor | Mnemonic | TRDSPBRT | ||
|---|---|---|---|---|
| Field | Length | Value | ||
| 172 | TRDSPFRT | PBRTRNUM | 8byte 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 | 2byte 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 can be obtained using the DBCHQE SQL-limits query. | ||
| PBRTPN | 2byte 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 can be obtained using the DBCHQE SQL-limits query. | ||