Thank you Arun and Sri You are probably right. As I have said, it should be something painfully obvious. Thank you for the SUM FIELDS suggestion, Regards Jack
On Tue, 12 Aug 2025 at 13:38, Sri Hari Kolusu <[email protected]> wrote: > > 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 > > Jack, > > An educated guess is that you have duplicates on the key in file 2 and > this would end up as cartesian join. > > You can eliminate the duplicates on file2 before the join > > //JNF2CNTL DD * > SUM FIELDS=NONE > //* > > Thanks, > Kolusu > > > ---------------------------------------------------------------------- > 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
