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 |
How to resolve -803 sql code in DB2?
When will you chose to run RUNSTATS?
How do I copy a table in db2?
Are view updateable?
What technique is used to retrieve data from more than one table in a single SQL statement?
What is clone table?
What is a page in db2?
Can SQL statements/queries be included in a copybook?
Which catalog tables contain authorization information?
where can we use index and subscript ? with example ?
what is the Foreign key? explain?
What os does db2 run on?