Maximum LOB Bytes per Field is used to request that the server return a single LOB data field using Smart LOB mode provided the LOB length does not exceed the specified value. Note that the field length does not include the 8-byte variable-length indicator prefix which precede the LOB field.
Maximum LOB Bytes per Field 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-FIELD-LIMIT |
C |
lobFieldLimit |
PL/I |
LOB_Field_Limit |
IBM Assembler |
DBRIMLSZ |
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 Field 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.