This appendix lists SQLSTATE values, Ingres generic error codes, and maps generic error codes to SQLSTATE values.
SQLSTATE is the ANSI/ISO Entry SQL-92-compliant method for returning errors to applications. The following table lists the values returned in SQLSTATE. An asterisk in the Ingres Only column indicates a value that is specified by ANSI as vendor-defined.
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
|
