SLOB Response - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

This parcel is never required, and it is unlikely that any application will find it useful.

Allows the Teradata Database to return data for a LOB inline based on limits specified in the parcel. When present it must be immediately before the Respond, ExtendedRespond, KeepRespond, or ExtendedKeepRespond parcel. The limits specify the maximum size of a single LOB and the maximum size for all LOBs returned for the same row. If either of these limits is exceeded, or if the Database, for whatever reason, decides not to honor the LOB Response parcel, a locator for the LOB rather than the LOB data will be returned. When honored, data for the LOB will be returned by one or more SLOB Data parcels, bracketed by a SLOB DataStart and a SLOB DataEnd parcel, all before the EndMultipartRecord parcel. Whether honored or not, the RequestOptions parcel SelectData option must specify some type of locator be returned.

Parcel Data

Table 94 provides field information for the SLOB Response parcel.

 

Table 94: SLOB Response Parcel Information 

Flavor

Mnemonic

TRDSPBYR

Field

Length

Value

215

 

TRDSPFRC

 

PBYRMLSZ

8 byte unsigned integer

Specifies the maximum size parcel that may be returned inline

PBYRMLBR

8 byte unsigned integer

Specifies the maximum size of all LOBs for a row that may be returned inline