Displaying QMF objects
In addition to listing a query, procedure, form, or analytic object to get the information you need to help you maintain the QMF environment, you can use the DISPLAY command for more information.
DISPLAY is not a valid command for QMF folder objects because folders do not contain object data. Folders contain only references to other QMF objects (queries, procedures, forms, or analytic objects).
- Issue the following statement to share the user's objects. Then
display them from your own ID:
UPDATE Q.OBJECT_DIRECTORY SET RESTRICTED = 'N' WHERE OWNER = 'userid'Important: Issue this statement only if you do not need to track which of the user's objects are restricted and which are not. After you issue this statement, you can reset RESTRICTED to Y, but then you will not be able to tell which objects were originally restricted.Tip: A single SQL query can contain multiple SQL maintenance statements. To create a query that includes multiple statements, place a semicolon between statements and set the DSQEC_RUN_MQ global variable to 1. Information about how to create queries that include multiple statements as well as restrictions on the types of statements that can be used is included in the description of the RUN command.
- Issue the QMF DISPLAY command for each object that you want to display.