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
