Map SQLSTATE values to Informix® error messages
View the SQLSTATE values that HCL Informix® ODBC Driver can return.
The following table maps SQLSTATE values that HCL Informix® ODBC Driver can return.
| SQLSTATE | Error message | Can be returned from |
|---|---|---|
| 01000 | General warning | All HCL Informix® ODBC Driver functions
except: SQLAllocEnv |
| 01002 | Disconnect error | SQLDisconnect |
| 01004 | Data truncated | SQLBrowseConnect |
| 01006 | Privilege not revoked | SQLExecDirect |
| 01S00 | Invalid connection string attribute | SQLBrowseConnect |
| 01S01 | Error in row | SQLExtendedFetch |
| 01S02 | Option value changed | SQLSetConnectOption |
| 01S03 | No rows updated or deleted | SQLExecDirect |
| 01S04 | More than one row updated or deleted | SQLExecDirect |
| 07001 | Wrong number of parameters | SQLExecDirect |
| 07006 | Restricted data type attribute violation | SQLBindParameter |
| 08001 | Unable to connect to data source | SQLBrowseConnect |
| 08002 | Connection in use | SQLBrowseConnect |
| 08003 | Connection not open | SQLAllocStmt |
| 08004 | Data source rejected establishment of connection | SQLBrowseConnect |
| 08007 | Connection failure during transaction | SQLTransact |
| 08S01 | Communication link failure | SQLBrowseConnect |
| 21S01 | Insert value list does not match column list | SQLExecDirect |
| 21S02 | Degree of derived table does not match column list | SQLExecDirect |
| 22001 | String data right truncation | SQLPutData |
| 22003 | Numeric value out of range | SQLExecDirect |
| 22005 | Error in assignment | SQLExecDirect |
| 22008 | Datetime field overflow | SQLExecDirect |
| 22012 | Division by zero | SQLExecDirect |
| 22026 | String data, length mismatch | SQLParamData |
| 23000 | Integrity constraint violation | SQLExecDirect |
| 24000 | Invalid cursor state | SQLColAttributes |
| 25000 | Invalid transaction state | SQLDisconnect |
| 28000 | Invalid authorization specification | SQLBrowseConnect |
| 34000 | Invalid cursor name | SQLExecDirect |
| 37000 | Syntax error or access violation | SQLExecDirect |
| 3C000 | Duplicate cursor name | SQLSetCursorName |
| 40001 | Serialization failure | SQLExecDirect |
| 42000 | Syntax error or access violation | SQLExecDirect |
| 70100 | Operation aborted | SQLCancel |
| IM001 | Driver does not support this function | All ODBC functions except: SQLAllocConnect |
| IM002 | Data source name not found and no default driver specified | SQLBrowseConnect |
| IM003 | Specified driver could not be loaded | SQLBrowseConnect |
| IM004 | Driver's SQLAllocEnv failed | SQLBrowseConnect |
| IM005 | Driver's SQLAllocConnect failed | SQLBrowseConnect |
| IM006 | Driver's SQLSetConnectOption failed | SQLBrowseConnect |
| IM007 | No data source or driver specified; dialog prohibited | SQLDriverConnect |
| IM008 | Dialog failed | SQLDriverConnect |
| IM009 | Unable to load translation shared library (DLL) | SQLBrowseConnect |
| IM010 | Data source name too long | SQLBrowseConnect |
| IM011 | Driver name too long | SQLBrowseConnect |
| IM012 | DRIVER keyword syntax error | SQLBrowseConnect |
| IM013 | Trace file error | All ODBC functions. |
| S0001 | Base table or view already exists | SQLExecDirect |
| S0002 | Base table not found | SQLExecDirect |
| S0011 | Index already exists | SQLExecDirect |
| S0012 | Index not found | SQLExecDirect |
| S0021 | Column already exists | SQLExecDirect |
| S0022 | Column not found | SQLExecDirect |
| S0023 | No default for column | SQLSetPos |
| S1000 | General error | All ODBC functions except: |
| S1001 | Memory allocation failure | All ODBC functions except: SQLAllocEnv |
| S1002 | Invalid column number | SQLBindCol |
| S1003 | Program type out of range | SQLBindCol |
| S1004 | SQL data type out of range | SQLBindParameter |
| S1008 | Operation canceled | All ODBC functions that can be processed asynchronously: SQLColAttributes |
| S1009 | Invalid argument value | SQLAllocConnect |
| S1010 | Function sequence error | SQLBindCol |
| S1011 | Operation invalid at this time | SQLGetStmtOption |
| S1012 | Invalid transaction operation code specified | SQLTransact |
| S1015 | No cursor name available | SQLGetCursorName |
| S1090 | Invalid string or buffer length | SQLBindCol |
| S1091 | Descriptor type out of range | SQLColAttributes |
| S1092 | Option type out of range | SQLFreeStmt |
| S1093 | Invalid parameter number | SQLBindParameter |
| S1094 | Invalid scale value | SQLBindParameter |
| S1095 | Function type out of range | SQLGetFunctions |
| S1096 | Information type out of range | SQLGetInfo |
| S1097 | Column type out of range | SQLSpecialColumns |
| S1098 | Scope type out of range | SQLSpecialColumns |
| S1099 | Nullable type out of range | SQLSpecialColumns |
| S1100 | Uniqueness option type out of range | SQLStatistics |
| S1101 | Accuracy option type out of range | SQLStatistics |
| S1103 | Direction option out of range | SQLDataSources |
| S1104 | Invalid precision value | SQLBindParameter |
| S1105 | Invalid parameter type | SQLBindParameter |
| S1106 | Fetch type out of range | SQLExtendedFetch |
| S1107 | Row value out of range | SQLExtendedFetch |
| S1108 | Concurrency option out of range | SQLSetScrollOptions |
| S1109 | Invalid cursor position | SQLExecute |
| S1110 | Invalid driver completion | SQLDriverConnect |
| S1111 | Invalid bookmark value | SQLExtendedFetch |
| S1C00 | Driver not capable | SQLBindCol |
| S1T00 | Time-out expired | SQLBrowseConnect |