RELATE Right Outer Join Option
The RELATE "Right Outer Join" Option
The /J option on the RELATE Command is called the "Right Outer Join" option.
With the /J option in effect,
whenever a record from the raw input collection is inserted into the
RELATE output collection, that record is removed from the raw
input collection.
When the RELATE command is complete, the raw input collection contains
the residue of records that were not included in the RELATE result.
These are the orphans; they are known in SQL parlance as right orphans.
These orphans can then be processed by the application to produce the
effect of a "Right Outer Join".
Note that the process of removing a record from a collection does not
delete the record from the data base.