3 14 6 Detailed Predetermined Join Field Review

LANSA for i

previous page next page

3.14.6 Detailed Predetermined Join Field Review

This window is displayed when:

The relationship is 1 to 1

Reviewing Predetermined Join Fields

Changing Predetermined Join Fields

Creating Predetermined Join Fields

Deleting Predetermined Join Fields

DC@P200904 Select Fields from Source File

Access Route: XXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX (XXXX )

Source File: XXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Select Source field to define Predetermined Join Fields

..........................................

Sel Field D: Nominate Join Fields :en Dec

_ XXXXXXXXXX X: :99 9

_ XXXXXXXXXX X: Look Up... XXXXXXXXXX :99 9

_ XXXXXXXXXX X: Keep Last. 999 :99 9

X XXXXXXXXXX X: :99 9

: :

: Fnn=Help Fnn=Exit Fnn=Cancel :

: Fnn=Messages Fnn=Change :

..........................................

Fnn=Help Fnn=Exit Fnn=Cancel Fnn=Messages

This window is displayed when:

The relationship is 1 to many

Reviewing Predetermined Join Fields

Changing Predetermined Join Fields

Creating Predetermined Join Fields

Deleting Predetermined Join Fields

DC@P200905 Select Fields from Source File

Access Route: XXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX (XXXX )

Source File: XXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Select Source field to define Predetermined Join Fields

..........................................

Sel Field D: Nominate Join Fields :en Dec

_ XXXXXXXXXX X: :99 9

_ XXXXXXXXXX X: Total..... XXXXXXXXXX :99 9

_ XXXXXXXXXX X: Maximum... XXXXXXXXXX :99 9

X XXXXXXXXXX X: Minimum... XXXXXXXXXX :99 9

: Average... XXXXXXXXXX :

: Count..... XXXXXXXXXX :

: :

: Fnn=Help Fnn=Exit Fnn=Cancel :

: Fnn=Messages Fnn=Change :

..........................................

Fnn=Help Fnn=Exit Fnn=Cancel Fnn=Messages

Working from Nominate Join Fields window you can:

Review the Predetermined Join Fields defined to hold the result of the operations displayed when they have been performed on the selected field in the accessed file.

Change the Predetermined Join Fields defined to hold the result of the operations displayed when they have been performed on the selected field in the accessed file. Use the Change function key to indicate that the Predetermined Join Fields are to be changed. The window will be redisplayed in change mode.

Create Predetermined Join Fields. Use the Change function key to indicate new fields are to be added. The window will be displayed in change mode and the new fields can be entered.

Delete Predetermined Join Fields. Use the Change function key to indicate new fields are to be deleted. The window will be displayed in change mode and the fields to be deleted can be cleared (deleted) from the screen fields.

Input Options

The input options depend on the access route relationship.

If any field is left blank it is assumed that the operation is not required. If a partial name or "?" is entered a single field selection screen is displayed. The selection list will be built from the fields in the LANSA data dictionary. Refer to section 3.10.1 Select Fields When Working from File Definition Menu for more details.

The Predetermined Join Field may have the same name as the source field as long as it complies with following rules:

It must exist in the data dictionary.

It must not already exist as a Predetermined join, Virtual or Real field on the file.

It must be of the type specified by the operation and type of the source field as listed below.

No check is made on the Predetermined Join Field's suitability to hold the required information. For example the field in an accessed file which holds an order line value could be used to hold the total of that field but may not be large enough. The developer must decide this type of suitability.

If the relationship is 1 to 1:

Look up: Specifies the Predetermined Join Field that is to hold the value retrieved from the selected field in the accessed file. It will be validated as follows: It must be the same type as the field selected from the accessed file.

Keep Last: Specifies how many occurrences of the field being retrieved are to be stored in memory to reduce I/Os. This value is an attribute of the access route and can only be changed on the access route maintenance screens.

If the relationship is 1 to many and the selected field in the accessed file is a numeric field:

Total: Specifies the Predetermined Join Field to hold the total of the selected field retrieved using the access route key. It must be numeric.

Maximum: Specifies the Predetermined Join Field to hold the highest value of the selected field in records retrieved using the access route key. It must be numeric.

See end of this section for Prompt details.

Minimum: Specifies the Predetermined Join Field to hold the lowest value of the selected field in records retrieved using the access route key. It must be numeric.

See end of this section for Prompt details.

Average: Specifies the Predetermined Join Field to hold the average value of the selected field in records retrieved using the access route key. It must be numeric.

See end of this section for Prompt details.

If the relationship is 1 to many and the selected field in the accessed file is a numeric or an alpha field:

Count: Specifies the Predetermined Join Field to hold the count of the number of records retrieved using the access route key. It will be validated as follows; It must be numeric.

If a partial name or '?' is entered a single field selection screen is displayed. The selection list will be built from the fields in the LANSA data dictionary. Refer to 3.10.1 Select Fields When Working from File Definition Menu for more details.

previous page start next page