SQLGetData - 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 following ODBC options relate to the use of SQLGetData, and are supported by ODBC Driver for Teradata:
  • SQL_GD_ANY_COLUMN
  • SQL_GD_ANY_ORDER
  • SQL_GD_BOUND

The options listed in the following table specify how columns can be used in a SQLGetData call.

Option Description
SQL_GD_ANY_COLUMN SQLGetData can be called for any unbound column, including those before the last bound column.
The columns must be called in order of ascending column number unless SQL_GD_ANY_ORDER is also returned.
SQL_GD_ANY_ORDER SQLGetData can be called for unbound columns in any order.
SQLGetData can be called only for columns after the last bound column unless SQL_GD_ANY_COLUMN is also returned.
SQL_GD_BOUND SQLGetData can be called for bound columns as well as unbound columns.
A driver cannot return this value unless it also returns SQL_GD_ANY_COLUMN.

ODBC supports these options for LOBs in order to provide the most flexible programming model and backward compatibility.