DB2 graphic  QMF Version 8

Listing QMF queries, forms, and procedures

To get the information you need to help you maintain the QMF environment, you need to list the queries, forms, and procedures that QMF users have saved in the database. With administrator authority you can list QMF objects you do not own using the query in Figure 34.

Figure 34. Listing forms, and procedures owned by a particular user
SELECT D.NAME, D.TYPE, D.SUBTYPE, D.RESTRICTED, R.REMARKS
  FROM Q.OBJECT_DIRECTORY D,
       Q.OBJECT_REMARKS R
  WHERE D.OWNER = 'userid'
    AND D.OWNER = R.OWNER
    AND D.NAME  = R.NAME
  ORDER BY D.TYPE, D.SUBTYPE, D.RESTRICTED

This query returns a list of objects sorted by type (FORM, PROC, QUERY) and further by subtype (SQL, QBE, or PROMPTED) if TYPE is query. Enclose the value you supply for userid in single quotation marks. Objects of each type are further sorted by whether they've been shared by the owner. Shared status is reflected in the RESTRICTED column of the Q.OBJECT__DIRECTORY table.


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