C. SQLSTATE Values and Generic Error Codes : SQLSTATE and Equivalent Generic Errors
 
Share this page                  
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