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.