Use this join-level keyword to identify which pair of files are joined by the join specification in which you specify this keyword.
The format of the keyword is:
JOIN(from-file to-file)
This keyword is valid only for join logical files.
You can use file names or relative file numbers to indicate which files are to be joined. You must specify a relative file number if the same file is specified more than once on the JFILE keyword.
If you specify file names, you must select files that you have specified only once on the JFILE keyword. On each JFILE keyword, the from file must occur before the to file.
If you specify numbers, they correspond to the files specified on the JFILE keyword. The following are the valid values:
The from-file number must always be less than the to-file number.
Special rules apply to the order in which you specify from and to files. See Figure 54 for details.
In a join logical file, each secondary file can be a to file only once.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.