Maximum LOB Bytes per Field - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 is zero, no additional limit is placed on the length of the field. The limit will instead be the Row Limit (if specified), the limit of a message size, or other DBS limit.

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.