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...|
|This routine...||Takes the action for Deferred-per-row...|
|DBCHCL||reads (IRQ; IWPF)|
|Deferred-per-row is used by...||To...|
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.