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 |
What are db2 objects?
What are the 4 environments which can access DB2 ?
Can you tell me how can you find out the # of rows updated after an update statement?
What is db2 optimizer?
How can deadlocks be resolved?
What is meant by the attachment facility?
What is buffer pool?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
Explain how can you do the explain of a dynamic sql statement?
What is db2?
In which column of which DB2 catalog would you find the length of the rows for all tables?
Which components manage deadlocks in db2?