15.10 - SLOB DataStart - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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 data 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

Table 93 provides field information for the SLOB DataStart parcel.

 

Table 93: SLOB DataStart Parcel Information 

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