Receiving with Field Missing Records Joined
The joining of records from several files could fail because one or more records is missing. For example, the record containing part number 221 might not be found in the INVENTORY file. This means that the records that can be joined to the 1st, 7th, and 12th records in the SUPPLIERS file do not exist in the INVENTORY file. In this case, the PARTNO field and PRICE field for part number 221 can be determined, but the DESCRIPTION field cannot be determined. So, the DESCRIPTION field is missing.
To transfer field missing records, use Return Record at Missing Field Value.
When Return Record at Missing Field Value has
been specified, the default iSeries™, eServer™ i5,
or System i5™ values are transferred instead of the
missing field values. The default values for character fields are
blanks, while those for numeric fields are zeros. For example, if
the INVENTORY file does not contain the part number 221 record, the
result of the previous example will be as follows:
Field: PARTNO DESCRIPTION PRICE
------ ----------- -----
Record 1: 221 .30
2: 231 NUT .10
If Return Record at Missing Field Value has
not been specified, the field missing records are not transferred.
For example, if the INVENTORY file does not contain the part number
221 record, the result of the previous example will be as follows:
Field: PARTNO DESCRIPTION PRICE
------ ----------- -----
Record 1: 231 NUT .10