Ron, Since you are using VTOF, I am guessing that your input files are VB and if they are indeed VB pay attention to the matching key field positions you have specified and correct it. You need to realize that for VB files that the actual data starts from position 5. It would be nice if you specify the product(DFSORT/Syncsort) you are using too
Thanks, Kolusu DFSORT Development From: Ron Thomas <ron5...@gmail.com> To: IBM-MAIN@LISTSERV.UA.EDU Date: 08/06/2015 01:16 PM Subject: Sort Join keys Sent by: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> 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 lists...@listserv.ua.edu with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN