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 update physical file using logical file with example?

0 Answers  


A pf containing 100 records... my query is how to display from 11th record in the pf?

3 Answers  


What is open data path?

0 Answers  


hi iam very new to as400. i had created one physical file can any one tell command to enter data in to that

9 Answers   Encore,


I have physical file with 100 records,there is no any duplicate records in this pf.based on this pf one logical file I have used.but this lf is viewing only 80 records only of that pf?what is the reason for this?

0 Answers  


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

9 Answers  


Can anybody tell why Journalling is compulsary before Commitment Control?

2 Answers  


Q.1 how to implement the commitment control. 2.how to control commitment control from external program.

7 Answers   IBM,


There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

0 Answers  


Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?

0 Answers  


Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

4 Answers   IBM,


If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.

2 Answers  


Categories