Jack Your file2 might have duplicate matched key records.
Thanks Arun On Tue, Aug 12, 2025, 8:08 AM Jack Zukt < [email protected]> wrote: > Hi Massimo, > > Thank you for your answer. > I have tried JOIN UNPAIRED,F1, but I still end up with many more records > than there are on my F1 file (103,630/63,026) > Regards > Jack > > > On Tue, 12 Aug 2025 at 12:43, Massimo Biancucci < > [email protected]> wrote: > > > Jack, > > > > you have to ask for: > > JOIN UNPAIRED,F1 > > > > this means you need all records from F1 even though they do not match. > > > > Best regards. > > Max > > > > Il giorno mar 12 ago 2025 alle ore 13:29 Jack Zukt < > > [email protected]> ha scritto: > > > > > Hi all, > > > > > > I am trying to join records from two files, with a match on a field. > The > > F1 > > > file has 63026 records and I am trying to get additional information > from > > > the second file which has a lot more records (over 340000). What I need > > is > > > a file that will have all the records from F1, with additional > > information > > > from F2, when there is a match, or wit only the F1 information, when > > there > > > is not. > > > I am running this SORT statements: > > > > > > JOINKEYS F1=IN1,FIELDS=(DSN1,A) > > > JOINKEYS F2=IN2,FIELDS=(DSN2,A) > > > REFORMAT FIELDS=(F1:DSN1,CRDATE1,LRDATE1, , > > > F2:CRDATE2,LRDATE2,CRJOB2,CRPGM2) > > > > > > and my output file has 91894 records. I have been looking to the JOIN > > > statement and, if I am seeing this right (which obviously I am not), > as I > > > am not specifying a JOIN statement, the output file should only have > > paired > > > records from F1 and F2 > > > What am I missing? I am sure that it will be something painfully > obvious. > > > Thank > > > Regards > > > Jack > > > > > > ---------------------------------------------------------------------- > > > 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 > > > > ---------------------------------------------------------------------- > 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
