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
