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 103.

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.