SQLGetData

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K
The following ODBC options relate to the use of SQLGetData, and are supported by the ODBC driver:
  • 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.