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 is difference between alias and synonym in db2?
Request to database but database is not available so what is was abend is raised?
What do you mean by NOT NULL? When will you use it?
What are the disadvantages of PAGE level lock?
Explain about rct in db2?
What is dynamic SQL?
What is a subselect? Is it different from a nested select?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What is the STOSPACE Utility used for?
What if we fail to give values in columns declared as NOT NULL ?
How to define the data items to receive the fetch items for the SQL?
Explain the function of data manager.