APPX Software Library

Chapter 3: ODBC Driver Conformance

3.3 Supported Environment, Connection, and Statement Attributes

Table 3–2 details the driver attributes that the Dharma/SQL ODBC Driver supports. Applications can set and retrieve supported driver attributes through the following routines:

  • SQLGetEnvAttr and SQLSetEnvAttr for environment attributes
  • SQLGetConnectAttr and SQLSetConnectAttr for connection attributes
  • SQLGetStmtAttr and SQLSetStmtAttr for statement attributes
Table 3–2. Supported Environment, Connection, and Statement Attributes
AttributeSupported?
ODBC Environment Attributes
SQL_ATTR_CONNECTION_POOLINGNo
SQL_ATTR_CP_MATCHNo
SQL_ATTR_ODBC_VERYes
SQL_ATTR_OUTPUT_NTSYes
ODBC Connection Attributes
SQL_ATTR_ACCESS_MODEYes (supports both read_only and read_write connection modes)
SQL_ATTR_ASYNC_ENABLEYes (supports only SQL_ASYNC_ENABLE_OFF, for other values returns warning “Option value changed” and sets to default)
SQL_ATTR_AUTO_IPDYes
SQL_ATTR_AUTOCOMMITYes
SQL_ATTR_CONNECTION_TIMEOUTYes (supports only 0, for other values returns warning “Option value changed” and sets to default)
SQL_ATTR_CURRENT_CATALOGNo
SQL_ATTR_LOGIN_TIMEOUTYes (supports only 0, for other values returns warning “Option value changed” and sets to default)
SQL_ATTR_ODBC_CURSORSYes
SQL_ATTR_PACKET_SIZEYes (supports only default, for other values returns warning “Option value changed” and sets to default)
SQL_ATTR_QUIET_MODEYes (supports only default, for other values returns warning “Option value changed” and sets to default)
SQL_ATTR_TRACENo
SQL_ATTR_TRACEFILENo
SQL_ATTR_TRANSLATE_DLLNo
SQL_ATTR_TRANSLATE_LIBNo
SQL_ATTR_TRANSLATE_OPTIONNo
SQL_ATTR_TXN_ISOLATIONYes
ODBC Statement Attributes
SQL_ATTR_APP_PARAM_DESCYes
SQL_ATTR_APP_ROW_DESCYes
SQL_ATTR_ASYNC_ENABLEYes (supports only SQL_ASYNC_ENABLE_OFF, for other values returns warning “Option value changed” and sets to default)
SQL_ATTR_CONCURRENCYYes (supports only SQL_CONCUR_READ_ONLY, for other values returns warning “Option value changed” and sets to default)
SQL_ATTR_CURSOR_SCROLLABLENo
SQL_ATTR_CURSOR_TYPEYes (supports only SQL_FORWARD_ONLY, for other values returns warning “Option value changed” and sets to default)
SQL_ATTR_CURSOR_SENSITIVITYYes (supports only SQL_INSENSITIVE, for other values returns warning “Option value changed” and sets to default)
SQL_ATTR_ENABLE_AUTO_IPDNo
SQL_ATTR_FETCH_BOOKMARK_PTRNo
SQL_ATTR_IMP_PARAM_DESCYes
SQL_ATTR_IMP_ROW_DESCYes
SQL_ATTR_KEYSET_SIZENo
SQL_ATTR_MAX_LENGTHNo
SQL_ATTR_MAX_ROWSYes
SQL_ATTR_METADATA_IDYes
SQL_ATTR_NOSCANNo
SQL_ATTR_PARAM_BIND_OFFSET_PTRYes
SQL_ATTR_PARAM_BIND_TYPEYes
SQL_ATTR_PARAM_OPERATION_PTRYes
SQL_ATTR_PARAM_STATUS_PTRYes
SQL_ATTR_PARAMS_PROCESSED_PTRYes
SQL_ATTR_PARAMSET_SIZEYes
SQL_ATTR_QUERY_TIMEOUTYes (supports only 0, for other values returns warning “Option value changed” and sets to default)
SQL_ATTR_RETRIEVE_DATAYes
SQL_ATTR_ROW_ARRAY_SIZEYes
SQL_ATTR_ROW_BIND_OFFSET_PTRYes
SQL_ATTR_ROW_BIND_TYPEYes
SQL_ATTR_ROW_NUMBERNo
SQL_ATTR_ROW_OPERATION_PTRYes
SQL_ATTR_ROW_STATUS_PTRYes
SQL_ATTR_ROWS_FETCHED_PTRYes
SQL_ATTR_SIMULATE_CURSORNo
SQL_ATTR_USE_BOOKMARKSNo