Maximum LOB Bytes per Row is used to request that the server return LOB data using Smart LOB mode for all LOB columns provided the aggregate length does not exceed the specified value. Note that the aggregate lengths do not include the 8-byte variable-length indicator prefix which precedes each LOB column. If the aggregate exceeds the specified value, all LOBs will be returned as locators.
Maximum LOB Bytes per Row exists only when DBCHINI had been called for a DBCAREA with Total-length set to at least 1024 (that is, the returned DBCAREA Level value is at least 2). For a smaller DBCAREA, Maximum LOB Bytes per Field is ignored.
Language |
Maximum LOB Bytes per Field |
COBOL |
LOB-ROW-LIMIT |
C |
lobRowLimit |
PL/I |
LOB_Row_Limit |
IBM Assembler |
DBRIMLBR |
Routine |
Action for Maximum LOB Bytes |
DBCHINI |
writes |
DBCHCL |
reads (CON;IRQ;IWPF) |
Maximum LOB Bytes per Field is used by... |
To... |
applications |
read |
If Maximum LOB Bytes per Row is zero, no additional limit is placed on the length of the row. The limit will instead be the limit of a LOB Field (if specified), message size, or other DBS limit.
If Maximum LOB Bytes per Row exceeds a database server limit, an error will be issued by the server.
If both Maximum LOB Bytes per Row and Maximum LOB Bytes per Field are zero, no Smart LOB responses will be used.