> 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
