Add Files to the List

When the option to 'Add files to list' is chosen from the Work with Export List Menu a screen similar to the following example is used to manipulate the export list:


 DC@P620005           Add File(s) to List                              





 Enter full or partial name of the file definition(s) to be worked     

 With or leave blank to select from all file definitions . . . . P     


       File                                 Comp  Data  Export Export 

 Sel   Name       Library    Description    Form  Also  Fields Function

  _    PSLMST     DC@DEMOLIB Personnel master _     _     _        _ 

  _    PSLSKL     DC@DEMOLIB Personnel skills _     _     _        _ 




 Fnn=Help  Fnn=Exit  Fnn=Generic  Fnn=Cancel  Fnn=Messages  F22=ShowLong



This facility allows you to build temporary lists of file definitions known to LANSA and display them on the screen. From these displayed lists file definitions can be chosen for inclusion into your export list.

Note the use of the words file definition. Only the name of the file definition, which is the same as the associated physical file name, is ever included into the export list. When a file definition is exported, all associated details such as logical views, virtual fields, etc are automatically included.

These lists can be built from all files or only files that have a certain generic name.

A displayed list may not fit onto one screen. This is indicated by a '+' sign in the lower right of the screen. In such cases use the roll up and roll down keys to scroll backwards and forwards through the displayed list.

Files shown in the displayed list which are already included in the export list are shown with an 'X' or 'G' beside them. The 'X' or 'G' cannot be removed. Thus a file cannot be removed from the export list by using this facility. Use the option 'Review/delete objects already in list' to do this. This option is described in detail in a later section.

Long Names

You can show the long name for a file in the list by placing the cursor on it and pressing F22. Refer to Long Names for more details.

The Sel column

Enter 'Y' beside a file displayed in the list to include it in the export list.

Enter 'L' if you want specific logical views to be included for the file. This will display a list of logical views that you can select from.

Enter 'O' if you want to include the I/O or OAM Modules for the file.

For further information on the 'L' and 'O' selectors, refer to Add Logical Views to the list or Add I/O or OAM Modules to the list.

Alternatively you may use the Generic function key to add the generic name into the export list. Generic names are described in detail in Generic Object Names.

Note: The 'Comp Form' and 'Data Also' columns are used when performing an IBM i export from LANSA. They are ignored when performing a PC export.

The 'Comp Form' column

Beside a chosen file, enter a 'Y' to indicate that the file definition is to be exported in 'compiled' or 'ready to use' form. If this option is used, the file will be usable as soon as it has been imported into the target system. If this option is not used, the file definition will have to be 'made operational' on the target system after it has been imported.

If L or O is already displayed, you can't change them.

'L' indicates that individual logical views have been selected for the file.

'O' indicates that an OAM or/and I/O module has been selected.

The 'Data Also' column

Beside a chosen file, enter 'Y' in this column to indicate that the data contained in the file should be exported as well. If this option is used, the data in the file will replace any data already in the file on a target machine. If this option is not used, data already in the file on a target machine will be left intact (after undergoing any necessary conversion to match the new file layout).

When 'Data Also' = Y then 'Comp Form' should also = 'Y' to make the file definition operational.

When using the Generic function, the export options 'Compiled Form' and 'Data Also' are selected through a pop-up. The decisions made are applied to all files that are selected by this generic name.


 DC@P620005                 Add File(s) to List                        


 Enter full or parti ........................................ ed      

 with or leave blank :  Generic File Selection              : .  T    

                     :                                      :         

       File          :  Use cursor to select export options :ort Export

 Sel   Name       Li :   Compiled Form                      :s Function

  G    TEMP       L2 :   Data Also                          :         

  G    TEST       L2 :                                      :         

  G    TESTBAT    L2 :  Then use cursor to initiate action  :         

  G    TESTBC     L2 :   Continue with export options       :         

  X    TSTBC3     L2 :   Cancel generic add                 :         

  _    TSTFL2M    L2 :                                      :     N   

                     : F1=Help  F14=Messages  Fnn=Cancel    :         


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



An option is provided to automatically include in the export list all fields that are defined in the chosen file. To do this enter a 'Y' in the column headed 'Export Fields' beside the chosen file.

The 'Export Fields' column is ignored when using the Generic function.

Additionally, an option is provided to automatically include in the export list all functions that use a chosen file in some way. To do this enter a 'Y' in the column headed 'Export Functions' beside the chosen file. Note that only functions that are currently compiled will be correctly selected when this option is used.

If the Include all functions and Include all fields is requested and the function is in a Web enabled process, then web visual components for fields used in the function will also be added to the export list, provided the *NOWEBEXP flag is not set and the target system is an AS/400 (that is, from an IBM i).

The 'Export Functions' column is ignored when using the Generic function.

Note: Two templates are available to export data from a LANSA file on IBM i to a LANSA file on PC: FRUTIL01 (up to 256 chars) and FRUTIL02 (greater than 256 chars).

When you have completed using this facility, use the Cancel function key to return to the Work with Export List Menu.