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
- 2 Answers
- 9082 Views
- TCS, I also Faced
- E-Mail Answers
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 package in db2 mainframe?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is copy pending status in db2?
How to connect to db2 database from windows command line?
What is ibm db2 used for?
what are bind concepts in db2 cobol?
Highlight all the advantages that are attached to a package.
Define predicate?
How do I change the column size in db2?
What are the different types of base tables?
Mention data types used in db2 ?
What is node in db2?
what is the sqlcode -501
What are the full forms of spufi and dclgen and why are they used?
How to check sequence on a table in db2?
