Modifying Schema Entities › Record Modifications › Deleting Schema Records

Deleting Schema Records

What components are affected

Deleting schema records affects the schema and the data. It also affects subschemas and access modules that reference the record and any other records connected to the record through sets. SQL views referencing the record become invalid.

Steps to delete a record

To delete a record from the schema where data has been loaded:

1. Write and execute a program to erase all occurrences of the record
2. Create a new schema based on the original schema omitting the record and omitting any affected sets
3. Validate the schema
4. Use the schema compare utility (IDMSRSTC) to generate the IDMSRSTT macro statements
5. Restructure the database using the RESTRUCTURE utility statement

   Note: If the record does not participate in any set relationships, there is no need to restructure the database.

6. Complete the process by updating the original schema definition, regenerating subschemas, altering affected access modules, and dropping affected views

Considerations

• If you created the record using DDDL statements, the record definition will remain in the dictionary after it has been deleted from the schema
• If you created the record using schema DDL and the record has not been copied into any other schema, its definition will be deleted from the dictionary after it has been deleted from the schema definition.
• If the record participates in a set relationship, you have to remove the set from the schema definition or modify the definition before validation
• Regenerating affected subschemas will remove the record from the subschema definition
• When you erase occurrences of the record, you may have to use a subschema derived from a schema where the sets in which the record is an owner have been changed to optional. This permits the member record to be disconnected from the owner record rather than being erased.