16.14 Attributes that can be specified in SQLSetConnectAttr, SQLSetConnectAttrW, SQLGetConnectAttr, and SQLGetConnectAttrW
The following table lists and describes the attributes that can be specified in SQLSetConnectAttr, SQLSetConnectAttrW, SQLGetConnectAttr, and SQLGetConnectAttrW.
No. |
Attribute |
Description (convention) |
Support status |
Data type |
---|---|---|---|---|
1 |
SQL_ATTR_ACCESS_MODE |
Whether the SQL statements that perform update operations are supported.
|
Supports the following value:
|
SQLUINTEGER |
2 |
SQL_ATTR_ANSI_APP |
Switching between Unicode and ANSI functions.
|
Supports the following value:
This attribute is used for the driver manager. This attribute cannot be used for applications. If this attribute is used in SQLGetConnectAttr or SQLGetConnectAttrW, an unsupported attribute error is returned. |
SQLUINTEGER |
3 |
SQL_ATTR_ASYNC_ENABLE |
Whether a function called with a statement on the specified connection is executed asynchronously.
|
Supports the following value:
|
SQLUINTEGER |
4 |
SQL_ATTR_AUTO_IPD |
Whether automatic specification of the IPD after a call to SQLPrepare is supported. |
This attribute is not supported. |
-- |
5 |
SQL_ATTR_AUTOCOMMIT |
Whether the automatic commit mode is to be used.
|
Supports the following values:
|
SQLUINTEGER |
6 |
SQL_ATTR_CONNECTION_DEAD |
Value indicating the connection status. This attribute can be set in SQLGetConnectAttr or SQLGetConnectAttrW. This attribute cannot be set in SQLSetConnectAttr or SQLSetConnectAttrW. |
This attribute is not supported. This attribute is not supported in SQLSetConnectAttr or SQLSetConnectAttrW. If this attribute is used in SQLGetConnectAttr or SQLGetConnectAttrW, an unsupported attribute error is returned. |
SQLUINTEGER |
7 |
SQL_ATTR_CONNECTION_TIMEOUT |
The amount of time (in seconds) the application is to wait for a response to a connection request.
|
Supports the following values:
|
SQLUINTEGER |
8 |
SQL_ATTR_CURRENT_CATALOG |
Catalog name used by the data source. |
This attribute is not supported. |
-- |
9 |
SQL_ATTR_ENLIST_IN_DTC |
Whether Microsoft Component Services use the ODBC driver for distributed transactions. |
This attribute is not supported. |
-- |
10 |
SQL_ATTR_LOGIN_TIMEOUT |
The amount of time (in seconds) the application is to wait for a response to a login request.
|
Supports the following values:
If a value other than 0 is set, the HADB ODBC driver rewrites the value to 0, and then returns SQL_SUCCESS_WITH_INFO. |
SQLUINTEGER |
11 |
SQL_ATTR_METADATA_ID |
How to handle character string arguments in catalog functions.
|
Supports the following value:
If this attribute is used in SQLSetConnectAttr, an unsupported attribute error is returned. |
-- |
12 |
SQL_ATTR_ODBC_CURSORS |
How the driver manager uses the ODBC cursor library.
|
Supports the following values:
|
SQLINTEGER |
13 |
SQL_ATTR_PACKET_SIZE |
Network packet size (in bytes). |
This attribute is not supported. |
-- |
14 |
SQL_ATTR_QUIET_MODE |
32-bit window handle. |
This attribute is not supported. |
-- |
15 |
SQL_ATTR_TRACE |
Tracing notifications to the driver manager.
|
Supports the following values:
|
SQLUINTEGER |
16 |
SQL_ATTR_TRACEFILE |
Trace file name. |
This attribute is not supported. |
-- |
17 |
SQL_ATTR_TRANSLATE_LIB |
Library name. |
This attribute is not supported. |
-- |
18 |
SQL_ATTR_TRANSLATE_OPTION |
A 32-bit flag value that is passed to the translator DLL. |
This attribute is not supported. |
-- |
19 |
SQL_ATTR_TXN_ISOLATION |
The transaction isolation level for the current connection. Before calling this function, the application must call SQLEndTran to commit or roll back all open transactions on a connection.
|
Supports the following values:
|
SQLUINTEGER |
20 |
SQL_ATTR_HADB_ORDER_MODE |
HADB-specific attribute that is not in the ODBC conventions. This attribute sets for the current connection the sort order for character string data in a SELECT statement in which the ORDER BY clause is specified.
|
Supports the following values:
|
SQLUINTEGER |
Legend: --: Not applicable.