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:

• an option on the File Control Menu

• using command key on the Work with Files in the advanced menu.

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:

• PF indicates that this is a physical file, LF indicates that this is a logical file belonging to the preceding physical file.

• The IBM i file name.

• If the OTHER file definition has already been loaded into LANSA, the LANSA column will contain Y.

• The description of each physical file.

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.