15.10 - Maximum LOB Bytes per Row - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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.