Lookup

Specifies that the Predetermined Join Column will hold the value retrieved from the selected 3.6.4 PJC Source Column in the accessed table.

This option is only available when there is a 1:1 relationship between the tables. Refer to 3.5.7 Maximum Records and 3.5.8 Keep Last.

The Predetermined Join Column must be of the same type as the selected column.

Total

Specifies that the Predetermined Join Column is to hold the total of the selected 3.6.4 PJC Source Column retrieved using the access route key.

This option is only available when there is a 1:many relationship between the tables and the selected column is numeric. Refer to 3.5.7 Maximum Records.

Maximum

Specifies that the Predetermined Join Column is to hold the highest value of the 3.6.4 PJC Source Column selected column in records retrieved using the access route key.

This option is only available when there is a 1:many relationship between the tables and the selected column is numeric. Refer to 3.5.7 Maximum Records.

Minimum

Specifies that the Predetermined Join Column is to hold the lowest value of the selected 3.6.4 PJC Source Column in records retrieved using the access route key.

This option is only available when there is a 1:many relationship between the tables and the selected column is numeric. Refer to 3.5.7 Maximum Records.

Average

Specifies that the Predetermined Join Column is to hold the average value of the selected 3.6.4 PJC Source Column in records retrieved using the access route key.

This option is only available when there is a 1:many relationship between the tables and the selected column is numeric. Refer to 3.5.7 Maximum Records.

Count

Specifies that the Predetermined Join Column is to hold the count of the number of columns retrieved using the access route key.

This option is only available when there is a 1:many relationship between the tables. Refer to 3.5.7 Maximum Records.