Large Objects - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-04-19
dita:mapPath
xen1544831946512.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2418
lifecycle
previous
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.