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?
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.