Deleting obsolete queries, forms, and procedures

Use the SQL in Figure 106 to delete all of a particular user's QMF queries, forms, and procedures. Make sure you run all three queries, because the internal representation of each object spans the three QMF control tables Q.OBJECT__DIRECTORY, Q.OBJECT__DATA, and Q.OBJECT__REMARKS. Surround values you supply for the user ID variables with single quotes.

Unpredictable results can occur if the tables are not properly updated.

DELETE FROM Q.OBJECT_DIRECTORY    DELETE FROM Q.OBJECT_REMARKS      DELETE FROM Q.OBJECT_DATA
WHERE OWNER = 'olduserid'         WHERE OWNER = 'olduserid'         WHERE OWNER = 'olduserid'

You can also delete obsolete objects by using the date and time sorting capabilities in Q.OBJECT_DIRECTORY. You can select every object where the date last used was before 06/01/95 and delete all the appropriate rows from the three control tables.