|
View previous topic :: View next topic
|
| Author |
Message |
Lori
New User
Joined: 18 Jun 2010
Posts: 1
Location: Poughkeepsie NY
|
|
|
|
Hi All,
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?
Thanks in advance! |
|
| Back to top |
|
 |
Pradip kumar Mohanty
New User
Joined: 16 Sep 2007
Posts: 33
Location: India
|
|
|
|
Are you doing a mass DELETE ? Then try with TRUNCATE ( Just try it, though it wont aleviate any "real" issues that you are encountering).
BTW, do you have a clue on the reason for " record that can't be deleted "
My next thougt is - Exit routines (?). Anybody ? |
|
| Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table
|
|
|
|
| Quote: |
| Is there a way to write these records to a file and continue deleting records? |
Isn't that called 'programming'? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Suggest the issue with rows that cannot be deleted be addressed.
One of the problems wth the "shortest" solutions is the lack of elegance. As long as an "all or nothing" process will suffice, cool. If you want custom results, you will need to provide for them.
Usully, some kind of meaningful audit trail is needed as well. . . |
|
| Back to top |
|
|
|
|
