3.6.3 PJC Type

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