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 happend with out using Commit,when closing cursor and
program?

Answer Posted / harish

yes, commit-it will save the changes that we done to db2
table

when operation is performed successfully table will be auto
committed its default,suppose if any abends occur all
changes will be rolled back , table will come to original
status

since while updating millions of records somewhere some
abend occurs that time its better to have commit ,so till
upto abend whatever changes occured in table will be
saved.....

pls let me know if u have any queries

HARISH POOMGAME SHIVAPPA
NIIT TECHNOLOGY
KOLKATA

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which are the db2 tools to protect integrity of the database?

1118


How to fetch the last row from the table in SQL (db2)?

1642


Are views updateable?

1144


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9178


What is db2 stogroup?

1151


What is dbrm? When it will be created?

1019


What is a db2 package?

1044


What is access path in db2?

978


What is bind plan?

1041


What is database reorganization?

1114


How would the varchar column remarks defined?

1084


B37 abend during spufi?

1448


How can we read records for specific member in CL? AND rpg?

688


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1069


What is schema in db2?

1016