Retrieving LOB Data - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
smj1488824663219.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

As described previously in Inserting LOB Data, LOB data is relatively large by nature, therefore, retrieving LOB data, like inserting LOB data, will likely also be done in parts, rather than reading the whole LOB in one operation.

To retrieve LOB data, use a series of SQLGetData calls. The sample program, Retrieving LOB Data, demonstrates this technique.