You are here: LANSA for i User Guide > 3. Files > 3.14 Access Routes to Other Files > 3.14.5 Display Fields in Accessed File

3.14.5 Display Fields in Accessed File

The Select Fields from Source File screen is displayed as:

 

 DC@P200903         Select Fields from Source File                     

                                                                       

 Access Route: XXXXXXXXXX   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  (XXXX )

 Source File:  XXXXXXXXXX   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX         

                                                                       

 Select   Source field to define Predetermined Join Fields             

                                                                       

  Sel   Field       Description                         Type Len Dec   

   _    XXXXXXXXXX  XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  X   999  9    

   _    XXXXXXXXXX  XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  X   999  9    

   _    XXXXXXXXXX  XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  X   999  9    

   _    XXXXXXXXXX  XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  X   999  9    

                                                                       

                                                                       

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

                                                                       

 

 

Working from this screen you can:

Select a field from the accessed file for review/change/create or deletion of Predetermined Join Fields. To do this enter any non-blank character in the column labeled "Sel" against the required field. The resulting display will depend on the relationship defined on the access route and the type of field selected.