Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10182 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 the meaning concurrency in the db2 database?
How can we read records for specific member in CL? AND rpg?
How to find schema of a table in db2?
List down the data types in the db2 database.
How can we retrieve the total number of records in RPG & CLLE?
When the like statement is used?
Define buffer pool.
What is consistency token in db2?
How do I add a column to an existing table in db2?
How to find primary key of a table in db2?
What is sqlca’s maximum length?
How to rename a table in DB2 ?
What is copy pending status in db2?
What do you mean by rollback?
What are catalog tables in db2?
