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
- 16004 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 |
how do u find whether a record is locked or not??/
how to change the length of the field in a physicalfile?
1.CA(command Atention key)& CF(command Function key) difference with example?Please can any body tell me in real time exp? 2.Can any body tell me some mandatery function keys using while creating any screen with use of SDA-FUNCTION kEYS?
why we do STRSRVJOB in batch debugging in as400
which program rpg or cl is efficent to update a transaction onto a database file and why ?
What would be the effect on the field where reverse image, underline and high intensity?
what is estimation? and what is the level identifier parameter in PF?
when will come session device error?
wat is curser?? and its types???
How would display prime numbers using CL program?
How I can reread the physical file in CL program once the end of file reached in same CL program.
1.WHAT IS WRONG WITH THE CODE BELOW? C CUSTNO CHAIN CUSTMAST IF %ERROR can any body find the wrong please? 2.What builtin function will you use to achieve the following functionality? C QTY IFLT *ZERO C QTY MULT-1 QTY ENDIF
RPG400 
