IBM Mainframe Forum

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

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.