Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 58408 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 various types of locks in db2?
What is a system catalog table in db2?
What is declare cursor?
What is cobol db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How do you find the maximum value in a column in db2?
What is an instance in db2?
How to rename a table in DB2 ?
What are the rules for db2 programming?
What are foreign keys in db2?
Explain the benefits you can get from mainframe connect?
How and when does the db2 enforces the unique key?
Comment whether the cursor is closed during commit or not.
Where can you declare a cursor in a cobol-db2 program?
What is a db2 package?
