3.9 Bulk Load of OTHER files

"OTHER" files are non-LANSA files maintained by another system. Before an OTHER file can be used by LANSA, it must be "made known" to LANSA. This can be done using the Bulk Load of OTHER files process described here, or as a single file process as described in 3.19 Load the Definition of a File NOT Maintained by LANSA.

As well as loading new definitions, you can use this process to update definitions that have already been loaded.

To enable this facility for a partition, you must use the LANSA Import facility and import from save file LS@BULKLOD.

The Bulk Load of OTHER files facility can be accessed from:

There are three simple steps in the bulk load (or update) process.

These steps are:

1.  Specify the Library and a file name, or partial filename, of the OTHER files to be made known to LANSA. A list of files that match this criteria is created.

From the list of files that match the criteria in step 1, select the files for which the definitions are to be loaded or updated. You can also display the file details before you load them.

Specify the details to be used for the batch job that will load the definitions.

For full details on loading OTHER files, and factors you must consider, refer to 3.19 Load the Definition of a File NOT Maintained by LANSA.

When the Bulk load of OTHER files option is selected from either the File Control Menu or the Work with Files screen, you will be requested to specify the library and file(s) so that a list of files to be selected can be created.


 LS@0001113               Bulk Load of OTHER files                     


 Enter library which contains files  . . . . . . . . PAYLIB            

 Enter full or partial name of file(s) to be worked with or leave blank

 to select all . . . . . . . . . . . . . . . . . . . PR                








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




Enter the search criteria for the OTHER files which you wish to work with. The criteria consists of a library, which must be entered, and a file name.

The file name may be a full name, a partial name or blank. All OTHER physical files which match the search criteria and their associated logical files are displayed.


 LS@0001158           Bulk Load of OTHER files                        


   7=Load definition              27=Display details                  



     File             Library     LANSA                               

  7  PF  PR0001       PAYLIB        Y    Personnel Details            

  _  LF  PR0001L1     PAYLIB                                          

  7  LF  PR0001L2     PAYLIB        Y                                 

  7  PF  PR0002       PAYLIB             Employee History             

  7  LF  PR0002L1     PAYLIB                                          

  _  LF  PR0002L2     PAYLIB                                          




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




The file details displayed are:

The details of any file can be displayed by entering option 27 (Display Details) to the left of the file. The IBM i DSPFD details will be shown.

To load or re-load the definition of a file, enter 7 to the left of each of the required files. A logical file can not be loaded by itself. It must be loaded with its associated physical file. However, not all logicals need be selected. You may select only those which you wish to use in LANSA.

You will be requested to enter the details to be used by a batch job which will be submitted to load the definitions of the selected files.


 LS@0001198           LOAD/CREATE OTHER FILES   


 Submit batch load of files selected . . . . . . . . YES       YES, NO

 Using Job name  . . . . . . . . . . . . . . . . . . LS@BULKLOD       

       Job description . . . . . . . . . . . . . . . QUSRSYS/DC@JOBD  

       Job queue . . . . . . . . . . . . . . . . . . *JOBD            

       Output queue  . . . . . . . . . . . . . . . . USRSYS/PRT02     


 Submit batch create of files after load  . . . . .  YES       YES, NO

 OPTIONS FOR BATCH CREATE                                             

 Produce file and I/O module source listings . . . . NO        YES, NO

 Ignore decimal error / Strip debug data option  . . NO   YES  YES, NO

 User program to call at completion  . . . . . . . . __________       




 Fnn=Help  Fnn=Prompt  Fnn=Messages    




If you enter YES for "Submit batch create of files after load", a batch job to make the file operational will be submitted for each physical  file successfully loaded.

These batch jobs will use the same Job description, Job queue and Output queue as specified for the bulk load job. The Job name will be the file name.