OpenSQL Reference Guide > OpenSQL Reference Guide > B. SQLSTATE Values and Generic Error Codes > SQLSTATE Values
Was this helpful?
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.
Note:  The first two characters of the SQLSTATE are a class of errors and the last three a subclass. The codes that end in 000 are the names of the class.
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
Last modified date: 08/14/2024