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
