16.20 - SLOB Response - Teradata Tools and Utilities

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

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

Purpose

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

Allows 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 Teradata 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

The following table provides field information for the SLOB Response parcel.

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