To describe a join specification do the following:
- Specify J in position 17 immediately after the record level (before the
first field name in positions 19 through 28). J in position 17
indicates the beginning of a join specification.
- Specify the JOIN keyword. The JOIN keyword is optional when only
two files are specified on the JFILE keyword. When more than two
physical files are specified on the JFILE keyword, one JOIN keyword is
required for each secondary file.
- Specify the JFLD keyword at least once for each join specification.
- The end of the join specification is indicated by another J in position 17
or by a field name specified in positions 19 through 28.
There must be one join specification for each secondary file specified on
the JFILE keyword. Therefore, at least one join specification is
required in a join logical file.
You can specify the JOIN keyword only once within a join
specification.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.