Page 1 of 1

reading a row from table and writing a record into file

PostPosted: Fri Apr 09, 2010 12:53 pm
by pradeepgowda
suppose we are reading a db2 table and writing into a file. the table has 1 million records. if program abends in between will the program has to be started from the beginning. if we want to restart from the last accessed row from the table without having impact to the allready written records into file. how to proceed.how the output file needs to be handled

Re: reading a row from table and writing a record into file

PostPosted: Sat Apr 10, 2010 12:30 am
by dick scherrer
Hello,

Suggest you plan on restarting from the beginning. . .

If your environment does not already have restart/recovery mechanics in place, you do not want to try to do this for one program/process.