Outrec in the Join Main Task



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Outrec in the Join Main Task

Postby ajuatsgp » Sun Jun 24, 2012 5:48 pm

Hi,

JOINKEYS F1=FILE1,FIELDS=(01,19,A)
JOINKEYS F2=FILE2,FIELDS=(18,19,A)
REFORMAT FIELDS=(F1:1,80,F2:1,57)
OPTION COPY
INCLUDE COND=(21,1,ZD,EQ,1,AND,43,1,ZD,EQ,0)                          -
OUTREC BUILD=(C'D',C',',3:81,7,Y4T,TOGREG=Y4T,C',',12:89,6,C',',      -
        19:23,19,C',',39:118,20,30X,C',',90:01,16,C',',               -
        C'CUSTOMER SERVICES',13X,C',')
//JNF1CNTL DD *
INREC BUILD=(1:4,19,21:923,1,23:490,19,43:29,1,44:44,37)

My output file is doing only the join; INCLUDE COND and OUTREC is not happening.
I have also tried below,but still INCLUDE COND and OUTREC is not happening.
JOINKEYS F1=FILE1,FIELDS=(01,19,A)
JOINKEYS F2=FILE2,FIELDS=(18,19,A)
REFORMAT FIELDS=(F1:1,80,F2:1,57)
SORT FIELDS=(1,19,CH,A)
INCLUDE COND=(21,1,ZD,EQ,1,AND,43,1,ZD,EQ,0)                          -
OUTREC BUILD=(C'D',C',',3:81,7,Y4T,TOGREG=Y4T,C',',12:89,6,C',',      -
        19:23,19,C',',39:118,20,30X,C',',90:01,16,C',',               -
        C'CUSTOMER SERVICES',13X,C',')
//JNF1CNTL DD *
INREC BUILD=(1:4,19,21:923,1,23:490,19,43:29,1,44:44,37)

Please let me know how to do the OUTREC in the MAIN TASK of JOIN.
ajuatsgp
 
Posts: 82
Joined: Thu May 20, 2010 6:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Outrec in the Join Main Task

 

Re: Outrec in the Join Main Task

Postby skolusu » Mon Jun 25, 2012 9:14 pm

ajuatsgp,

Please post the complete SYSOUT from the job including the messages from JNF1JMSG and JNF2JMSG.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: Outrec in the Join Main Task

Postby ajuatsgp » Mon Jun 25, 2012 9:43 pm

Dear Skolusu,
Sorry I am at home now tomorrow I can give all those details.But I guess by that time you will be out of work and hence you can see my SYSOUT and JNF1/F2JMSG
after 24 hrs from now.
If you don't mind could you please tell what should I look in the SYSOUT message to know why is the Outrec not happening,so that tomorrow morning I can do some research on that before getting back to you.
Last but not least I would like to tell you I had seen the SYSOUT msg last time when I had run the job but could not find any error message,may be I had missed something.

Let's wait till tomorrow.

Thanks
ajuatsgp
 
Posts: 82
Joined: Thu May 20, 2010 6:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Outrec in the Join Main Task

Postby skolusu » Mon Jun 25, 2012 10:20 pm

ajuatsgp wrote:Dear Skolusu,
Sorry I am at home now tomorrow I can give all those details.But I guess by that time you will be out of work and hence you can see my SYSOUT and JNF1/F2JMSG
after 24 hrs from now.
If you don't mind could you please tell what should I look in the SYSOUT message to know why is the Outrec not happening,so that tomorrow morning I can do some research on that before getting back to you.
Last but not least I would like to tell you I had seen the SYSOUT msg last time when I had run the job but could not find any error message,may be I had missed something.

Let's wait till tomorrow.

Thanks



ajuatsgp,

Your OUTREC statement is creating a 137 byte record. So I would check and see if that is true first. If it is not then I would check the parameter SOLRF. OPTION NOSOLRF will not let DFSORT calculate the length from INREC/OUTREC/OUTFIL.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: Outrec in the Join Main Task

Postby ajuatsgp » Tue Jun 26, 2012 12:55 am

Dear Skolusu,
Initially I had coded outrec in separate step,but later when I modified my job to save few steps and adding the OUTREC in the Maintask of Join,I could see my output files length as 137 but without desired format change from OUTREC.
For your reference I will post the SYSOUT for double confirm,allow me some time.

Thanks,
Akhilesh
ajuatsgp
 
Posts: 82
Joined: Thu May 20, 2010 6:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Outrec in the Join Main Task

Postby ajuatsgp » Tue Jun 26, 2012 8:47 am

I have checked the SYSOUT the SOLRF option is Y
ICE133I 0 OPTIONS: HIPRMAX=400    ,DSPSIZE=400 ,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAMIO=N,MOSIZE=400


This is same in both JNF1JMSG and JNF2JMSG.
Please let me know if you still want me to copy all the SYSOUT and JNF1/F2JMSG.

Thanks,
ajuatsgp
 
Posts: 82
Joined: Thu May 20, 2010 6:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Outrec in the Join Main Task

Postby BillyBoyo » Tue Jun 26, 2012 1:27 pm

If you can post the whole thing it would be easiest. As long as you get it in the Code tags (like you did above) don't worry about the size.

You have those "-"s for some reason. What column are they in in your sort deck?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Outrec in the Join Main Task

Postby ajuatsgp » Tue Jun 26, 2012 8:59 pm

My OUTREC is working fine now.
Once I was using OUTREC in one of my JCL,that time I had to give "-" in 72 column as continuation,so in this case I was using those "-" for continuation.But when I removed them in this case I got my desired output.
Thanks BillyBoyo.
ajuatsgp
 
Posts: 82
Joined: Thu May 20, 2010 6:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Outrec in the Join Main Task

Postby BillyBoyo » Tue Jun 26, 2012 9:17 pm

No problem. Couldn't be certain in the Code tags which column. Having done the continuation, I think they would just have been treated as comments.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post