Data Definition Language (DDL) Reference Manual

Data Definition Language (DDL) Reference Manual—529431-004
10-1
10 Dictionary Maintenance
This section briefly describes these dictionary maintenance procedures:
•
Generating a schema From a Dictionary on page 10-1
•
Adding Dictionary Objects on page 10-2
•
Deleting Dictionary Objects on page 10-4
•
Modifying Dictionary Objects on page 10-8
•
Making Major Modifications on page 10-13
•
Changing Dictionary Security on page 10-14
•
Moving a Dictionary on page 10-14
•
Purging a Dictionary on page 10-18
•
Increasing Dictionary File Size on page 10-19
•
Rebuilding a Dictionary on page 10-20
•
Converting a Dictionary on page 10-22
Generating a schema From a Dictionary
Some reasons to generate a new schema from the dictionary are:
•
You can use the new schema as a backup for the dictionary.
•
You made so many changes to definitions and records in the dictionary that the
original schema is out of date.
•
You lost the original schema.
To generate a schema from a dictionary:
1. Use the DICT, DICTN, or DICTR command to open the dictionary.
2. Use the DDL command to open a DDL source code file to contain the new schema
(this DDL source code file will be the new schema file).
3. Use an OUTPUT statement to generate DDL source statements from the
dictionary objects and write them to the new schema file.
Note. Changing a dictionary does not change any database described by the dictionary, nor
do any changes to a database affect the dictionary.
Note. Do not attempt to back up a dictionary that is part of a Pathmaker catalog using the
following procedure. Pathmaker dictionaries contain application design information that is not
generated in DDL schemas.