DB2 graphic QMF Version 8

View menu

QMF Names

Select View--> QMF Names to display the name view of tables, forms, procedures, and queries. This option toggles with the QMF Comments option.

The QMF Name is taken from the "Save As" name when the report was created.

QMF Comments

Select View--> QMF Comments to display the comment view of tables, forms, procedures, and queries. This option toggles with the QMF Names option. The QMF Name view displays for objects that do not have comments.

Objects on the server can have comments that include descriptive information about the object. These comments are assigned to the object when the object is created. You cannot modify comments.

Comments are displayed for the current level and all levels below. For example, if you select QMF queries, all owners and objects contained within QMF queries are displayed with comments.

Note:
Retrieving comments can be a time-consuming process. To save resources, you can view comments for a particular object, rather than viewing comments for all objects of the same type.

QMF Object text

Select View--> QMF Object text to open the Query Text dialog box, which displays the object name and the SQL for the object. For example:

Table: DB2ADMIN.MAX_T
Select * from DB2ADMIN.MAX_T

Note:
You cannot edit the QMF object text using this function unless it is a local query (.qry) that has not been statically bound to a server.

Report Comments

Select View--> Report Comments to open the Report Comment dialog box where you can view or type comments for the report.

Filter options

Select View--> Filter options to specify display options for the object. You can filter by any of the following for the object owner and object name:

Server filter options

Select the View--> Server filter options option to select the servers to hide from the QMF Report Center directory tree. The Select Servers to Hide dialog box opens and it lists the servers included in the SDF (Server Definition File).

Check the check box next to each server you want to hide, or click Select All or Clear All. You can run reports against hidden servers.

Text size

Select View--> Text size to specify the relative display size of text in QMF Report Center.

Scheduled jobs

Select View--> Scheduled jobs to view, edit, delete, and set properties for scheduled reports.

The QMF Scheduled Jobs dialog box opens. The dialog box provides information about scheduled jobs, including the report name, interval, day of the week, day of the month, time, type of object, server, and QMF object name.

Report history

Select View--> Report history to open the Report History dialog box, which provides details for reports run, in chronological order.

The history captured for the report includes the date run, the report name, the application, the file location, and the file size.

Table 63. Report History command buttons
Click this button To do this
Clear Selected Click Clear Selected to clear a specific history file from the overall report history
Delete Files Click Delete Files to delete all history files for the report
View Report Select a history file, then click View Report to open the report

Activity log

Select an object then select View--> Activity log to open all activities in chronological order. The activity log contains detailed information on reports run and errors encountered during QMF Report Center operations.

Refresh

Select View--> Refresh to obtain an updated view of the directory tree, which will reflect any recent changes made to objects on the server. If the Prompt me with this filter every time check box is checked on the Filter Options dialog box, the Filter Options dialog box opens each time you click Refresh.


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