Purpose
This parcel is never required, and it is unlikely that any application will find it useful.
Introduces SLOB Data parcels for a LOB.
For requests, this parcel, followed by SLOB Data and SLOB DataEnd parcels, is placed before the EndMultipartData or EndMultipartIndicData parcel; that is, this parcel is associated a LOB in the SQL USING row descriptor. This descriptor must specify deferred processing for the LOB, along with the token or name consistent with the SQL and for MultipartIndicData, indicators bits consist with the standard request, even though processing will not be deferred. Which LOB is involved is specified by the parcel. The maximum size of USING data limits the number and size of LOBs that can be specified using SLOB Data parcels. This maximum may be ascertained using the CLIv2 Database-limits query.
For responses, this parcel, followed by SLOB Data and SLOB DataEnd parcels, is returned before the EndMultipartRecord parcel when the request contained the SLOB Response parcel. Which LOB is involved is specified by the parcel.
Parcel Data
The following table provides field information for the SLOB DataStart parcel.
| Flavor | Mnemonic | TRDSPBYS | ||
|---|---|---|---|---|
| Field | Length | Value | ||
| 220 | TRDSPFYS | For requests: PBYSUDPN, For responses: PBYSCOLN | 4 byte unsigned integer | For requests: the position of the parameter for this LOB in the USING row descriptor, between one and the number of parameters present. For responses: the position of the column for this LOB in the database table row, between one and the number of LOB columns in the row. |