1. Categories >> Software >> MainFrame >> IBM AS400 >> DB400
  2. Suggest New Category

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.

Question Posted / swadesh.yadav2007

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 know total no of records in pf with out using sql??????

3 Answers  

Define interactive jobs and batch jobs

6 Answers  

How to know logical file belongs to which physical file without source?

1 Answers  

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,

can any one pls tell me some differences between a LF and command OPNQRYF?

3 Answers   Accenture, Cognizant, eFunds,




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

3 Answers   Cap Gemini,

Which keyword is used both in subfile and subfile control record format of a DSPF?

8 Answers  

i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF

3 Answers  

one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,

In how many ways we can create a logical file?`

5 Answers  

What is open data path?

0 Answers  

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

0 Answers  

For more DB400 Interview Questions Click Here
Categories