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 can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?

4 Answers  

Can we concatenate fields in physical file? If yes how can we do?

0 Answers  

how to see number of logical files depending on a pf?...can we declare more than 20 logical files from a single pf? is it possible

4 Answers   ocbc,

Why we create the Physical File Member?

5 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  




how to add a new field to a file without compiling it?

1 Answers  

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

2 Answers   Active Brains, UHG,

what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,

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

3 Answers   Cap Gemini,

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

5 Answers   Patni,

what is general and type of general

1 Answers   Active Brains,

Where the QTEMP library will get created? if the the answer is QSYS, then howcome more than one job can create same library name(QTEMP) in QSYS? what is the uniqueness of QTEMP? For example, run the below command in different workstation WRKOBJ QSYS/QTEMP And take 8 in the option to check the description. both will have different info. so where(which LIB) exactly the QTEMP is stored?

2 Answers  

For more DB400 Interview Questions Click Here
Categories