|
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
|
|