when we are tying to update a table having 100 rows. if the
program abends when updating 51 row . how to start updating
again from the 51 row .what was the logic
Answer Posted / kamra2010
1) Create two work files, say WORK-1 and WORK-2.
2) Unload the table into file WORK-1.
3) Pass the commit frequency through the JCL to the program.
4) Program logic:
(i) read the input file WORK-1
(ii) update the table
(iii) if the number of records updated in the table is
equal to the commit frequency then apply COMMIT command.
Also, write the last committed record into the output file
WORK-2. (this record will be used for restart logic)
(iv) In Restart process,
a. read the output file record
b. next, the input file will be read untill it
finds the corresponding output file record
c. follow the same step 4(i) to step 4(iii)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the physical storage length of date data type?
What is schema in db2?
Explain the contents that are a part of dclgen.
What does runstats do in db2?
How to compare data between two tables in db2?
What are the various isolation levels possible?
How can you do the explain of a dynamic sql statement?
What do you mean by storage group (stogroup)?
What are the benefits of using the db2 database?
Which command is used to remove all rows from a table?
When reorg is used?
What is meant by union and union all?
How do you select a row using indexes in db2?
Can you use max on a char column?
How to execute stored procedures?