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
what is utility for parm lib
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is nvl in db2?
How can you quickly find out the # of rows updated after an update statement?
What is host variable?
What is null indicator in cobol db2?
Is ibm db2 free?
How can we retrieve the total number of records in RPG & CLLE?
What is a page in db2?
Can we delete records from view?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is dbrm? What it contains? When it will be created?
What is a db2 table?
What is difference between isnull and coalesce?
How and when does the db2 enforces the unique key?