Load from File

Sometimes you may not be able to access your distributed data store from Windows. For this situation, the Distributed Loader provides the ability to load data store information from flat files.

To load information about your data store from a file, begin by selecting the Load from File tab. In the Distributed Systems solution, the Load from File tab of the Distributed Loader appears similar to the following:

Distributed Loader - Load from File (Distributed Systems)

In Data Express for Distributed Systems, two files can be used as input to the load process. The first file contains information about your tables, columns, and indexes. The second optional file contains information about your data store's referential integrity.

The Load from File tab of the Distributed Loader is different for the z/OS solution:

Distributed Loader - Load from File (z/OS)

In Data Express for z/OS, only the file that contains information about your tables, columns, and indexes can be used. For a z/OS Knowledge Base, your referential integrity information gets loaded into the Knowledge Base while executing the Import Classification from Referential Integrity job. See Importing Classes for more information.

The files used as input by the Distributed Loader are created by the Extension Technology utility: dxegenloadfile. This utility creates both files.

If you are using Data Express for z/OS, the referential integrity file created by dxegenloadfile is used as input to the Import Classification from Referential Integrity job.

If you are using the ODBC Extension or the Oracle Extension and want Data Express to load the user ID and password for the selected connection, run the dxegenloadfile using the -c parameter. This generates an input file with table information in the corresponding ODBC or Oracle log directory. See Extension Technology Directories for more information.

For more information on dxegenloadfile, see Extension Technology Utilities in Using Extension Technology.