Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How to restart a DB2 program?

1956


Explain about dbrm.

1109


What is a dbrm in db2?

1077


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1788


What is the difference between drop table and delete table?

1286


What does reorg do in db2?

1074


What is a db2 tablespace?

1119


Explain the contents that are a part of dclgen.

1137


Can one database have multiple instances?

1097


What is explain in db2?

1078


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

707


How to compare data between two tables in db2?

1138


What is ibm db2 client?

1006


How do I copy a table in db2?

1055


What is db2 stogroup?

1223