SQLSTATE | Ingres Only | Description |
|---|---|---|
00000 | Successful completion | |
01000 | Warning | |
01001 | Cursor operation conflict | |
01002 | Disconnect error | |
01003 | Null value eliminated in set function | |
01004 | String data, right truncation | |
01005 | Insufficient item descriptor areas | |
01006 | Privilege not revoked | |
01007 | Privilege not granted | |
01008 | Implicit zero-bit padding | |
01009 | Search condition too long for information schema | |
0100A | Query expression too long for information schema | |
01500 | * | LDB table not dropped |
01501 | * | DSQL update or delete affects entire table |
02000 | No data | |
07000 | Dynamic SQL error | |
07001 | Using clause does not match dynamic parameter specification | |
07002 | Using clause does not match target specification | |
07003 | Cursor specification cannot be executed | |
07004 | Using clause required for dynamic parameters | |
07005 | Prepared statement not a cursor specification | |
07006 | Restricted data type attribute violation | |
07007 | Using clause required for result fields | |
07008 | Invalid descriptor count | |
07009 | Invalid descriptor index | |
07500 | * | Context mismatch |
08000 | Connection exception | |
08001 | SQL-client unable to establish SQL‑connection | |
08002 | Connection name in use | |
08003 | Connection does not exist | |
08004 | SQL-server rejected establishment of SQL-connection | |
08006 | Connection failure | |
08007 | Transaction resolution unknown | |
08500 | * | LDB is unavailable |
0A000 | Feature not supported | |
0A001 | Multiple server transactions | |
0A500 | * | Invalid query language |
21000 | Cardinality violation | |
22001 | String data, right truncation | |
22002 | Null value, no indicator parameter | |
22003 | Numeric value out of range | |
22005 | Error in assignment | |
22007 | Invalid datetime format | |
22008 | Datetime field overflow | |
22009 | Invalid time zone displacement value | |
22011 | Substring error | |
22012 | Division by zero | |
22015 | Interval field overflow | |
22018 | Invalid character value for cast | |
22019 | Invalid escape character | |
22021 | Character not in repertoire | |
22022 | Indicator overflow | |
22023 | Invalid parameter value | |
22024 | Unterminated C string | |
22025 | Invalid escape sequence | |
22026 | String data, length mismatch | |
22027 | Trim error | |
22500 | * | Invalid data type |
23000 | Integrity constraint violation | |
24000 | Invalid cursor state | |
25000 | Invalid transaction state | |
26000 | Invalid SQL statement name | |
27000 | Triggered data change violation | |
28000 | Invalid authorization specification | |
2A000 | Syntax error or access rule violation in direct SQL statement | |
2A500 | * | Table not found |
2A501 | * | Column not found |
2A502 | * | Duplicate object name |
2A503 | * | Insufficient privilege |
2A504 | * | Cursor not found |
2A505 | * | Object not found |
2A506 | * | Invalid identifier |
2A507 | * | Reserved identifier |
2B000 | Dependent privilege descriptors still exist | |
2C000 | Invalid character set name | |
2D000 | Invalid transaction termination | |
2E000 | Invalid connection name | |
33000 | Invalid SQL descriptor name | |
34000 | Invalid cursor name | |
35000 | Invalid condition number | |
37000 | Syntax error or access rule violation in SQL dynamic statement | |
37500 | * | Table not found |
37501 | * | Column not found |
37502 | * | Duplicate object name |
37503 | * | Insufficient privilege |
37504 | * | Cursor not found |
37505 | * | Object not found |
37506 | * | Invalid identifier |
37507 | * | Reserved identifier |
3C000 | Ambiguous cursor name | |
3D000 | Invalid catalog name | |
3F000 | Invalid schema name | |
40000 | Transaction rollback | |
40001 | Serialization failure | |
40002 | Integrity constraint violation | |
40003 | Statement completion unknown | |
42000 | Syntax error or access rule violation | |
42500 | * | Table not found |
42501 | * | Column not found |
42502 | * | Duplicate object name |
42503 | * | Insufficient privilege |
42504 | * | Cursor not found |
42505 | * | Object not found |
42506 | * | Invalid identifier |
42507 | * | Reserved identifier |
44000 | With check option violation | |
50000 | * | Miscellaneous Ingres-specific errors |
50001 | * | Invalid duplicate row |
50002 | * | Limit has been exceeded |
50003 | * | Resource exhausted |
50004 | * | System configuration error |
50005 | * | Enterprise Access product-related error |
50006 | * | Fatal error |
50007 | * | Invalid SQL statement id |
50008 | * | Unsupported statement |
50009 | * | Database procedure error raised |
5000A | * | Query error |
5000B | * | Internal error |
5000D | * | Invalid cursor name |
5000E | * | Duplicate SQL statement id |
5000F | * | Textual information |
5000G | * | Database procedure message |
5000H | * | Unknown/unavailable resource |
5000I | * | Unexpected LDB schema change |
5000J | * | Inconsistent DBMS catalog |
5000K | * | SQLSTATE status code unavailable |
5000L | * | Protocol error |
5000M | * | IPC error |
HZ000 | Remote Database Access |