16.20 - DBCALAD—Deferred-per-row - 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

Deferred-per-row is a four-byte unsigned integer into which is placed the number of Large-objects that are deferred (either as a column specified AS DEFERRED <BY NAME> in the USING row descriptor, or as a DEFERRED datatype in a DataInfoX or StatementInformation parcel for a parameterized SQL statement). Only the number of deferred objects up to and including the last Large-object whose deferral is being overridden need be included.

In this language... The variable name for Deferred-per-row is...
COBOL LOBS-PER-ROW
PL/I LOBS_PER_ROW
C, C++ 'LOBsPerRow'
IBM Assembler LADLPR
This routine... Takes the action for Deferred-per-row...
DBCHINI writes
DBCHCL reads (IRQ; IWPF)
Deferred-per-row is used by... To...
applications write

The number of Large-objects that are deferred defines the maximum number of entries for each row in the DBCALAD Row-LOB-list and maximum number of entries in the DBCALAD Order-table. For example, given the following skeleton SQL statement,

USING (a INTEGER, b CLOB(1024) AS DEFERRED, c CHAR(100), d BLOB(512) AS DEFERRED BY NAME

there are two AS DEFERRED Large-objects, so the maximum Deferred-per-row value would be 2, the DBCALAD Order-table has two entries, and the DBCALAD Data-row-list has two entries for each Database row affected.