Previous Topic

Next Topic

SQLSTATE and Equivalent Generic Errors

The following table lists the correspondence between SQLSTATE values and Ingres generic errors:

SQLSTATE

Generic Error

00000

E_GE0000_OK

01000

E_GE0032_WARNING

01001

E_GE0032_WARNING

01002

E_GE0032_WARNING

01003

E_GE0032_WARNING

01004

E_GE0032_WARNING

01005

E_GE0032_WARNING

01006

E_GE0032_WARNING

01007

E_GE0032_WARNING

01008

E_GE0032_WARNING

01009

E_GE0032_WARNING

0100A

E_GE0032_WARNING

01500

E_GE0032_WARNING

01501

E_GE0032_WARNING

02000

E_GE0064_NO_MORE_DATA

07000

E_GE7D00_QUERY_ERROR

07001

E_GE7D00_QUERY_ERROR

07002

E_GE7D00_QUERY_ERROR

07003

E_GE7D00_QUERY_ERROR

07004

E_GE7D00_QUERY_ERROR

07005

E_GE7D00_QUERY_ERROR

07006

E_GE7D00_QUERY_ERROR

07007

E_GE7D00_QUERY_ERROR

07008

E_GE7D00_QUERY_ERROR

07009

E_GE7D00_QUERY_ERROR

07500

E_GE98BC_OTHER_ERROR

08000

E_GE98BC_OTHER_ERROR

08001

E_GE98BC_OTHER_ERROR

08002

E_GE80E8_LOGICAL_ERROR

08003

E_GE80E8_LOGICAL_ERROR

08004

E_GE94D4_HOST_ERROR

08006

E_GE9088_COMM_ERROR

08007

E_GE9088_COMM_ERROR

08500

E_GE75BC_UNKNOWN_OBJECT

0A000

E_GE98BC_OTHER_ERROR

0A001

E_GE98BC_OTHER_ERROR

0A500

E_GE79E0_UNSUP_LANGUAGE

21000

E_GE9CA4_CARDINALITY

22000

E_GE9D08_DATAEX_NOSUB

22001

E_GE9D09_DATAEX_TRUNC

22002

E_GE9D0A_DATAEX_NEED_IND

22003

E_GE9D0B_DATAEX_NUMOVR

22003

E_GE9D1C_DATAEX_FIXOVR

22003

E_GE9D1D_DATAEX_EXPOVR

22003

E_GE9D21_DATAEX_FXPUNF

22003

E_GE9D22_DATAEX_EPUNF

22003

E_GE9D23_DATAEX_DECUNF

22003

E_GE9D24_DATAEX_OTHER

22005

E_GE9D0C_DATAEX_AGN

22007

E_GE9D0F_DATAEX_DATEOVR

22008

E_GE9D0E_DATAEX_DTINV

22009

E_GE9D0F_DATAEX_DATEOVR

22011

E_GE80E8_LOGICAL_ERROR

22012

E_GE9D1E_DATAEX_FPDIV

22012

E_GE9D1F_DATAEX_FLTDIV

22012

E_GE9D20_DATAEX_DCDIV

22012

E_GE9D24_DATAEX_OTHER

22015

E_GE9D0F_DATAEX_DATEOVR

22018

E_GE7918_SYNTAX_ERROR

22019

E_GE7918_SYNTAX_ERROR

22021

E_GE9D08_DATAEX_NOSUB

22022

E_GE9D11_DATAEX_INVIND

22023

E_GE9D08_DATAEX_NOSUB

22024

E_GE98BC_OTHER_ERROR

22025

E_GE7918_SYNTAX_ERROR

22026

E_GE9D08_DATAEX_NOSUB

22027

E_GE7918_SYNTAX_ERROR

22500

E_GE9D17_DATAEX_TYPEINV

23000

E_GE9D6C_CONSTR_VIO

24000

E_GE9DD0_CUR_STATE_INV

25000

