• Created by user-cd56b, last updated on May 14, 2022 2 minute read

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Mandatory.

The type of predetermined joined column to be assigned to the 3.6.1 PJC Column.

The PJC type is checked against the 3.5.7 Maximum Records specified for the access route.

Rules

  • Columns with value of *SQLNULL are ignored.

Allowable values are:

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.

 Also See

3.6.4 PJC Source Column

  • No labels