What is the purpose of the WHENEVER statement?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the purpose of the WHENEVER statement?

The Whenever statement is coded once in the host program to control program actions depending on the SQL-CODE returned by each SQL statement within the program.

(Continued on next question...)

Other Job Interview Questions

• What is a correlated sub query?
• What are some characteristics of columns that benefit from indexes ?
• What is filter factor?
• What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
• What is an asychronous write?
• Can you define an Index if the table size less than 10 PAGES?
• What is the COBOL picture clause of the following DB2 data types?
• In terms of DB2 indexing, what is the root page ?
• What are the three lock types?
• What is cursor stability?
• More...