Attributes

ODBC Driver for Teradata® User Guide

brand
Teradata Tools and Utilities
prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

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

In addition to the connection attributes given in the previous table, applications can use the following connection attributes supported by the Driver Manager:
  • 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_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