Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Disregard errors & continue processing batch SQL w/ IKJE

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Lori

New User


Joined: 18 Jun 2010
Posts: 1
Location: Poughkeepsie NY

PostPosted: Fri Jun 18, 2010 7:29 pm    Post subject: Disregard errors & continue processing batch SQL w/ IKJE
Reply with quote

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
View user's profile Send private message

Pradip kumar Mohanty

New User


Joined: 16 Sep 2007
Posts: 33
Location: India

PostPosted: Sun Jun 20, 2010 12:26 am    Post subject:
Reply with quote

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
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Sun Jun 20, 2010 12:35 am    Post subject:
Reply with quote

Quote:
Is there a way to write these records to a file and continue deleting records?
Isn't that called 'programming'?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Jun 20, 2010 1:39 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How does a called pgm know if its cal... Graeme Westerman COBOL Programming 4 Tue Nov 29, 2016 9:25 pm
This topic is locked: you cannot edit posts or make replies. MIPS reduction for Batch job Virendra Shambharkar All Other Mainframe Topics 8 Mon Nov 07, 2016 4:02 pm
No new posts Run stats processing on zIIP Engine Virendra Shambharkar DB2 9 Fri Oct 14, 2016 10:24 am
This topic is locked: you cannot edit posts or make replies. Job to wait and continue based on reply yugendran COBOL Programming 5 Wed Oct 05, 2016 1:46 pm
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us