DBCALAD—Deferred-per-row - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
zwv1608578409227.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
Product Category
Teradata Tools and Utilities

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.