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 see the structure of db2 table??
Why do we use cursor?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is table space in db2?
What is null indicator in db2?
Explain the EXPLAIN statement?
Explain about mirror activator disk mirroring?
How do you define a correlated name?
How is the SUBSTR keyword used in sql?
What do you mean by commit and rollback?
What types of tables are there in the db2 database?