Joined: 18 Jun 2010 Posts: 1 Location: Poughkeepsie NY
Is there a way to disregard errors and continue processing when using IKJEFT01 to execute SQL? For example, when using DSNUPROC to load DB2 tables you can code DSNUPROC.SYSDISC to have records that can't be loaded written to a file so the load can continue.
I'm using IKJEFT01 to delete records from a DB2 table. The job runs A LONG TIME so when I encounter a record that can't be deleted & the job abends IT'S VERY FRUSTRATING. Is there a way to write these records to a file and continue deleting records? If not, is there a DB2 utility I could use to accomplish the same thing?