SQLGetInfo argument implementation

HCL Informix® implements the SQLGetInfo arguments for Informix® ODBC Driver.

The following table describes the HCL Informix® implementation of SQLGetInfo arguments for Informix® ODBC Driver.
Argument name Informix® implementation
SQL_ACTIVE_ENVIRONMENTS Informix® driver does not have a limit on number of active environments. Zero is always returned.
SQL_AGGREGATE_FUNCTIONS Informix® driver returns all aggregate functions that the database server supports.
SQL_ASYNC_MODE Informix® driver returns SQL_AM_NONE.
SQL_ATTR_METADATA_ID Supported for GetInfo and PutInfo
SQL_BATCH_ROW_COUNT Informix® driver returns bitmask zero.
SQL_BATCH_SUPPORT Informix® driver returns 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 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 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 always return this option as supported.)
SQL_CATALOG_NAME Informix® driver returns '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