Data Dictionary Utilities

Location of Import Text File

Enter the name of a valid text file to import or click the Query button. Default is exportDict.txt.

If the default text file exportDict.txt exists in the current working directory, it will display as the default import file.

Available Tables

List box that is loaded with all the table definitions that exist in the selected text file to be imported.

Select All

Button used to move all tables in the Available Tables list box to the Selected Tables list box.

Include

Button used to move a selected table in the Available Tables list box to the Selected Tables list box.

Remove

Button used to remove a selected table from the Selected Tables list box and return it to the Available Tables list box.

Selected Tables

List box that contains the tables that have been selected for importing their definitions.

Overwrite Existing Table Names

(Available when Selected Tables list box contains a table)

Select this check box to overwrite existing table definitions of the same name in the current working directory. If duplicate table names are found, they will be automatically overwritten without first displaying a message to verify.

If unchecked (default), existing table definitions of the same name will not be overwritten. During the Import process, a message will display each time that a duplicate table name is encountered to either allow the imported table to be renamed or skip importing the table.

Update Physical File(s) After Import

(Available when Selected Tables list box contains a table)

Select this check box to update the data dictionary in the physical files after the data dictionary definitions are imported.

If unchecked (default), the physical file(s) will not be updated.

Note:
If an error is encountered while attempting to update the physical file for a particular table, a message will display with three responses:

   • Abort will stop the physical file updates for all remaining tables to be imported.
   • Retry will retry the physical file update for the same table.
   • Ignore will skip the physical file update for the individual table but continue the physical update for all remaining tables to be imported.

Import

(Available when Selected Tables list box contains a table)

Button used to import the data dictionary definitions of the selected tables into the current data dictionary.

Close

Exits the Import Data Dictionary Definition utility without importing any table definitions.