17.10 - 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.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

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.