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

SQLColAttribute returns information about columns in a result set. The fields listed in this table contain important LOB-specific information.

SQLColAttribute Options 
Field Identifier Value
SQL_DESC_DISPLAY_SIZE CLOB = 2097088000

BLOB = 4194176000

SQL_DESC_NULLABLE “No”
It is set to No because of the restriction on the use of LOB NULL values in SQLPutData.
SQL_DESC_SEARCHABLE SQL_FALSE
BLOB and CLOB columns cannot be used in ORDER BY and in a WHERE clause.
SQL_DESC_TYPE SQL_LONGVARBINARY for BLOB columns

SQL_LONGVARCHAR for CLOB columns