What is the purpose of the WHENEVER statement?



What is the purpose of the WHENEVER statement?..

Answer / s

WHENEVER is used to specify whether to continue processiong
or branch to another area in your program.

EXEC SQL
WHENEVER CONDITION ACTION
END-EXEC

CONDITION can be SQLWARNING, SQLERROR, NOT FOUND conditions

The ACTION can be CONTINUE or GO TO to branch to another
area in your program

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What does db2 blu stand for?

0 Answers  


What is null indicator in cobol db2?

0 Answers  


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,


What is tablespace?

3 Answers  


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  






what is difference between random and sequence file access

1 Answers   Syntel,


Is Cursor exicutable ?

3 Answers   TetraSoft,


What parameters are used to control the free space in DB2?

0 Answers  


What is Declaration Generator(DCLGEN)?

1 Answers  


What is DCLGEN ?

2 Answers  


Is db2 a mainframe database?

0 Answers  


What is a plan and package in db2?

0 Answers  


Categories