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)
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)
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.