Page History
...
When the relationship is 1:many (refer to access route Maximum Records), the operations are TOTAL, MAXIMUM, MINIMUM, AVERAGE, and COUNT. (Also refer to PJC Type in the Technical Reference Guide.)
When the relationship is 1:1 using the key defined on the access route, a single value LOOKUP will be retrieved into the Predetermined Join Column. For example, a product description can be retrieved using the product code if an access route has been defined between an order line table and a product table. A Keep Last value can be nominated to reduce I/Os.
...