How Commitment and Roll back control is used in as400,
explain with real time senario ???
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 |
Q:Hi all,i want accurate answer with code using in built functions.please sent me code as soon as posible. I have program nmed PGM1 which '' RETRIEVE Current production date''should correctly default the production date for the user who is issuing raw materials to the manufacturing.The production date can be different from the celendra date. However, the program does not make the correct adjustment for all manufacturing plants. there is a parameter which determines the production start time e.g. 07:00 if the system time precedes this,the program subtracts one from the celendra day.This work fine when the celendar day starts after production day as it does in England,the system should be adding one to the celendar day during the overlap. unfortunately the program was desined to assumed the celendar day always starts before the production day. Change required in the program: Change the PROGRAM PGM1 to use the new parrameter to decide whether to add or subtract 1 from the celendar day when determining the production date.
How Commitment and Roll back control is used in as400, explain with real time senario ???
what is the rpg system?
difference betwen keywords and opcodes
How would display prime numbers using CL program?
How to update selected fields from pf without using update opcode. How to read all member in Rpg-3,without using any cl command?
Explain mdt?
how do you use commitment control in rpg?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
what is a rpg?
In how many ways a session/device error occurs,,, and what is the remedy for it?
what r drawbacks of OPM? Why do we go for ILE RPG?