E_GE9E34_TRAN_STATE_INV

26000

E_GE75B2_NOT_FOUND

27000

E_GE9EFC_TRIGGER_DATA

28000

E_GEA028_USER_ID_INV

2A000

E_GE7918_SYNTAX_ERROR

2A500

E_GE7594_TABLE_NOT_FOUND

2A501

E_GE759E_COLUMN_UNKNOWN

2A502

E_GE75F8_DEF_RESOURCE

2A503

E_GE84D0_NO_PRIVILEGE

2A504

E_GE75A8_CURSOR_UNKNOWN

2A505

E_GE75B2_NOT_FOUND

2A506

E_GE797C_INVALID_IDENT

2A507

E_GE797C_INVALID_IDENT

2B000

E_GE7D00_QUERY_ERROR

2C000

E_GE7918_SYNTAX_ERROR

2D000

E_GE9E34_TRAN_STATE_INV

2E000

E_GE797C_INVALID_IDENT

33000

E_GE75BC_UNKNOWN_OBJECT

34000

E_GE75A8_CURSOR_UNKNOWN

35000

E_GE7D00_QUERY_ERROR

37000

E_GE7918_SYNTAX_ERROR

37500

E_GE7594_TABLE_NOT_FOUND

37501

E_GE759E_COLUMN_UNKNOWN

37502

E_GE75F8_DEF_RESOURCE

37503

E_GE84D0_NO_PRIVILEGE

37504

E_GE75A8_CURSOR_UNKNOWN

37505

E_GE75B2_NOT_FOUND

37506

E_GE797C_INVALID_IDENT

37507

E_GE797C_INVALID_IDENT

3C000

E_GE9DD0_CUR_STATE_INV

3D000

E_GE98BC_OTHER_ERROR

3F000

E_GE797C_INVALID_IDENT

40000

E_GE98BC_OTHER_ERROR

40001

E_GEC2EC_SERIALIZATION

40002

E_GE9D6C_CONSTR_VIO

40003

E_GE9088_COMM_ERROR

42000

E_GE7918_SYNTAX_ERROR

42500

E_GE7594_TABLE_NOT_FOUND

42501

E_GE759E_COLUMN_UNKNOWN

42502

E_GE75F8_DEF_RESOURCE

42503

E_GE84D0_NO_PRIVILEGE

42504

E_GE75A8_CURSOR_UNKNOWN

42505

E_GE75B2_NOT_FOUND

42506

E_GE797C_INVALID_IDENT

42507

E_GE797C_INVALID_IDENT

44000

E_GE7D00_QUERY_ERROR

50000

E_GE98BC_OTHER_ERROR

50001

E_GE7602_INS_DUP_ROW

50002

E_GE8CA0_SYSTEM_LIMIT

50003

E_GE8D04_NO_RESOURCE

50004

E_GE8D68_CONFIG_ERROR

50005

E_GE9470_GATEWAY_ERROR

50006

E_GE9858_FATAL_ERROR

50007

E_GE9E98_INV_SQL_STMT_ID

50008

E_GEA0F0_SQL_STMT_INV

50009

E_GEA154_RAISE_ERROR

5000A

E_GE7D00_QUERY_ERROR

5000B

E_GE98BC_OTHER_ERROR

5000C

E_GE9D0D_DATAEX_FETCH0

5000D

E_GE9D12_DATAEX_CURSINV

5000E

E_GEA21C_DUP_SQL_STMT_ID

5000F

E_GE98BC_OTHER_ERROR

5000H

E_GE75BC_UNKNOWN_OBJECT

5000I

E_GE98BC_OTHER_ERROR

5000J

E_GE98BC_OTHER_ERROR

5000K

E_GE98BC_OTHER_ERROR

5000L

E_GE9088_COMM_ERROR

5000M

E_GE9088_COMM_ERROR

HZ000

E_GE9088_COMM_ERROR


© 2007 Ingres Corporation. All rights reserved.