Need to set Return code = 0 for a JCL statement

kushal Bothra · New User Joined: 16 Feb 2011 Posts: 38 Location: Gurgoan

Hi

I have a DROP VIEW step in JOB and in case the view doesnot exists my JCL gives a return code of 8. I need that the return code of my JCL should always be 0.

Can I set it in any way,,,

Thanks
Kushal

Pandora-Box · Posted: Mon Oct 22, 2012 1:45 pm

Hi Kushal,

This Query Belongs to JCL forum and not Cobol

Gnanas N · Posted: Mon Oct 22, 2012 1:53 pm

Hi Kushal,

If you're with z/OS Version 1 Release 13, please review JOBRC Parameter of JOB statement.

And, your scheduling package might have a functionality to do this.

enrico-sorichetti · Posted: Mon Oct 22, 2012 1:55 pm

kushal Bothra · New User Joined: 16 Feb 2011 Posts: 38 Location: Gurgoan

I have the JCL step where I am getting RC 8
//DB2SQDV EXEC DB2SQL
//DB2SAUTH DD *
PI000004
/*
//SYSIN DD *
DROP VIEW PI000004.PI@PPDI;

so to achive overall RC 0 I should code in the jobcard
| JOBRC= {8}
| {0}
| {DB2SAUTH}

Is it ?

Gnanas N · Posted: Mon Oct 22, 2012 2:08 pm

Please try and let us know the result.

kushal Bothra · New User Joined: 16 Feb 2011 Posts: 38 Location: Gurgoan

one help how do we use JOBRC ?
KUSDVIEW JOB (D03,07PI),'DROP VIEW TEST',
MSGCLASS=D,NOTIFY=Z099,GROUP=Z099,
JOBRC(8,0,DB2SQDV)

This is definately wrong as I am getting following errors on JJ

LABEL SV MSG.NO. ERROR MESSAGE
-------- -- -------- -------------------------------------------------
.JAAA 8 DSS6160E - "(" IS AN INVALID DELIMITER AS USED
.JAAA 8 DSS1090E - INCORRECT POSITIONAL PARAMETER - "JOBRC "
.JAAA 8 DSS1090E - INCORRECT POSITIONAL PARAMETER - "8 "
.JAAA 8 DSS1090E - INCORRECT POSITIONAL PARAMETER - "0 "
.JAAA 8 DSS6070E - UNEQUAL NUMBER OF RIGHT PARENTHESES

Bill Woodger · Posted: Mon Oct 22, 2012 2:43 pm

Forget JJ. Toss a little test JCL into the system. Consult the current JCL manual. Look at any error messages.

kushal Bothra · New User Joined: 16 Feb 2011 Posts: 38 Location: Gurgoan

Tried running the JCL by appending JOBRC(8,0,DB2SQDV) gettin error JCL ERROR INCORRECT POSITIONAL PARAMETER - "JOBRC "

Checked the system its :-- JES: JES2 z/OS1.12

Akatsukami · Posted: Mon Oct 22, 2012 3:06 pm

kushal Bothra · New User Joined: 16 Feb 2011 Posts: 38 Location: Gurgoan

Any other option to change RC of a particular step from 8 to 0 or if any step in my JCL is ending with maxcc 8 can by any option my JCL end with RC 0 .. ?

kushal Bothra · New User Joined: 16 Feb 2011 Posts: 38 Location: Gurgoan

enrico-sorichetti · Posted: Mon Oct 22, 2012 3:37 pm

Robert Sample · Posted: Mon Oct 22, 2012 4:15 pm

kushal Bothra · New User Joined: 16 Feb 2011 Posts: 38 Location: Gurgoan

Thanks Robert Comments kept in mind

don.leahy · Posted: Mon Oct 22, 2012 5:46 pm

One solution is to alter the program that is running your SQL statement. If I recall correctly, IBM supplies the source code for DSNTEP2/4, DSNTIAUL and DSNTIAD. You can modify it if you wish.

Another option is to write your own simple DSNREXX program to issue the DROP. It is not as difficult as you might think; the Rexx program can read the DROP from the SYSIN and pass it as a string to the EXECUTE IMMEDIATE SQL statement. You are then free to handle the SQLCODE as you wish.