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

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  


What is db2 bind process?

0 Answers  


Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  


what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,


What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  






What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,


what is the Foreign key? explain?

2 Answers  


How to find the maximum value in a column in the db2 database?

0 Answers  


Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,


When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  


What type of database is db2?

0 Answers  


what's the error code for Unique Index Violation?

2 Answers  


Categories