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...


There are six records in a file and we are going to update
that records and used commit operation when it complete the
update but suppose when it updating the third record,a
error occured and operation failed.Is previously two
records will be update or whole operation will be rollback?
Please confirm it.

Answers were Sorted based on User's Feedback



There are six records in a file and we are going to update that records and used commit operation ..

Answer / sandy

Whole operation will be rolled back.

Is This Answer Correct ?    11 Yes 0 No

There are six records in a file and we are going to update that records and used commit operation ..

Answer / nitendra

Whole operation will be rolled back.
A commit operation guarantees that the group of operations
is completed. A rollback operation guarantees that the
group of operations is backed out.

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More DB400 Interview Questions

How to index LF by relative record no (RRN)

0 Answers  


Why journalling is compulsory before commitment control?

1 Answers  


how to update physical files using normal logical file

4 Answers  


How to change the batch job to interactive job?

0 Answers  


What is the use of member in pf?

0 Answers  


YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?

4 Answers  


what is dynslt and why we use that command when do we use command

2 Answers   Active Brains, UHG,


what is open data base command

1 Answers   Active Brains, Cognizant, CSC, CTS,


How to insert more than one record to a pf at a time?(Bulk insert to a pf)

9 Answers  


What is open data path?

0 Answers  


How to know the perticular record in pf with out reading?

2 Answers   Cap Gemini,


How to know the particular record in pf with out reading?

0 Answers  


Categories