SQLColumns - 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

SQLColumns generates information about columns in a specific table. The fields listed in this table contain important LOB-specific information.

Column Name Value
DATA_TYPE SQL_LONGVARBINARY for BLOB columns

SQL_LONGVARCHAR for CLOB columns

TYPE_NAME BLOB for SQL_LONGVARBINARY

CLOB for SQL_LONGVARCHAR

IS_NULLABLE No
Set to No because of the restriction on the use of LOB NULL values in SQLPutData.