I have a cobol code which uses a DB2 SELECT query to unload all the data present in the DB2 table and then write it to a flat file.
My question is, if during the execution of this DB2 select query, if due to any reason(DB2 region down, etc.), job abends, then i need to restart the job
again and the execution should start from the last row fetched before abend.
Is this possible ? If Yes, then how?
(Note: SELECT query includes data to be fetched from 5 DB2 tables)
Kindly assist me on this.