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 would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What is db2 bind process?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
what is difference between Static call and Dynamic call? How does it function?
What is the cascade rule and how does it relate to deletions made with a subselect?
What r the comman abends in db2, jcl and cobol???????
what is the Foreign key? explain?
How to find the maximum value in a column in the db2 database?
Suppose if I need to update a column, how you do that using cursor?
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?
What type of database is db2?
what's the error code for Unique Index Violation?