Hi Ron, it seems you want only current week unmatched records ....
Is the key up to the number at the end of you post or it's only the first part between "|" ? I've tried the same (I've not the part of the record up to 533) and it seems I've obtained the correct result: //ST002 EXEC PGM=SYNCSORT //SYSOUT DD SYSOUT=* //F1 DD * !AV0000012620009 ! 0.68! !AV0000012621410 ! 1.09! !AV0000012621504 ! 0.88! /* //F2 DD * !AV0000012620009 ! 0.98! !AV0000012621410 ! 1.99! !AV0000012621504 ! 0.98! !AV0000012621502 ! 0.78! /* //SORTOUT DD SYSOUT=* //SYSIN DD * JOINKEYS F1=F1,FIELDS=(1,44,A) JOINKEYS F2=F2,FIELDS=(1,44,A) JOIN UNPAIRED,F2,ONLY OPTION COPY OUTFIL BUILD=(1,80) /* SORTOUT is: !AV0000012620009 ! 0.98! !AV0000012621410 ! 1.99! !AV0000012621502 ! 0.78! !AV0000012621504 ! 0.98! The run was on Syncsort 1.4.1.0 for zOS. I suggest you to double check recfm and key position. Regards. Massimo 2015-08-06 22:15 GMT+02:00 Ron Thomas <[email protected]>: > Hi > > I have 2 files as below, need to compare them and get all the unmatched > records . I used join keys but getting in the output prevoius week records > only. > > Previous Week File > > |AV0000012620009 | 0.68| > |AV0000012621410 | 1.09| > |AV0000012621504 | 0.88| > > Current Week file > > |AV0000012620009 | 0.98| > |AV0000012621410 | 1.99| > |AV0000012621504 | 0.98| > |AV0000012621502 | 0.78| > > > Output > > |AV0000012620009 | 0.68| > |AV0000012621410 | 1.09| > |AV0000012621504 | 0.88| > > Desired o/p > > |AV0000012620009 | 0.98| > |AV0000012621410 | 1.99| > |AV0000012621504 | 0.98| > |AV0000012621502 | 0.78| > > Sort card used > > JOINKEYS F1=SORTIN1,FIELDS=(2,44,A) > JOINKEYS F2=SORTIN2,FIELDS=(2,44,A) > JOIN UNPAIRED,F1,F2,ONLY > OPTION COPY > OUTFIL VTOF,BUILD=(5,133) > > Thanks > Ron T > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
