View previous topic :: View next topic
|
Author |
Message |
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Hi All,
I'm getting return code 4 while using a partial DB2 unload. But return code while full unload.
Utility - IKJEFT01
Full unload
Code: |
SELECT * from TABLE-NAME; |
Partial Unload
Code: |
SELECT Column1, CHAR('|'), Column3, CHAR('|'),Column7
from TABLE-NAME.
|
I see an information message in the SYSPRINT,
Code: |
DSNT506I INPUT STATEMENT WAS NOT A FULL SELECT ON A SINGLE TABLE. LOAD STATEMENT NEED MODIFICATION.
But Its Quick Reference has the severity 4 (Warning).
|
Is there anyway I can suppress the return code to 0 in case of partial unload. |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
No, and why should there be? DSNUTILB is warning you that your SELECT statement is sketchy, if not actually wrong, and that you may want to correct it?
What horrors do you expect to happen if the job ends with CC=4? |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
IIRC DSNTIAUL returns you CC=4 always |
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
It's doing you a favour by warning you that the LOAD control cards (see SYSPUNCH dd) that it generated will require modification before you can use them. It is normal, and if you don't intend to use the LOAD control cards, then just ignore the RC. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
May be you did not set up your Max RC to 4 and hence it's not acceptable to the scheduling and your whole stream is on hold. And now you want this job to give you 0 so that the rest application works fine. So if this is true ( of course because there is no harm having RC4) then you better change your scheduling and say 4 is also acceptable.
Look for IDCAMS and may add another step to set to 0 for the whole job but that not at all advised to do. |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Quote: |
Look for IDCAMS and may add another step to set to 0 for the whole job but that not at all advised to do |
I am not sure what you are saying here, Rohit, but if you are saying execute IDCAMS to set the max cc for the job to 0 then I am surprised that you say this. IDCAMS can only affect the return code of its own execution - not other steps. If you need the last step of a job to be 0 then a simple IEFBR14 will do that. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
You are right Nic. I am unsure what I was trying to say then but yeah there is no way we could manipulate the RC of a step (except IDCAMS). |
|
Back to top |
|
|
Abid Hasan
New User
Joined: 25 Mar 2013 Posts: 88 Location: India
|
|
|
|
To Rohit and Mr. Clouston's post -
I guess, either way the RC of the 'job' (guessing this is via JCL, DB2 is something that I haven't had a chance to touch so am unsure if this process is running via JCL or not; though will definitely Google it - next thing) won't change to '0', even if last step or any other step for that matter, returns a value <= 4; please correct me if I'm wrong.
If the TS has z/OS 2.x then they can use JOBRC parameters coupled with IDCAMS/IEFBR14/or any program that sets the required RC. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
that's a Good reminder , it seems the only way is to use JOBRC but then TS may Need to adde a dummy step which gets RC 0 and then JOBRC cab be applied on it ; RC cannot be manipulated otherwise.
This is a part of zOS 1.13 enhancement though. |
|
Back to top |
|
|
Abid Hasan
New User
Joined: 25 Mar 2013 Posts: 88 Location: India
|
|
|
|
Aah right, it's 1.13; I'm getting old tad bit too soon |
|
Back to top |
|
|
|