Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Generate public-private key in batch ... vasanthz All Other Mainframe Topics 3 Fri Sep 15, 2017 9:20 am
No new posts Working with hex values in Filemanage... Emile Straker IBM Tools 0 Tue Sep 12, 2017 1:42 am
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm
No new posts processing a XML file in PL/1 grvtomar PL/I & Assembler 2 Fri Jun 09, 2017 1:07 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us