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

What is dclgen (declaration generator)?

1119


Define check constraint.

1134


What is runstats db2?

1082


What is the difference between drop table and delete table?

1290


What is the cobol picture clause of the db2 data types date, time, timestamp?

1124


How connect db2 database to datastage?

1291


What is a buffer in memory?

1112


What type of database is db2?

1020


What is a db2 collection?

1110


What does db2 stand for?

1094


What is bind package and plan in db2?

1110


What is db2 look?

1079


Discuss about db2 bind?

1158


What is dpf in db2?

1171


Why db2 is called db2?

1109