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.