Maintaining Your Data Model › Related Procedures for Maintaining Your Model › Delete a File

Delete a File

To delete a file, you must delete the Defined as relation for that file. Before you can delete a Defined as relation, you must first delete all other references to the file. Use the positioning option to view all references.

1. Delete all relations, except a Defined as relation.

   This includes all Owned by, Known by, Refers to, Has, Extended by, Qualified by, and Includes relations.

   On the Edit Database Relations panel, type a D next to each of the relations of the file and press Enter.

2. Delete the Defined as relation (DFN).

   When you delete the Defined as relation, CA 2E removes all the access paths and functions associated with this file.

   • On the Edit Database Relations panel, enter DFN for the Rel lvl and press Enter.
   • Type a D next to the Defined as relation and press Enter.
3. Optionally delete all fields that are now unreferenced.

   From the Edit Database Relations panel:

   • Press F7 to display the Display Fields panel.
   • Press F11 to display unreferenced fields.
   • Enter a D next to each of the fields to be deleted and press Enter.
4. Delete all messages for this file. This includes all user-created messages in addition to the default messages.

   There are two default messages:

   "File name" EX (record already exists)

   "File name" NF (record not found)

   • On the Edit Database Relations panel, type an *m above the Object field to position to the *Messages file. Press Enter.
   • Type F against any Message field and press Enter.
   • On the Edit Message Functions panel, type D next to the message to be deleted and press Enter.