Interested to Buy Any Domain ? << Click Here >> for more details...
How Commitment and Roll back control is used in as400,
explain with real time senario ???
- 2 Answers
- 16264 Views
- Acolite, HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / avinash
suppose we have to update 1000 of recrds in my cobol db2
program and my program is running fine and it has updated
999 records but the job gets abended in this scenario my
work is not commited or completed so again i have to submit
a job and again it starts updating from record 1.
so to avoid such scenario commit and rollback is used.
so if we set commit point at every 200 records then it will
update the records in 200*5=1000
so if job abends on 999 records then it rooback to the
records from 800 to 1000.
so cpu time will be less.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / garry
With commit/rollback we can ensure data consistency.
Consider a scearion where commit/rollback is not used.
Suppose your program writes/updates 10 files. In case the
program fails in between (say after updating 5 files),
there will be data in 5 files and corresponding data will
not be available in 5 files.
If we introduce commit/rollback in above program. In case
of program failure changes made to 5 files can be rolled
back so that we don't have inconsistency between files.
with Commit/rollback we can ensure either all files are
updated or not file is updated.
| Is This Answer Correct ? | 7 Yes | 3 No |
1.How you will find the program is batch or online in cl pgm? 2.How you will end the batch pgm when the job runs? write an logic? 3.In wich command the option *drop is used?
Write a program to display prime numbers between 1 to 100 using RPGLE.
how do I declare a table or array in rpg iv?
How to check which are the pgms using 1 perticulate file.? I know there is many tool available for X-reference...but need to know is there any command available in the system...?
How can i check the object existance in RPG program without using QCMDEXC command.
Why Rpg/400 is Famous?
what is importance of 'MAPFLD' IN OPNQRYF FILE ?
i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in pf i have a name called demo appeared around 52 times hw will we read this particular records in rpg/400?.
Can we used ovrdbf command after the opnqry file if yes then What will be out put of your program?
please help me answer to this question what is the difference between the binding and srvpgm in ilerpg?
how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE
What is a record lock error?
RPG400 
