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

what is open data path? and what is the diff b/w access path and open data path?

3 Answers   Cap Gemini,


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.

2 Answers  


How can we handle errors in RPG?

4 Answers  


pls anyone explain about compile time array,pre run time array run time array

4 Answers  


How to retrieve a physical file after deleting that?

0 Answers  






How to change the batch job to interactive job?

0 Answers  


When u create a PF and did not fill up Maint parameter, then by default which access path will the system take & why

2 Answers   HCL,


Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,


I have a pf, it contains 5 members, how to access particular member data from logical file?

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,


How many libraries can be there in a library list?

2 Answers  


can we concate fileds in physical file? If yes how can we do?

5 Answers   Patni,


Categories