| View previous topic :: View next topic |
| Author |
Message |
vak255
Intermediate
Joined: 10 Sep 2004
Posts: 384
Topics: 79
|
 Posted: Sat Jul 07, 2012 12:57 pm Post subject: Unoload job ends with maxxcc 4 |
 |
|
The below unload job successfully unloads the required data but I am getting maxcc=4. I check the logs but nothing tells me why the completion code is not zero. I am new to do unloads, so i am not sure if this is the case with unloads? any advise on this, Thanks.
| Code: |
//UNLDCARD EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSPRINT DD SYSOUT=*
//PRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//OUTRECS DD SYSOUT=*
//SYSPUNCH DD DUMMY
//SYSREC00 DD DSN=ICZ38X.NVDXTDN.UNLOAD02, --- OUTPUT
// DISP=(,CATLG,DELETE),
// SPACE=(TRK,(10,10),RLSE),UNIT=SYSDA
//SYSIN DD DISP=SHR,DSN=ICZ38X.DB2.SQL(NVDBPROD)
//SYSTSIN DD DISP=SHR,DSN=ENS.PROD.SLTA.CNTL(DSNTIA51)
//
|
| Quote: |
*---------------------------------
* HIGHEST CONDITION
* JOBNAME CODE
*
* ICZ38XUL 0004 0
*--------------------------------- |
[/code] |
|
| Back to top |
|
 |
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Sat Jul 07, 2012 1:05 pm Post subject: |
|
|
more than likely that there is some message about the record length for sysrec00.
you have not gone thru all the logs..............
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Sat Jul 07, 2012 1:42 pm Post subject: Re: Unoload job ends with maxxcc 4 |
|
|
| vak255 wrote: | | The below unload job successfully unloads the required data but I am getting maxcc=4. I check the logs but nothing tells me why the completion code is not zero. I am new to do unloads, so i am not sure if this is the case with unloads? any advise on this, Thanks. |
If you are running DSNTIAUL utility to unload data and if you are coding a SQL instead of just specifying the just the table name , it sets the return code to 4. You need to check the messages in SYSTSPRT which will tell you as to why the return code of 4 is set.
Check this link for DSNTIAUL return codes |
|
| Back to top |
|
|
vak255
Intermediate
Joined: 10 Sep 2004
Posts: 384
Topics: 79
|
| Posted: Sat Jul 07, 2012 3:00 pm Post subject: |
|
|
yes, I used a select statement to unload a particular field in the table.
that explains it.
Thanks Kolusu for the quick response. |
|
| Back to top |
|
|
vak255
Intermediate
Joined: 10 Sep 2004
Posts: 384
Topics: 79
|
| Posted: Sat Jul 07, 2012 3:03 pm Post subject: |
|
|
I have the SQL
| Code: | | SELECT VNDR_NUM FROM NVDXTDN WITH UR; |
any suggestion on how should I change this; if I need to get maxcc 0. |
|
| Back to top |
|
|
papadi
Supermod
Joined: 20 Oct 2009
Posts: 594
Topics: 1
|
| Posted: Sat Jul 07, 2012 4:24 pm Post subject: |
|
|
Why do you believe you need a zero?
| Quote: |
if you are coding a SQL instead of just specifying the just the table name , it sets the return code to 4.
|
This is normal and not an error. . .
_________________
All the best,
di |
|
| Back to top |
|
|
vak255
Intermediate
Joined: 10 Sep 2004
Posts: 384
Topics: 79
|
| Posted: Sat Jul 07, 2012 8:02 pm Post subject: |
|
|
Thanks di.
I thought there might me something i am missing. I got it. |
|
| Back to top |
|
|
papadi
Supermod
Joined: 20 Oct 2009
Posts: 594
Topics: 1
|
| Posted: Sat Jul 07, 2012 9:40 pm Post subject: |
|
|
You're welcome - good luck  |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
