can SQLCODE 100 be tracked using DSNtep2 utility?

Sriram K · New User Joined: 17 Feb 2009 Posts: 32 Location: Bangalore

Hi,

In my JCL there are 2 steps.

1 step - to update the table.
2 step - if updates are done, im writing some message to other tables.

Problem im facing:

In step-1 im using DSNTEP2 utility to update the table. Here even though there are SQLCODE 100 while updating, its giving me a succesful return code 0 for that step because of which step 2 starts executing.

If i get SQLCODE 100 or any bad return code i don't want to perform step 3 (next step). Can you suggest me on this.

Escapa · Posted: Mon Aug 24, 2009 2:50 pm

Hi Sriram,

DSNTEP2 doesnt have lot of flexibility,
Rather you should handle this in program (may be COBOL or PL1 or what ever is there at your shop)

Srihari Gonugunta · Posted: Mon Aug 24, 2009 2:52 pm

Hi Sriram,
You can try using PREPWARN YES, which will set the return code of the step to 4 for a warning. You can use the condition code to run the next step.

Please refer the following link for more information.

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnugk10/APPENDIX1.4.3?ACTION=MATCHES&REQUEST=DSNTEP2&TYPE=FUZZY&SHELF=&DT=20070125001207&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

Sriram K · New User Joined: 17 Feb 2009 Posts: 32 Location: Bangalore

Hi srihari,

Thanks for your suggestion. Can you please let me know how to specify PREPWARN in JCL. I wrote like below

RUN PROGRAM(DSNTEP4) PLAN(DSNTEP4) PREPWARN(YES)

It gave me invalid keyword PREPWARN.

dbzTHEdinosauer · Posted: Mon Aug 24, 2009 3:17 pm

Sriram,

From the link provided, that you obviously did not bother to read:

RUN PROGRAM(DSNTEP2) PLAN(DSNTEP91) PARMS('/ALIGN(LHS) MIXED TOLWARN(YES)') -
LIB('DSN910.RUNLIB.LOAD')

Escapa · Posted: Mon Aug 24, 2009 3:49 pm

Looks like PREPWARN is available in DB2 9.1 not in DB2 8 which I am using..

Sriram K · New User Joined: 17 Feb 2009 Posts: 32 Location: Bangalore

Hi dick,

Because of lack of knowledge i was searching for the specific keyword
PREPWARN. Thanks for the information. going forward i won't repeat.

And when i use the above satement LIB('DSN910.RUNLIB.LOAD')

im getting error IKJ56228I DATA SET DSN910.RUNLIB.LOAD NOT IN CATALOG OR CATALOG CAN NOT BE ACCESSED.

Srihari Gonugunta · Posted: Mon Aug 24, 2009 4:18 pm

Sriram,
You have to use the loadlibs specific to your site. Please use your original job by changing the parms.