These DB2 SQL Errors Asked in Many Mainframe Interviews

Here are frequently asked SQL errors. In mainframe interviews, these you may surface.

Below is the list of frequently asked DB2 SQL errors.

000- Successful
100- Row not found
-205- Column name is not a column of the table
-305- Null values cannot assign to a host variable
-313-Number of host variables declared is not equal to the number of parameter markers
-501 – The cursor is not open
-502 -Multiple openings of a cursor
-503 – The column cannot update because it is not defined in declare statement
-504 – Cursor name not defined
-551/-552 – Authorization for user id not found
-803 – Duplicate insert
-811 – Select fetches more than one row in the case of Singleton SELECT
-818- Timestamp mismatch
-922 – Not authorized on a particular resource
-904 – Resource not available
-911 – Timeout deadlock
-913- Deadlock with rollback
-530 – Foreign key not found
-532- Delete not allowed.