SQLSTATE Values and Generic Error Codes

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 SQLconnection

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