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