Large Objects - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
Product Category
Teradata Tools and Utilities

Normal fields in a database table are limited to 64000 bytes. To allow for significantly larger fields, such as audio or video data, large object (LOB) fields are supported. Since their data may exceed the maximum statement size, instead of including the entire LOB in the initial request it may be deferred using the AS DEFERRED phrase in the USING row descriptor for the request string: for example, (USING BLOB AS DEFERRED) or (USING BLOB AS DEFERRED BY NAME). The database then includes an ElicitData or ElicitName parcel in the response to prompt the CLIv2 application to provide the LOB. For more information, see Large Objects (LOB) Support.