| SQL_ACTIVE_ENVIRONMENTS |
IBM Informix driver does not have a limit on number
of active environments. Zero is always returned. |
| SQL_AGGREGATE_FUNCTIONS |
IBM Informix driver will return all aggregate functions
that the database server supports. |
| SQL_ASYNC_MODE |
IBM Informix driver will return SQL_AM_NONE. |
| SQL_ATTR_METADATA_ID |
Supported for GetInfo and PutInfo |
| SQL_BATCH_ROW_COUNT |
IBM Informix driver will return bitmask zero. |
| SQL_BATCH_SUPPORT |
IBM Informix driver will return bitmask zero. |
| SQL_CA1_POS_DELETE |
Operation
arguments supported in a call to SQLSetPos |
| SQL_CA1_POS_POSITION |
Operation
arguments supported in a call to SQLSetPos |
| SQL_CA1_POS_REFRESH |
Operation
arguments supported in a call to SQLSetPos |
| SQL_CA1_POS_UPDATE |
Operation
arguments supported in a call to SQLSetPos |
| SQL_CA1_POSITIONED_DELETE |
A DELETE WHERE CURRENT OF SQL statement is
supported when the cursor is a forward-only cursor. (An SQL-92
entry-level-conforming driver will always return this option as
supported.) |
| SQL_CA1_POSITIONED_UPDATE |
An UPDATE WHERE CURRENT OF SQL statement
is supported when the cursor is a static-only cursor. (An SQL-92
entry-level-conforming driver will always return this option as supported.) |
| SQL_CA1_LOCK_NO_CHANGE |
A
LockType argument of SQL_LOCK_NO_CHANGE is supported in a call to
SQLSetPos when the cursor is a static-only cursor. |
| SQL_CA1_SELECT_FOR_UPDATE |
A SELECT FOR UPDATE SQL statement is supported
when the cursor is a forward-only cursor. (An SQL-92
entry-level-conforming driver will always return this option as
supported.) |
| SQL_CATALOG_NAME |
IBM Informix driver will return 'Y' |
| SQL_COLLATION_SEQ |
INTERSOLV DataDirect
ODBC Driver returns InfoValuePtr (unmodified) |
| SQL_DDL_INDEX |
Returns bitmask SQL_DL_CREATE_INDEX | SQL_DL_DROP_INDEX |
| SQL_DESCRIBE_PARAMETER |
Returns 'N'; parameters cannot
be described. (This is because the latest Informix database servers support
function overloading such that multiple functions with the same
name can accept different parameter types.) |
| SQL_DIAG_DYNAMIC_FUNCTION |
Returns empty string |
| SQL_DROP_TABLE |
Returns bitmask SQL_DT_DROP_TABLE | SQL_DT_CASCADE
| SQL_DT_RESTRICT |
| SQL_DROP_VIEW |
Returns bitmask SQL_DV_DROP_TABLE | SQL_DV_CASCADE
| SQL_DV_RESTRICT |
| SQL_INDEX_KEYWORDS_ |
SQL_LLK_ASC | SQL_LK_DESC |
| SQL_INSERT_STATEMENT |
Returns bitmask SQL_IS_INSERT_LITERALS | SQL_
INSERT_SEARCHED | SQL_IS_SELECT_INTO |
| SQL_MAX_DRIVER_CONNECTIONS |
Returns zero |
| SQL_MAX_IDENTIFIER_LEN |
Returns different values, depending on database server
capability |
| SQL_ODBC_INTERFACE_CONFORMANCE |
Returns SQL_OIC_CORE |
| SQL_PARAM_ARRAY_ROW_COUNTS |
Returns SQL_PARC_NO_BATCH |
| SQL_PARAM_ARRAY_SELECTS |
Returns SQL_PAS_NO_SELECT |
| SQL_SQL_CONFORMANCE |
Returns SQL_OSC_CORE |
| SQL_SQL92_FOREIGN_KEY_DELETE_RULE |
Returns bitmask zero |
| SQL_SQL92_FOREIGN_KEY_UPDATE_RULE |
Returns bitmask zero |
| SQL_SQL92_GRANT |
Returns bitmask zero |
| SQL_SQL92_NUMERIC_VALUE_FUNCTIONS |
Returns bitmask zero |
| SQL_SQL92_PREDICATES |
Returns bitmask zero |
| SQL_SQL92_RELATIONAL_JOIN_OPERATORS |
Returns bitmask zero |
| SQL_SQL92_REVOKE |
SQL_SR_CASCADE | SQL_SR_RESTRICT |
| SQL_SQL92_ROW_VALUE_CONSTRUCTOR |
Returns bitmask zero |
| SQL_SQL92_STRING_FUNCTIONS |
Returns bitmask zero |
| SQL_SQL92_VALUE_EXPRESSIONS |
Returns bitmask zero |
| SQL_STANDARD_CLI_CONFORMANCE |
Returns bitmask SQL_SCC_XOPEN_CLI_
VERSION1 | SQL_SCC_ISO92_CLI |
| SQL_STATIC_CURSOR_ATTRIBUTES1 |
Scrollable only |
| SQL_STATIC_CURSOR_ATTRIBUTES2 |
Scrollable only |
| SQL_XOPEN_CLI_YEAR |
Returns string "1995" |