|
|
| Author |
Message |
brahmanandareddy
New User
Joined: 16 Dec 2004
Posts: 48
Location: Hyderabad
|
|
|
|
| I have 2 lakhs records in a table. I used commit for every 1000 records. While running the cobol-db2 program it was abended at 50001st record. I want to run from this record. How should I restart running from 50001st record? |
|
| Back to top |
|
 |
References
|
 Posted: Wed Dec 21, 2005 1:09 am Post subject: Re: How to restart from a particular record |
|
|
|
|
raghunathns
Active User
Joined: 08 Dec 2005
Posts: 130
Location: rochester
|
|
|
|
hi,
there will be a restart table in your environment. if not you create a table for restart.
in your program before commit you write the last record processed key to the restart table and commit. this will happen after each 1000th record.
if it abends after commiting 5000 records. restart table have 5000 record key.
second time you program will check the restart table key and start from > 5000 record key. |
|
| Back to top |
|
|
|
|
