SQLProcedureColumns - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
wxs1608578396899.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

The result set returned by SQLProcedureColumns has an additional Teradata ODBC-specific column after the standard columns. This information is listed in the following table.

Column Name Column Number (ODBC 3.X) Data Type Comments
IS_RESULT_SET_COLUMN 20 Smallint Always NULL
USER_DATA_TYPE 21 Smallint Always NULL
TDODBC_ DATA_TYPE 22 Smallint not NULL Teradata ODBC-specific SQL data type code used by ODBC Driver for Teradata. If multiple database types have the same standard ODBC SQL type, then the Teradata ODBC-specific SQL data type code can be used to distinguish between the types. For an example, see Number Data Types.