PJF Type
Mandatory.
Specify the type of predetermined joined field to be assigned to the PJF Field.
The PJF type is checked against the Maximum Records specified for the access route.
Rules
- Fields with value of *SQLNULL are ignored.
Allowable values are:
|
Lookup |
Specifies that the predetermined join field will hold the value retrieved from the selected PJF Source Field in the accessed file. This option is only available when there is a 1:1 relationship between the files. Refer to Maximum Records and Keep Last. The predetermined join field must be of the same type as the selected field. |
|
Total |
Specifies that the predetermined join field is to hold the total of the selected PJF Source Field retrieved using the access route key. This option is only available when there is a 1:many relationship between the files and the selected field is numeric. Refer to Maximum Records. |
|
Maximum |
Specifies that the predetermined join field is to hold the highest value of the PJF Source Field selected field in records retrieved using the access route key. This option is only available when there is a 1:many relationship between the files and the selected field is numeric. Refer to Maximum Records. |
|
Minimum |
Specifies that the predetermined join field is to hold the lowest value of the selected PJF Source Field in records retrieved using the access route key. This option is only available when there is a 1:many relationship between the files and the selected field is numeric. Refer to Maximum Records. |
|
Average |
Specifies that the predetermined join field is to hold the average value of the selected PJF Source Field in records retrieved using the access route key. This option is only available when there is a 1:many relationship between the files and the selected field is numeric. Refer to Maximum Records. |
|
Count |
Specifies that the predetermined join field is to hold the count of the number of fields retrieved using the access route key. This option is only available when there is a 1:many relationship between the files. Refer to Maximum Records. |
Also See