Deleting a Subschema

When You Might Want to Make This Change

If there is no longer a need for a subschema, you may want to delete it.

What Components are Affected

The subschema source is affected by the deletion of a subschema. The subschema load module is not affected.

Considerations

When you delete a subschema, programs associated with that subschema can no longer be compiled. You must associate each program with a new subschema.
If you have not specified DELETE IS ON in the SET OPTIONS statement, the subschema load module is not automatically deleted when you delete the subschema definition. You must explicitly delete the associated load module.

Example

In the following example, the subschema EMPSS01 is deleted.

delete subschema empss01.