JFILE (Joined Files) Keyword--Join Logical Files Only for Physical and Logical Files

Use this record-level keyword to identify the physical files containing the data to be accessed through the join logical file you are defining.

The format of the keyword is:

JFILE([library-name/]physical-file-name [..32])

This keyword is similar to the PFILE keyword except it identifies this file as a join logical file. The JFILE keyword is not allowed with the PFILE keyword.

The JFILE keyword is required at the record level in a join logical file. The JFILE keyword requires a minimum of two physical file names. You can specify the same file name more than once.

The first file is called the primary file, which is the file from which the join will begin. All other files are called secondary files. Up to 31 secondary files can be specified (32 total files on the JFILE keyword).

Distributed data management (DDM) files are allowed on the JFILE keyword only when the logical file is being created on a remote system.

The following considerations apply to the order in which you specify physical files on the JFILE keyword:

Note:
If the names in the physical file are not unique, you must specify relative file numbers.