OpenAPI User Guide > OpenAPI User Guide > A. Error Handling > Error Codes > SQLSTATE Values and Descriptions
Was this helpful?
SQLSTATE Values and Descriptions
OpenAPI- and server-generated errors are accompanied by an SQLSTATE value. SQLSTATE is a standard way to report SQL errors. The following table contains SQLSTATE values that may accompany an OpenAPI or server error:
SQLSTATE
Value
Description
II_SS00000_SUCCESS
00000
Success
II_SS01000_WARNING
01000
Warning
II_SS02000_NO_DATA
02000
No more data
II_SS08004_CONNECTION_REJECTED
08004
Connection rejected
II_SS08006_CONNECTION_FAILURE
08006
Connection failure
II_SS0A500_INVALID_QRY_LANG
0A500
Invalid query language
II_SS21000_CARD_VIOLATION
21000
Cardinality violation
II_SS22000_DATA_EXCEPTION
22000
Data exception
II_SS22001_STRING_RIGHT_TRUNC
22001
String data, right truncation
II_SS22002_NULLVAL_NO_IND_PARAM
22002
Null value, no indicator parameter
II_SS22003_NUM VAL_OUT_OF_RANGE
22003
Numeric value out of range
II_SS22005_ASSIGNMENT_ERROR
22005
Error in assignment
II_SS22008_DATETIME_FLD_OVFLOW
22008
Datetime field overflow
II_SS22011_SUBSTRING_ERROR
22011
Substring error
II_SS22012_DIVISION_BY_ZERO
22012
Division by zero
II_SS22015_INTERNAL FLD_OVFLOW
22015
Internal field overflow
II_SS22022_INDICATOR_OVFLOW
22022
Indicator overflow
II_SS22500_INVALID_DATA_TYPE
22500
Invalid data type
II_SS23000_CONSTR_VIOLATION
23000
Integrity constraint violation
II_SS23501_UNIQUE_CONS_VIOLATION
23501
UNIQUE constraint violation
II_SS24000_INV_CURS_STATE
24000
Invalid cursor state
II_SS25000_INV_XACT_STATE
25000
Invalid transaction state
II_SS26000_INV_SQL_STMT_NAME
26000
Invalid SQL statement name
II_SS27000_TRIG_DATA_CHNG_ERR
27000
Triggered data change violation
II_SS28000_INV_AUTH_SPEC
28000
Invalid authorization specification
II_SS40001_SERIALIZATION_FAIL
40001
Serialization failure
II_SS42000_SYN_OR_ACCESSERR
42000
Syntax error or access rule violation
II_SS42500_TBL_NOT_FOUND
42500
Table not found
II_SS42501_COL_NOT_FOUND
42501
Column not found
II_SS42502_DUPL_OBJECT
42502
Duplicate object
II_SS42503_INSUF_PRIV
42503
Insufficient privilege
II_SS42504_UNKNOWN_CURSOR
42504
Cursor not found
II_SS42506_INVALID_IDENTIFIER
42506
Invalid identifier
II_SS50001_INVALID_DUP_ROW
50001
Invalid duplicate row
II_SS50002_LIMIT_EXCEEDED
50002
Limit has been exceeded
II_SS50003_EXHAUSTED_RESOURCE
50003
Resource exhausted
II_SS50004_SYS_CONFIG_ERROR
50004
System configuration error
II_SS50005_GW_ERROR
50005
Gateway-related error
II_SS50006_FATAL_ERROR
50006
Fatal error
II_SS50007_INVALID_SQL_STMT_ID
50007
Invalid SQL statement ID
II_SS50008_UNSUPPORTED_STMT
50008
Unsupported statement
II_SS50009_ERROR_RAISED_IN_DBPROC
50009
Procedure error raised
II_SS5000A_QUERY_ERROR
5000A
Query error
II_SS5000B_INTERNAL ERROR
5000B
Internal error
II_SS5000C_FETCH_ORIENTATION
5000C
Fetch orientation has value zero
II_SS5000D_INVALID_CURSOR_NAME
5000D
Invalid cursor name
II_SS5000E_DUP_STMT_ID
5000E
Duplicate SQL statement ID
II_SS5000H_UNAVAILABLE_RESOURCE
5000H
Unknown or unavailable resource
II_SS01001_CURS_OPER_CONFLICT
01001
Cursor operation conflict
II_SS01002_DISCONNECT_ERROR
01002
Error during disconnect
II_SS01003_NULL_ELIM_IN_SETFUNC
01003
NULL eliminated in set() function
II_SS01004_STRING_RIGHT_TRUNC
01004
String data, right truncation
II_SS01005_INSUF_DESCR_AREAS
01005
Insufficient descriptor items
II_SS01006_PRIV_NOT_REVOKED
01006
Privilege not revoked
II_SS01007_PRIV_NOT_GRANTED
01007
Privilege not granted
II_SS01008_IMP_ZERO_BIT_PADDING
01008
Implicit zero-bit padding
II_SS01009_SEARCH_COND_TOO_LONG
01009
Search condition too long
II_SS0100A_QRY_EXPR_TOO_LONG
0100A
Query expression too long
II_SS01500_LDB_TBL_NOT_DROPPED
01500
Star local database table not dropped
II_SS01501_NO_WHERE_CLAUSE
01501
No where clause: update, delete
II_SS07000_DSQL_ERROR
07000
Dynamic SQL error
II_SS07001_USING_PARM_MISMATCH
07001
Using clause/parameter mismatch
II_SS07002_USING_TARG_MISMATCH
07002
Using clause/target mismatch
II_SS07003_CAN_EXEC_CURS_SPEC
07003
Cannot execute cursor spec
II_SS07004_NEED_USING_FOR_PARMS
07004
Using clause required: params
II_SS07005_STMT_NOT_CURS_SPEC
07005
Prepared statement not cursor specification
II_SS07006_RESTR_DT_ATTR_ERR
07006
Restricted data type violation
II_SS07007_NEED_USING_FOR_RES
07007
Using clause required: result
II_SS07008_INV_DESCR_CNT
07008
Invalid descriptor count
II_SS07009_INV_DESCR_IDX
07009
Invalid descriptor index
II_SS07500_CONTEXT_MISMATCH
07500
Execution context not valid
II_SS08000_CONNECTION_EXCEPTION
08000
Connection error
II_SS08001_CANT_GET_CONNECTION
08001
Cannot establish connection
II_SS08002_CONNECT_NAME_IN_USE
08002
Connection name in use
II_SS08003_NO_CONNECTION
08003
Connection does not exist
II_SS08007_XACT_RES_UNKNOWN
08007
Transaction result unknown
II_SS08500_LDB_UNAVAILABLE
08500
Star local database unavailable
II_SS0A000_FEATUR_NOT_SUPPORTED
0A000
Feature not supported
II_SS0A001_MULT_SERVER_XACTS
0A001
Multiple server transactions
II_SS22007_INV_DATETIME_FMT
22007
Invalid datetime format
II_SS22009_INV_TZ_DISPL_VAL
22009
Invalid timezone displacement
II_SS22018_INV_VAL_FOR_CAST
22018
Invalid character value in cast
II_SS22019_INV_ESCAPE_CHAR
22019
Invalid escape character
II_SS22021_CHAR_NOT_IN_RPRTR
22021
Character not in set
II_SS22023_INV_PARAM_VAL
22023
Invalid parameter value
II_SS22024_UNTERM_C_STRING
22024
Unterminated string
II_SS22025_INV_ESCAPE_SEQ
22025
Invalid escape sequence
II_SS22026_STRING_LEN_MISMATCH
22026
String data, length mismatch
II_SS22027_TRIM_ERROR
22027
Error in trim() function
II_SS2B000_DEP_PRIV_EXISTS
2B000
Dependent privileges exist
II_SS2C000_INV_CH_SET_NAME
2C000
Invalid character set name
II_SS2D000_INV_XACT_TERMINATION
2D000
Invalid transaction termination
II_SS2E000_INV_CONN_NAME
2E000
Invalid connection name
II_SS33000_INV_SQL_DESCR_NAME
33000
Invalid descriptor name
II_SS34000_INV_CURS_NAME
34000
Invalid cursor name
II_SS35000_INV_COND_NUM
35000
Invalid condition number
II_SS3C000_AMBIG_CURS_NAME
3C000
Ambiguous cursor name
II_SS3D000_INV_CAT_NAME
3D000
Invalid catalog name
II_SS3F000_INV_SCHEMA_NAME
3F000
Invalid schema name
II_SS40000_XACT_ROLLBACK
40000
Transaction rollback
II_SS40002_CONSTR_VIOLATION
40002
Integrity constraint violation
II_SS40003_STMT_COMPL_UNKNOWN
40003
Statement results unknown
II_SS42505_OBJ_NOT_FOUND
42505
Object not found
II_SS42507_RESERVED_IDENTIFIER
42507
Reserved identifier
II_SS44000_CHECK_OPTION_ERR
44000
With check option violation
II_SS50000_MISC_ING_ERRORS
50000
Miscellaneous Ingres errors
II_SS5000F_TEXTUAL_INFO
5000F
Textual information
II_SS5000G_DBPROC_MESSAGE
5000G
Database procedure message
II_SS5000I_UNEXP_LDB_SCHEMA_CHNG
5000I
Star local database schema change
II_SS5000J_INCONSISTENT_DBMS_CAT
5000J
Inconsistent DBMS catalog
II_SS5000K_SQLSTATE_UNAVAILABLE
5000K
SQLSTATE code unavailable
II_SS5000L_PROTOCOL_ERROR
5000L
Protocol error
II_SS5000M_IPC_ERROR
5000M
IPC error
II_SS5000N_OPERAND_TYPE_MISMATCH
5000N
Operand type mismatch
II_SS5000O_INVALID_FUNC_ARG_TYPE
5000O
Invalid function argument
II_SS5000P_TIMEOUT_ON_LOCK_REQUEST
5000P
Lock request timeout
II_SS5000Q_DB_REORG_INVALIDATED_QP
5000Q
Query plan invalidated
II_SS5000R_RUN_TIME_LOGICAL_ERROR
5000R
Runtime logical error
II_SSHZ000_RDA
HZ000
Remote database access error
Last modified date: 01/30/2023