View previous topic :: View next topic |
Author |
Message |
radkrish Beginner
Joined: 12 Aug 2005 Posts: 102 Topics: 19
|
Posted: Wed Aug 31, 2005 3:51 am Post subject: returning cc=4 while using IKJEFT01 in jcl |
|
|
I received max cc=4 while selecting 2 particular fields from a table using IKJEFT01 in jcl.
the message follows:
Code: | 1 DSNT490I SAMPLE DATA UNLOAD
PROGRAM
0 DSNT505I DSNTIAUL OPTIONS USED: SQL
0 DSNT503I UNLOAD DATA SET SYSPUNCH RECORD LENGTH SET TO 80
0 DSNT506I INPUT STATEMENT WAS NOT A FULL SELECT ON A SINGLE TABLE. LOAD STATEMENT WILL NEED MODIFICATION
0 DSNT503I UNLOAD DATA SET SYSREC00 RECORD LENGTH SET TO 8
0 DSNT504I UNLOAD DATA SET SYSREC00 BLOCK SIZE SET TO 27992
0 DSNT495I SUCCESSFUL UNLOAD 1 ROWS OF TABLE TBLNAME |
but when i select * from the table it gives cc=00
and the message for the same was
Code: | DSNT490I SAMPLE DATA UNLOAD PROGRAM
DSNT505I DSNTIAUL OPTIONS USED: SQL
DSNT503I UNLOAD DATA SET SYSPUNCH RECORD LENGTH SET TO 80
DSNT503I UNLOAD DATA SET SYSREC00 RECORD LENGTH SET TO 3951
DSNT504I UNLOAD DATA SET SYSREC00 BLOCK SIZE SET TO 27657
DSNT495I SUCCESSFUL UNLOAD 1 ROWS OF TABLE aaaaa.bbbbb |
Quote: | 0 DSNT506I INPUT STATEMENT WAS NOT A FULL SELECT ON A SINGLE TABLE. LOAD STATEMENT WILL NEED MODIFICATION |
It says load statement needs to be modified.
what do i modify to get cc=0? |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12370 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
radkrish Beginner
Joined: 12 Aug 2005 Posts: 102 Topics: 19
|
Posted: Wed Aug 31, 2005 11:00 pm Post subject: |
|
|
Kolusu,
Now I changed the extract usage in IKJET01.
I didnt follow SYSREC00 in IKJEFT.Now getting return code 0 from the step itself. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12370 Topics: 75 Location: San Jose
|
Posted: Thu Sep 01, 2005 3:46 am Post subject: |
|
|
Quote: |
Now I changed the extract usage in IKJET01.
I didnt follow SYSREC00 in IKJEFT.Now getting return code 0 from the step itself.
|
Huh ! What did you do to get a return code of 0 ?
Kolusu _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
radkrish Beginner
Joined: 12 Aug 2005 Posts: 102 Topics: 19
|
Posted: Thu Sep 01, 2005 3:58 am Post subject: |
|
|
As i said in my previous post,i didnt follow SYSRECC00 concept.
Instep i used PLINK steplib,
Code: | //SHZC20 EXEC PGM=IKJEFT01,
// DYNAMNBR=20,
// COND=(04,LT)
//*
#SCC,COND=(04,LT,SHZC20)
//*
//STEPLIB DD DSN=SYS2.PLILINK,
// DISP=SHR
//*
//PLIDUMP DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=Z
//*
//SYSTSIN DD * *** CONSTANT CONTROL CARDS ***
DSN SYSTEM(D2P1)
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) PARM('NOSPIE,NOSTAE/')
END |
You have to sort out the resultant output.But it will give cc=0 |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12370 Topics: 75 Location: San Jose
|
Posted: Thu Sep 01, 2005 4:04 am Post subject: |
|
|
radkrish,
You are running DSNTEP2 utility. It has its limitations. The output file LRECL cannot exceed 133 bytes. So if you are unloading the data more than 133 bytes in length then it will be split into mulitple lines.
It adds a delimiter between each column and also daignostic/informational messages in output. You need to remove them and I don't think it is good idea to run a sort step to remove all this just to avoid the return code of 4. What is wrong with return code 4?
Kolusu _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
radkrish Beginner
Joined: 12 Aug 2005 Posts: 102 Topics: 19
|
Posted: Thu Sep 01, 2005 4:10 am Post subject: |
|
|
In CA7,whenever the condition code is 4 then the whole job is moved to abort queue from active running queue.
Here i can use step condition code card to avoid the job being moved to abort queue.But if i get cc=0 i dont want to use #SCC card to the step. |
|
Back to top |
|
|
|
|