Answer Posted / 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 View All Answers
How to restart a DB2 program?
Explain about dbrm.
What is a dbrm in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the difference between drop table and delete table?
What does reorg do in db2?
What is a db2 tablespace?
Explain the contents that are a part of dclgen.
Can one database have multiple instances?
What is explain in db2?
How can we retrieve the total number of records in RPG & CLLE?
How to compare data between two tables in db2?
What is ibm db2 client?
How do I copy a table in db2?
What is db2 stogroup?