You are here: LANSA for i User Guide > 3. Files > 3.14 Access Routes to Other Files > 3 14 6 Detailed Predetermined Join Field Review

3.14.6 Detailed Predetermined Join Field Review

This window is displayed when:

 

 

 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:

 

 

 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:

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:

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 the relationship is 1 to many and the selected field in the accessed file is a numeric field:

See end of this section for Prompt details.

See end of this section for Prompt details.

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:

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.