Oninit
Talk to an expert →

Informix Error -11097: Optional feature not implemented.

Cause and resolution

Optional feature not implemented.

This Informix ODBC error code is the same as SQLSTATE value HYC00. The following functions can return this error code: SQLBindCol, SQLBindParameter, SQLBulkOperations, SQLColAttribute, SQLColumnPrivileges, SQLColumns, SQLDriverConnect, SQLEndTran, SQLExecDirect, SQLExecute, SQLExtendedFetch, SQLFetch, SQLFetchScroll, SQLForeignKeys, SQLGetConnectAttr, SQLGetData, SQLGetEnvAttr, SQLGetInfo, SQLGetStmtAttr, SQLGetTypeInfo, SQLParamData, SQLPrepare, SQLPrimaryKeys, SQLProcedureColumns, SQLProcedures, SQLSetConnectAttr, SQLSetEnvAttr, SQLSetPos, SQLSetStmtAttr, SQLSpecialColumns, SQLStatistics, SQLTablePrivileges, and SQLTables.

The value specified for the argument Attribute was a valid ODBC environment attribute for the version of ODBC supported by the driver, but the attribute was not supported by the driver. For more detailed information, see the ODBC Reference Manual.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-11097 fires when an optional ODBC feature isn't implemented by the driver — per the official guidance, this is the same as SQLSTATE value HYC00, returnable by a very wide range of CLI functions (SQLBindCol, SQLBindParameter, SQLBulkOperations, SQLColAttribute, SQLColumnPrivileges, SQLColumns, SQLDriverConnect, SQLEndTran, SQLExecDirect, SQLExecute, SQLExtendedFetch, SQLFetch, SQLFetchScroll, SQLForeignKeys, SQLGetConnectAttr, SQLGetData, SQLGetEnvAttr, SQLGetInfo, SQLGetStmtAttr, SQLGetTypeInfo, SQLParamData, SQLPrepare, SQLPrimaryKeys, SQLProcedureColumns, SQLProcedures, SQLSetConnectAttr, SQLSetEnvAttr, SQLSetPos, SQLSetStmtAttr, SQLSpecialColumns, SQLStatistics, SQLTablePrivileges, and SQLTables).

  1. An optional ODBC feature the driver doesn't implement, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Check driver capability via SQLGetFunctions()/SQLGetInfo() before relying on the feature, per the official guidance's implication.
Examples
N/A

No specific triggering statement is documented beyond an unimplemented optional feature.

Diagnostic Checks
  1. Check SQLGetFunctions()/SQLGetInfo() for the feature's actual support before using it.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -11097 in this set yet.

An optional ODBC feature isn't implemented by this driver — check its support via SQLGetFunctions()/SQLGetInfo() first.