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
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
ggf1488824663364.ditamap
dita:ditavalPath
Audience_PDF_include.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). Teradata 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.