Maximum-LOB-bytes-per-row is an 8-byte unsigned integer that specifies the maximum total size of all Large-objects, in bytes, selected from a row in one request for which the database is permitted to return data inline, overriding a DBCAREA Return-objects-as option to defer data by returning a locator. Whether the database supports this feature can be ascertained using the DBCHQE Integrated-LOB query QERILSU value. The Maximum-LOB-bytes-per-row value does not include the length of the standard 8-byte Database prefixes for LOB datatypes: only the actual total amount of data should be included.
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 taken to be zero.
| Language | Maximum-LOB-bytes-per-row |
|---|---|
| COBOL | LOB-ROW-LIMIT |
| C, C++ | lobRowLimit |
| PL/I | LOB_Row_Limit |
| IBM Assembler | DBRIMLBR |
| Routine | Action for Maximum LOB Bytes |
|---|---|
| DBCHINI | writes |
| DBCHCL | reads (IRQ;IWPF) |
| Maximum-LOB-bytes-per-row 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 instead is the limit of a LOB Field (if specified), message size, or other database limit.
If Maximum-LOB-bytes-per-row exceeds a database server limit, an error is issued by the server.
If both Maximum-LOB-bytes-per-row and Maximum-LOB-bytes-per-field are zero, the specified DBCAREA Return-objects-as option determines how Large-objects are returned.