Data Dictionary

Data Dictionary Utilities

 

Additional data dictionary tools and security control are available from the Utilities menu in Data Dictionary Maintenance.

The following links provide additional information:

Utility

Description

Print

Generates output in a standard format that lists all of the elements in the definitions that have been selected for printing.

Compare Definitions

Compares two tables from the same or different data dictionaries or physical files (or a combination of both).

INI File Generation

Allows for the generation of INI file contents directly from the data dictionary.

SQL Create Table

Outputs CREATE TABLE directives for defining database tables that are consistent with the PxPlus data dictionary.

Key Definitions

Generates SQL key definitions for data dictionary tables.

Merge

Allows table definitions to be merged from one set of dictionary files (ddf/dde) to another.

Import Dictionary

Copies a file definition from a different PxPlus data dictionary (in another directory) into the current file definition.

Export Data Dictionary Definition

Exports the data dictionary definitions of one or more selected tables to an export text file. Used in conjunction with the Import Data Dictionary Definition utility.

(The Export Data Dictionary Definition utility was added in PxPlus 2021.)

Import Data Dictionary Definition

Imports the data dictionary definitions of one or more tables selected from an export text file into a data dictionary in another location. Used in conjunction with the Export Data Dictionary Definition utility.

(The Import Data Dictionary Definition utility was added in PxPlus 2021.)