Attributes - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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