Bulk load of OTHER files

Date:Archived
Product/Release:LANSA for the AS/400
Abstract:New optional facility allows the definitions of a number of OTHER files to be made known to LANSA
Submitted by:LANSA Technical Support

OTHER files are non-LANSA files maintained by another system. Refer to Loading the Definition of a File NOT Maintained by LANSA for a further details of loading OTHER files.

This new optional facility allows the definitions of a number of OTHER files to be made known to LANSA using a simple 3 step process. This facility allows definitions to be loaded that are new to LANSA as well as to update definitions that have already been loaded.

The steps are:

  • 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 which match the criteria in step 1, select the files for which the definitions are to be loaded or updated. The file details can also be displayed before loading. Files which have been previously loaded into LANSA will be displayed with a Y for LANSA.
  • Specify the details to be used for the batch job which will load the definitions.

The facility is optionally available in each partition. To enable this option for a partition, use the LANSA Import facility and import from save file LS@BULKLOD. The facility can be accessed from an option on the File Control Menu or by use of a command key on the Work with Files in the advanced menu.

For full details on loading OTHER files and the standard method refer to Loading 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, the library and file(s) should be specified 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 are to be worked 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 previous physical file.
  • The OS/400 file name.
  • If the OTHER file definition has previously 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 OS/400 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.

Select only those which you wish to use in LANSA.

Then 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 YES is entered 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.