Load from database

Begin by selecting the Load from Database tab. In Data Express for Distributed Systems, you will see an import checkbox for referential integrity labeled: Load Referential Integrity. This provides the ability to load your referential integrity information into the Windows Knowledge Base, in addition to standard schema information about your tables. You are now ready to import your referential integrity classes. See the Getting Started with Distributed Data Stores guide for more information.

In Data Express for z/OS, an export checkbox labeled Export Referential Integrity is provided instead. In this environment, a file that contains referential information is created for you. Once this file is transferred to the mainframe, you can load and import your referential integrity classes. See the Getting Started with Distributed Data Stores guide for more information.

Standard schema information about your distributed data store’s tables is automatically loaded in the z/OS knowledge base. You can logically reduce the amount of information you wish to load by specifying the name of a schema in the Schema field. Otherwise, you leave this field blank and the Distributed Loader retrieves and loads all the information about all the schemas in the data store.