Here are frequently asked SQL errors. In mainframe interviews, these you may surface.
Advertisements
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.
Related Posts