The FIELDS parameter specifies fields to be included in the record produced by the join function.
Each data field specified in the FIELDS parameter is identified by the file it originates from Fn, its position p and length l.
|
Fn: |
The Fn value indicates the input file from which the data field should be copied. Code ‘F1’ for SORTJNF1 and ‘F2’ for SORTJNF2. This field is optional after the first field specification. By default, the file of the prior field specification will be used to determine the current field specification. If your join application requests only the unpaired records from one join input through the JOIN statement, then you may not reference the other join input file in the FIELDS parameter, since no records from that file will ever be selected. For example, if “JOIN UNPAIRED,F1,ONLY” is specified, then F2 may not be used in the FIELDS parameter. |
|
p |
The position value indicates the first byte of the field relative to the beginning of the input record. |
|
l |
The length value indicates the length of the field. |
|
? |
This symbol is used to place a one-byte indicator in the reformatted record that indicates whether the reformatted record is a paired or an unpaired joined record. The indicator will be set to one of three different printable values: “B” if the reformatted record is a paired record “1” if the reformatted record is an unpaired record created from the F1 file “2” if the reformatted record is an unpaired record created from the F2 file ? may only be used once in the FIELDS parameter. If it is followed by any p,l fields, you must specify the Fn: subparameter. If a variable-length reformatted record is created , ? must be placed before any field specifying the variable part of the record. |