Versions Compared

Old Version 1

changes.mady.by.user user-cd56b

Saved on

compared with

New Version 2

changes.mady.by.user user-cd56b

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

[ Image Removed |../../index.htm#lansa/l4wtgu03_0550.htm]
You are here:

...

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
[ Image Removed |../../index.htm#lansa/l4wtgu03_0550.htm]