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
- 16169 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 |
Hi, Can any body tell me ur experience on this questions? Questions: 1.what is the use of SFLRCDNBR other than subfile page display? 2.Which of the following operation cannot be used in conjuction with a file coded as device type disk?
Can anybody tell me, does CL/400 handle LEVEL check while running the CL program....? plz share your experience...
1.find most occurrences of a character. for exm: input:aaabbbbdddddyyy output: d 5 times how can i get that?
What are different ways to pass data between programs and which one is the efficient way?
A pgm subroutine calling child subroutine, that child subroutine again calling parent subroutine, u have 1000 lines of code, with out debugging , how can u find that error??? Is there any command to find errors in pgm???
what is flat file?
Can we create 300 logical files based on a single physical file using the CRTLF command only once?.
parameters cannot be passed in which one???
What is the difference between copybooks and subprocedures in as400?
What is the purpose of Panel Groups?
difference betwen keywords and opcodes
which MONMSG will give higher priority in CL program? I know MONMSG are of two types. Program Level Monmsg and Command Monmsg?
RPG400 
