MVSFORUMS.com

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

Hi,

I have for eg. some 1000 records in a table. my application program is reading each record one by one. at particular record the job is abending. How to skip that record and process the remaining records.

this is an interview question. Pls. give a sol. how to do that.

Thanks
nadh

Cogito-Ergo-Sum · Posted: Sun Jul 31, 2005 1:41 am Post subject:

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

Hi,

Don't want to reprocess the records before the record that cause the ABEND. Just want to proceed the execution with re remaining records, discarding the RECORD which caused the ABEND.

thanks
nadh

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

nadh,
First define the abend - is it DB2 or Application or System. If DB2 then check the return code and bypass it, if application related then analyze under what conditions the abend occurs and programatically bypass. If system abend, identify and fix it. Restart/reposition is a different subject. Thanks

schintala · Posted: Mon Aug 01, 2005 8:11 am Post subject:

I would do by pass the record after checking the SQL code and continue to process the rest of records.