|
Attribute
|
Value (option)
|
Driver manager
|
Driver alone
|
Comments
|
|---|---|---|---|---|
|
SQL_ATTR_
CONNECTION_ POOLING |
SQL_CP_OFF
SQL_CP_ ONE_PER_DRIVER
SQL_CP_ ONE_PER_HENV
|
All values are supported
|
All values are not applicable to the driver
|
All values are not applicable to ODBC drivers, handled by Driver Manager, so this attribute will be supported if the application links to ODBC DM and can not be simulated by the driver itself.
|
|
SQL_ATTR_CP_
MATCH |
SQL_CP_ STRICT_MATCH
SQL_CP_ RELAXED_MATCH
|
All values supported
|
All values are not applicable to the driver
|
All values are not applicable to ODBC drivers, handled by Driver Manager, so this attribute will be supported if the application links to ODBC DM and cann not be simulated by the driver itself.
|
|
SQL_ATTR_ ODBC_VERSION
|
SQL_OV_ODBC3 SQL_OV_ODBC2
|
Supported
Not Supported |
Supported
Not Supported |
Allows user to set and get the version to 2, but the behavior is a per 3.0 and above.
|
|
SQL_ATTR_ OUTPUT_NTS
|
SQL_TRUE SQL_FALSE
|
Supported
Not Supported |
Supported
Not Supported |
|
|
Attribute
|
Value (option)
|
Driver manager
|
Driver alone
|
Comments
|
|---|---|---|---|---|
|
SQL_ATTR_ODBC_CURSORS
|
SQL_CUR_IF_NEEDED
SQL_FETCH_PRIOR
SQL_CUR_USE_ODBC
SQL_CUR_ USE_DRIVER
|
All values not supported
|
All values not supported
|
|
|
SQL_ATTR_
ACCESS_MODE |
SQL_MODE_ READ_ONLY
SQL_MODE_ READ_WRITE
|
All values not supported
|
All values not supported
|
|
|
SQL_ATTR_
ASYNC_ENABLE |
SQL_ASYNC_ ENABLE_OFF
SQL_ASYNC_ ENABLE_ON
|
All values not supported
|
All values not supported
|
|
|
SQL_ATTR_
AUTO_IPD |
SQL_TRUE SQL_FALSE
|
All values not supported
|
All values not supported
|
|
|
SQL_ATTR_
AUTOCOMMIT |
SQL_ATTR_ AUTOCOMMIT_OFF
SQL_ATTR_ AUTOCOMMIT_ON
|
All values are supported
|
All values are supported
|
|
|
SQL_ATTR_
CONNECTION_ TIMEOUT |
Timeout value in sec
|
Supported
|
Supported
|
|
|
SQL_ATTR_ CURRENT_
CATALOG |
CatalogName
|
Supported
|
Supported
|
|
|
SQL_ATTR_ LOGIN_TIMEOUT
|
Timeout value in sec
|
Supported
|
Supported
|
|
|
SQL_ATTR_ METADATA_ID
|
SQL_TRUE SQL_FALSE
|
All values not supported
|
All values not supported
|
|
|
SQL_ATTR_
PACKET_SIZE |
Packet size in bytes
|
the desired size
|
Not supported
|
|
|
SQL_ATTR_QUIET_MODE
|
Set to NULL
|
can set and get
|
Not supported
|
|
|
SQL_ATTR_
TRACE |
SQL_TRACE_OFF SQL_TRACE_ON
|
All values supported
|
All values not supported
|
All values handled by DM, not by driver
|
|
SQL_ATTR_TRACEFILE
|
Pointer to trace file name
|
Supported
|
Not supported
|
Handled by DM, not by driver
|
|
SQL_ATTR_TRNSLATE_LIB
|
Pointer Name of lib
|
Supported
|
Not supported
|
Handled by DM, not by driver
|
|
SQL_ATTR_TXN_ISOLATION
|
SQL_TXN_ SERIALIZABLE
SQL_TXN_READ_ UNCOMMITTED
SQL_TXN_READ_ COMMITTED
SQL_TXN_
REPEATABLE_
READ
|
All values are supported, except
SQL_TXN_
READ_
UNCOMMITTED
|
All values are supported, except
SQL_TXN_
READ_
UNCOMMITTED
|
An solidDB® server does not support the
READ_
UNCOMMITTED
feature.
|
|
Attribute
|
Value (option)
|
Driver manager
|
Driver alone
|
Comments
|
|---|---|---|---|---|
|
SQL_ATTR_ CONCURRENCY
|
SQL_CONCUR_ READ_ONLY
SQL_CONCUR_LOCK
SQL_CONCUR_ROWVER
SQL_CONCUR_VALUES
|
All values supported
|
All values supported
|
For the value
SQL_CONCUR_READ_ONLY, set and get are supported. For all other values, set is supported and get returns READ_ONLY.
|
|
SQL_ATTR_ CURSOR_TYPE
|
SQL_CURSOR_ FORWARD_ONLY
SQL_CURSOR_ KEYSET_DRIVEN
SQL_CURSOR_DYNAMIC
SQL_CURSOR_STATIC
|
Supported
Forced to dynamic
Forced to dynamic
Forced to dynamic
|
Supported
Forced to dynamic
Forced to dynamic
Forced to dynamic
|
|
|
SQL_ATTR_MAX_
LENGTH |
Length in bytes
|
Not supported
|
Not supported
|
Whatever the length, sets only to default (0).
|
|
SQL_ATTR_MAX_
ROWS |
Maximum number of rows
|
Not supported
|
Not supported
|
Whatever the length, sets only to default (0).
|
|
SQL_ATTR_ RETRIEVE_DATA
|
SQL_RD_OFF SQL_RD_ON
|
Not supported
Supported
|
Not supported
Supported
|
Sets to SQL_RD_ON only
|
|
SQL_ATTR_ USE_BOOKMARKS
|
SQL_UB_OFF SQL_UB_ON
|
All values
not
supported
|
All values
not
supported
|
|
|
SQL_ATTR_ ROW_ARRAY_SIZE
|
An SQLUSMALLINT* value that points to an array of SQLUSMALLINT values containing row status values after a call to SQLFetch or SQLFetchScroll.
|
Supported
|
Supported
|
The array has as many elements as there are rows in the rowset.
|
|
SQL_ATTR_ROWS_ FETCHED_PTR
|
An SQLUINTEGER* value that points to a buffer in which to return the number of rows fetched after a call to SQLFetch or SQLFetchScroll.
|
Supported
|
Supported
|
|
|
SQL_ATTR_ APP_PARAM_DESC
|
SQL_NULL_HDESC
|
Not supported
|
Not supported
|
|
|
SQL_ATTR_ APP_ROW_DESC
|
SQL_NULL_HDESC
|
Not supported
|
Not supported
|
|
|
SQL_ATTR_ CURSOR_
SCROLLABLE |
SQL_SCROLLABLE SQL_NONSCROLLABLE
|
Not supported
Not supported
|
Not supported
Not supported
|
Sets to SQL_NONSCROLLABLE only
|
|
SQL_ATTR_ CURSOR_
SENSITIVITY |
SQL_UNSPECIFIED
SQL_INSENSITIVE
SQL_SENSITIVE
|
Not supported
Not supported
Not supported
|
Not supported
Not supported
Not supported
|
Sets to SQL_UNSPECIFIED only Sets to SQL_ UNSPECIFIED only
|
|
SQL_ATTR_ROW_NUMBER
|
Number of current row
|
Supported
|
Supported
|
User can get the number of rows; cannot set because of read-only property
|
|
SQL_ATTR_ ENABLE_AUTO_
IPD |
SQL_TRUE SQL_FALSE
|
Both values not supported
|
Both values not supported
|
|
|
SQL_ATTR_
METADATA_ID |
SQL_TRUE SQL_FALSE
|
Both values not supported
|
Both values not supported
|
|
|
SQL_ATTR_
PARAM_ BIND_OFFSET_PTR |
SQL_DESC_DATA_PTR
SQL_DESC_ INDICATOR_PTR
SQL_DESC_ OCTET_LENGTH_PTR
SQL_DESC_ BIND_OFFSET_PTR
|
All values are supported
|
All values are supported
|
|
|
SQL_ATTR_
PARAM_ OPERATION_PTR |
Pointer to array containing list of parameters to be ignored
|
Supported
|
Supported
|
|
|
SQL_ATTR_ ROW_STATUS_PTR
|
An SQLUINTEGER value that specifies the number of rows returned by each call to SQLFetch or SQLFetchScroll.
|
Supported
|
Supported
|
|
|
SQL_ROWSET_SIZE
|
Number of rows to return
|
Supported
|
Supported
|
Allows the ODBC application to set its value to greater than 1.
|
|
SQL_ASYNC_
ENABLE |
SQL_ASYNC_ ENABLE_ON
SQL_ASYNC_ ENABLE_OFF
|
All values not supported
|
All values not supported
|
|
|
SQL_BIND_TYPE
|
SQL_BIND_BY_COLUMN
|
Not supported
|
Not supported
|
|
|
SQL_ATTR_
KEYSET_SIZE |
Size
|
Not supported
|
Not supported
|
Whatever the size, sets only to default (0).
|
|
SQL_ATTR_
NOSCAN |
SQL_NOSCAN_OFF SQL_NOSCAN_ON
|
Not supported
Not supported
|
Not supported
Not supported
|
Sets to SQL_NOSCAN_OFF only
|
|
SQL_ATTR_ SIMULATE_
CURSOR |
SQL_SC_NON_UNIQUE
SQL_SC_TRY_UNIQUE
SQL_SC_UNIQUE
|
All values
not
supported
|
All values
not
supported
|
All values are not relevant to solidDB® Driver
|
|
SQL_ATTR_PARAMS_ PROCESSED_PTR
|
Unsigned integer pointer to return the number of sets of parameters that have been processed by the SQL statement executed through SQLExecute or SQLExecDirect.
|
Supported
|
Supported
|
|
|
Attribute
|
Value (option)
|
Driver manager
|
Driver alone
|
Comments
|
|---|---|---|---|---|
|
SQL_DESC_BASE_
COLUMN_NAME |
|
Supported
|
Supported
|
|
|
SQL_DESC_BASE_
TABLE_NAME |
|
Supported
|
Supported
|
|
|
SQL_DESC_
DISPLAY_SIZE |
|
Supported
|
Supported
|
|
|
SQL_DESC_NAME
|
|
|
|
|
|
SQL_DESC_
NULLABLE |
|
Supported
|
Supported
|
|
|
SQL_DESC_
OCTET_LENGTH |
|
Supported
|
Supported
|
|
|
SQL_DESC_
PRECISION |
|
Supported
|
Supported
|
|
|
SQL_DESC_SCALE
|
|
Supported
|
Supported
|
|
|
SQL_DESC_
UPDATABLE |
|
Supported
|
Supported
|
|
|
SQL_DESC_FIXED_PREC_SCALE
|
|
Supported
|
Supported
|
|
|
SQL_DESC_TABLE_NAME
|
|
Supported
|
Supported
|
|
|
SQL_DESC_TYPE
|
|
Supported
|
Supported
|
|
|
SQL_DESC_
UNNAMED |
|
Supported
|
Supported
|
|
|
SQL_DESC_
SCHEMA_NAME |
|
Supported
|
Supported
|
|
|
SQL_DESC_LOCAL_TYPE_NAME
|
|
Supported
|
Supported
|
|
|
SQL_DESC_LABEL
|
|
Supported
|
Supported
|
|
|
SQL_DESC_TYPE_
NAME |
|
Supported
|
Supported
|
|
|
SQL_DESC_AUTO_UNIQUE_VALUE
|
|
Supported
|
Supported
|
|
|
SQL_DESC_
CONCISE_TYPE |
|
Supported
|
Supported
|
|
|
SQL_DESC_
LITERAL_PREFIX |
|
Supported
|
Supported
|
|
|
SQL_DESC_
UNSIGNED |
|
Supported
|
Supported
|
|
|
SQL_DESC_
LITERAL_PREFIX |
|
Supported
|
Supported
|
|
|
SQL_DESC_
UNSIGNED |
|
Supported
|
Supported
|
|
|
SQL_DESC_
LITERAL_SUFFIX |
|
Supported
|
Supported
|
|
|
SQL_DESC_
CATALOG_NAME |
|
Supported
|
Supported
|
|
|
SQL_DESC_COUNT
|
|
Supported
|
Supported
|
|
|
SQL_DESC_
SEARCHABLE |
|
Supported
|
Supported
|
|
|
SQL_DESC_
LENGTH |
|
Supported
|
Supported
|
|
|
SQL_DESC_CASE_
SENSITIVE |
|
Supported
|
Supported
|
|
|
SQL_DESC_NUM_
PREX_RADIX |
|
Supported
|
Supported
|
|