I have a DB2 table which has 1000 rows.after udatingg first
110 rows, my job abends. Now what I have to do if I want to
restart the job next time so that it should start updating
from 111th row (without updating first 110 rows again).
- 10 Answers
- 54787 Views
- Cap Gemini, Wipro, I also Faced
- E-Mail Answers
Answer Posted / karthik
RESTART logic will work fine..
following is the flow of restart logic:
if your program is having a commit for every 100 records
which u read from the file, we can restart the program to
update the records from 101 as it had a restart entry in
the restart table once the job got abeneded..
so in your program you need to have a logic like first you
need to read the restart table whether we need a restart
entry for that particular program, if so, u need to read
the first 100 records as dummy and then need to update the
remainig records..else we can start updating the table from
the first read recorrd itself..
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain about cursor stability?
What is phantom read in db2?
What is meant by dclgen?
What is the maximum size of a char data type in db2?
Mention data types used in db2 ?
Is db2 a mainframe database?
How is a typical db2 batch pgm executed?
What are host variables in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is a db2 tablespace?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the maximum No of rows per page?
How do I connect my db2 database to ibm?
How do we specify index to include or not during bind process.
What is the latest version of ibm db2?
