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
How is a typical db2 batch pgm executed?
What do you mean by rollback?
What is copy pending status in db2?
define clustering index.
How to retrieve rows from a db2 table in embedded sql?
What is bind package and plan in db2?
Define db2 and its databases?
Explain about open switch business continuity software?
How do I copy a table in db2?
What does reorg do in db2?
How can you count the number of rows from a table tab?
Can one database have multiple instances?
What is drop table?
Is db2 relational database?
List down the types of triggers in the db2 database?