These DB2 SQL Errors Asked in Many Mainframe Interviews

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

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.