000 Success
Successful execution
View details →
100 Warning
No data found / End of data
View details →
-117 Error
Number of values not equal to columns
View details →
-118 Error
Table in FROM not in GROUP BY
View details →
-119 Error
HAVING without GROUP BY
View details →
-122 Error
SELECT INTO returns multiple rows
View details →
-130 Error
Invalid use of escape character
View details →
-180 Error
Invalid date/time/timestamp
View details →
-181 Error
Date/time value out of range
View details →
-199 Error
Illegal keyword use
View details →
-204 Error
Object not found
View details →
-205 Error
Column not in table
View details →
-206 Error
Column not in any FROM table
View details →
-208 Error
ORDER BY column not in SELECT
View details →
-216 Error
Expression incompatible
View details →
-302 Error
Host variable data type mismatch
View details →
-303 Error
Host variable truncation
View details →
-305 Error
Null value without indicator
View details →
-311 Error
Varchar length invalid
View details →
-401 Error
Arithmetic overflow
View details →
-402 Error
Arithmetic overflow in function
View details →
-404 Error
UPDATE/INSERT string too long
View details →
-407 Error
NULL not allowed
View details →
-408 Error
Value incompatible with column
View details →
-501 Error
Cursor not open
View details →
-502 Error
Cursor already open
View details →
-503 Error
UPDATE/DELETE without cursor position
View details →
-504 Error
Cursor not declared
View details →
-507 Error
Cursor not open for UPDATE
View details →
-508 Error
CLOSE cursor already closed
View details →
-510 Error
Cursor with PREPARE not open
View details →
-514 Error
PREPARE with open cursor
View details →
-516 Error
DESCRIBE without PREPARE
View details →
-518 Error
EXECUTE without PREPARE
View details →
-530 Error
Foreign key constraint violation
View details →
-531 Error
Parent row restriction
View details →
-532 Error
Multiple cascade paths
View details →
-534 Error
Restrict on self-referencing
View details →
-536 Error
Delete rule invalid
View details →
-538 Error
Foreign key column count mismatch
View details →
-539 Error
Foreign key not nullable
View details →
-551 Error
Authorization failure
View details →
-552 Error
Authorization insufficient for operation
View details →
-601 Error
Duplicate object name
View details →
-602 Error
Too many columns
View details →
-603 Error
Unique constraint exists
View details →
-604 Error
Invalid column definition
View details →
-607 Error
Operation not allowed on system object
View details →
-612 Error
Duplicate column name
View details →
-652 Error
UNIQUE index violation
View details →
-663 Error
Too many columns in index
View details →
-726 Error
Conflicting DDL
View details →
-803 Error
Duplicate key on INSERT/UPDATE
View details →
-805 Error
DBRM/Package not found
View details →
-811 Error
SELECT INTO returns multiple rows
View details →
-818 Error
Timestamp mismatch
View details →
-904 Error
Resource unavailable
View details →
-905 Error
Resource limit exceeded
View details →
-910 Error
Object in pending state
View details →
-911 Error
Deadlock or timeout
View details →
-913 Error
Deadlock victim
View details →
-922 Error
Connection authorization failed
View details →
-927 Error
Language environment error
View details →
-952 Error
DRDA protocol error
View details →
-981 Error
SQL connection lost
View details →