SQLPutData - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

It is not possible to insert a NULL value into a LOB column.

According to the ODBC Specification, there should be two ways to insert LOB NULL values when using DATA_AT_EXEC:
  • The application calls SQLBindParameter with the data length set to SQL_NULL_DATA
  • The application calls SQLPutData with the data length set to SQL_NULL_DATA

However, only the first of these alternatives is available due to a Teradata Database restriction.