Joining two files
You can perform various types of "join" applications on two files
(F1 and F2) by one or more keys.
- JOINKEYS
- One JOINKEYS statement is required for each input file to indicate the ddname of the file, describe the keys, indicate whether the file is already sorted by those keys, and so on.
- JOIN
- An inner join is performed by default, but a JOIN statement can be used to specify a different type of join.
- REFORMAT
- Describes the fields from the two files to be included in the joined records, and optionally an indicator of where the key was found ('B' for both files, '1' for file1 only or '2' for file2 only.
The three JOINKEYS application control statements (JOINKEYS, JOIN and REFORMAT) are completely described in Using a JOINKEYS application for joining two files.