What is the purpose of the WHENEVER statement?

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


Please Help Members By Posting Answers For Below Questions

what is utility for parm lib

1886


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

748


What is nvl in db2?

630


How can you quickly find out the # of rows updated after an update statement?

634


What is host variable?

598






What is null indicator in cobol db2?

587


Is ibm db2 free?

577


How can we retrieve the total number of records in RPG & CLLE?

203


What is a page in db2?

612


Can we delete records from view?

566


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?

1938


What is dbrm? What it contains? When it will be created?

595


What is a db2 table?

597


What is difference between isnull and coalesce?

622


How and when does the db2 enforces the unique key?

617