z/OS DFSORT Application Programming Guide
Previous topic | Next topic | Contents | Contact z/OS | Library | PDF


Joining two files

z/OS DFSORT Application Programming Guide
SC23-6878-00

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.

Go to the previous page Go to the next page




Copyright IBM Corporation 1990, 2014