Versions Compared

Old Version 2

changes.mady.by.user user-2c621

Saved on

compared with

New Version Current

changes.mady.by.user user-2c621

Saved on

Key

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

...

  • 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                           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                       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 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:

...

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:

...

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 to 3.10.1 Select Fields When Working from File Definition Menu for more details.