DB2 graphic  QMF Version 8

Deleting obsolete queries, forms, and procedures

Use the SQL in Figure 37 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.

Figure 37. Deleting unnecessary objects from the QMF control tables
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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004