Data Definition Language (DDL) Reference Manual

Dictionary Maintenance
Data Definition Language (DDL) Reference Manual—529431-004
10-6
Deleting Referenced Objects
•
It writes the statements to rebuild the objects that referenced the specified object,
in a section for each referring object.
After executing OUTPUT UPDATE, you can use the SOURCE command to execute
the DELETE statements in the DDL source file section written by OUTPUT UPDATE.
After the objects that refer to an object are deleted, you can delete the referenced
object.
Assume you are running the DDL compiler interactively. To delete a referenced
constant, definition, or SPI token type from the dictionary, do this:
1. Open the dictionary containing the object to be deleted.
2. Open a new DDL source file for the output from OUTPUT UPDATE.
3. Use the OUTPUT UPDATE statement to write the DDL source file containing the
DELETE statements for objects that refer to the specified object.
4. Examine the DDL source file to get the section name containing the DELETE
statements; to do this:
a. Close the DDL source file with a NODDL command. If you omit this step, you
will get a FILE IN USE message when you try to edit this file.
b. Use the EDIT command to examine the DDL source file. Make a note of the
name of the section that contains the DELETE statements produced by
OUTPUT UPDATE; then exit from the editor.
5. Delete all the referring objects from the dictionary. Use the SOURCE command to
submit the DDL source file section containing the DELETE statements for these
objects to the DDL compiler. This step executes the DELETE statements,
effectively deleting the objects from the dictionary.
6. Delete the object. Use a DELETE statement to delete the object from the
dictionary.
Example 10-5
on page 10-7 shows the DDL statements and commands needed to
delete the referenced object AGE from the dictionary.