Page 1 of 1

Outrec in the Join Main Task

PostPosted: Sun Jun 24, 2012 5:48 pm
by ajuatsgp
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.

Re: Outrec in the Join Main Task

PostPosted: Mon Jun 25, 2012 9:14 pm
by skolusu
ajuatsgp,

Please post the complete SYSOUT from the job including the messages from JNF1JMSG and JNF2JMSG.

Re: Outrec in the Join Main Task

PostPosted: Mon Jun 25, 2012 9:43 pm
by ajuatsgp
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

Re: Outrec in the Join Main Task

PostPosted: Mon Jun 25, 2012 10:20 pm
by skolusu
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.

Re: Outrec in the Join Main Task

PostPosted: Tue Jun 26, 2012 12:55 am
by ajuatsgp
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

Re: Outrec in the Join Main Task

PostPosted: Tue Jun 26, 2012 8:47 am
by ajuatsgp
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,

Re: Outrec in the Join Main Task

PostPosted: Tue Jun 26, 2012 1:27 pm
by BillyBoyo
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?

Re: Outrec in the Join Main Task

PostPosted: Tue Jun 26, 2012 8:59 pm
by ajuatsgp
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.

Re: Outrec in the Join Main Task

PostPosted: Tue Jun 26, 2012 9:17 pm
by BillyBoyo
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.