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 access path in db2?
What is null in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is the maximum size of varchar data type in db2?
What are the different types of base tables?
What is the maximum size of a char data type in db2?
What is difference between alias and synonym in db2?
What does db2 mean?
Is db2 a database?
What is cursor stability in db2?
List out the three types of page locks that can be held.
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How to create backup table in db2?
List down the types of triggers in the db2 database?
