The following table lists the environment attributes that are supported in ODBC Driver for Teradata.
| Environment Attribute | Values Supported | Values Not Supported |
|---|---|---|
| SQL_ATTR_CONNECTION_POOLING | SQL_CP_ONE_PER_DRIVER SQL_CP_ONE_PER_HENV |
– |
| SQL_ATTR_ODBC_VERSION | SQL_OV_ODBC2 SQL_OV_ODBC3 |
– |
The following table lists the connection attributes that are supported in ODBC Driver for Teradata.
| Connection Attribute | Values Supported | Values Not Supported |
|---|---|---|
| SQL_ATTR_ACCESS_MODE | SQL_MODE_READ_ONLY SQL_MODE_READ_WRITE |
– |
| SQL_ATTR_ASYNC_ENABLE | SQL_ASYNC_ENABLE_OFF SQL_ASYNC_ENABLE_ON |
– |
| SQL_ATTR_AUTOCOMMIT | SQL_AUTOCOMMIT_OFF SQL_AUTOCOMMIT_ON |
In Teradata, a DDL statement can be entered either as a single statement or as the last statement in a transaction. Catalog and information functions, such as SQLGetInfoand SQLGetTypeInfo, might issue SQL requests when called. To prevent an error returning from the database, DDL requests in manual-commit mode must be closed with SQLEndTran(); before calling these functions. |
| SQL_ATTR_AUTO_IPD | SQL_TRUE SQL_FALSE |
This is a read-only attribute set based on the database support of extended statement info. |
| SQL_ATTR_LOGIN_TIMEOUT | An integer value | – |
| SQL_ATTR_METADATA_ID | SQL_FALSE SQL_TRUE | – |
| SQL_ATTR_QUIET_MODE | A 32-bit window handle | – |
| SQL_ATTR_TRANSLATE_LIB | A character string value | – |
| SQL_ATTR_TRANSLATE_OPTION | A 32-bit integer value | – |
| SQL_ATTR_TXN_ISOLATION | SQL_TXN_READ_UNCOMMITTED SQL_TXN_SERIALIZABLE |
SQL_TXN_READ_COMMITED SQL_TXN_REPEATABLE_READ |
- SQL_ATTR_ODBC_CURSORS
- SQL_ATTR_TRACE
- SQL_ATTR_TRACEFILE
The following table lists the statement attributes that are supported in ODBC Driver for Teradata.
| Statement Attribute | Values Supported | Values Not Supported |
|---|---|---|
| SQL_ATTR_APP_PARAM_DESC | A Descriptor Handle | – |
| SQL_ATTR_APP_ROW_DESC | A Descriptor Handle | – |
| SQL_ATTR_ASYNC_ENABLE | SQL_ASYNC_ENABLE_OFF SQL_ASYNC_ENABLE_ON |
– |
| SQL_ATTR_CONCURRENCY | SQL_CONCUR_READ_ONLY | SQL_CONCUR_LOCK SQL_CONCUR_ROWVER SQL_CONCUR_VALUES |
| SQL_ATTR_CURSOR_TYPE | SQL_CURSOR_FORWARD_ONLY | SQL_CURSOR_STATIC SQL_CURSOR_KEYSET_DRIVEN SQL_CURSOR_DYNAMIC |
| SQL_ATTR_ENABLE_AUTO_IPD | SQL_TRUE SQL_FALSE |
– |
| SQL_ATTR_IMP_PARAM_DESC | A Descriptor Handle | – |
| SQL_ATTR_IMP_ROW_DESC | A Descriptor Handle | – |
| SQL_ATTR_KEYSET_SIZE | Zero | Other than zero |
| SQL_ATTR_MAX_LENGTH | Zero | Other than zero |
| SQL_ATTR_MAX_ROWS | An integer value | – |
| SQL_ATTR_METADATA_ID | SQL_FALSE SQL_TRUE |
– |
| SQL_ATTR_NOSCAN | SQL_NOSCAN_OFF SQL_NOSCAN_ON |
– |
| SQL_ATTR_PARAM_BIND_OFFSET_PTR | A pointer to an integer value | – |
| SQL_ATTR_PARAM_BIND_TYPE | SQL_PARAM_BIND_BY_COLUMN or an integer value specifying the row size (for row-wise binding) | – |
| SQL_ATTR_PARAM_OPERATION_PTR | An array, in which the status values are stored or NULL | – |
| SQL_ATTR_PARAM_STATUS_PTR | An array, in which the status values are stored or NULL | – |
| SQL_ATTR_PARAMS_PROCESSED_PTR | A pointer to an integer value or NULL | – |
| SQL_ATTR_PARAMSET_SIZE | An integer value | – |
| SQL_ATTR_QUERY_TIMEOUT | An integer value | – |
| SQL_ATTR_REDRIVE |
|
– |
| SQL_ATTR_RETRIEVE_DATA | SQL_RD_ON | SQL_RD_OFF |
| SQL_ATTR_ROW_ARRAY_SIZE | An integer value | – |
| SQL_ATTR_ROW_BIND_OFFSET_PTR | A pointer to an integer value | – |
| SQL_ATTR_ROW_BIND_TYPE | SQL_BIND_BY_COLUMN or an integer value specifying the row size (for row-wise binding) | – |
| SQL_ATTR_ROW_NUMBER | An integer value | – |
| SQL_ATTR_ROW_STATUS_PTR | An array, in which the status values are stored or NULL | – |
| SQL_ATTR_ROWS_FETCHED_PTR | A pointer to an integer value or NULL | – |
| SQL_ATTR_SIMULATE_CURSOR | SQL_SC_NON_UNIQUE | SQL_SC_TRY_UNIQUE SQL_SC_UNIQUE |
| SQL_ATTR_TRUSTED_SQL | SQLULEN value of either SQL_TRUE or SQL_FALSE | – |
| SQL_ATTR_USE_BOOKMARKS | SQL_UB_OFF | SQL_UB_VARIABLE SQL_UB_FIXED |