Home page  
Help >
RELATE Right Outer Join Option
Version 7.11
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.

Copyright © 2019 , WhamTech, Inc.  All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. Names may be trademarks of their respective owners.