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 |