DB2 graphic QMF Version 8

Report menu

Run

Select Report--> Run to run the report.

Properties

  1. Select a report at a server.
  2. Select Report--> Properties to open the Report Properties window.

In this window, you can provide the following report information:

Note:
The Formatting, Output, and Procedures tabs are disabled for queries that do not use the SQL SELECT statement because they do not return data (non-SELECT SQL verbs).

REPORT PROPERTIES - FAVORITES

A hidden menu with two options is available from the Properties window. The menu becomes enabled when you select a report from your Favorites folder, select Properties, than right-click on any page in the Properties window.

REPORT PROPERTIES - GENERAL TAB

The General page of the Report Properties window opens when you select Report--> Properties, then click the General tab.

Table 53. General Options
Field Description
Report name This field display report name information, such as:
  • The QMF object type followed by OBJECTOWNER.OBJECTNAME, such as:
    QUERY Q.STAFF
  • the report description if the selected report is in your Favorites folder
Server Type the name of the server on which the report resides, or select a server from the drop-down list.
Object type This field identifies the type of object with which your are working. This can be a query, table, or procedure. You cannot edit this field directly. To select another object, click Select to open the Object Filter dialog box.
View QMF Object text Check this check box to display the SQL for of the QMF object.

REPORT PROPERTIES - FORMATTING TAB

The Formatting page of the Report Properties window opens when you select Report--> Properties, then click the Formatting tab.

Note:
Select the No formatting (data only) radio button to use Microsoft Excel, Lotus 1-2-3, or Microsoft Access as the output application.

Table 54. Formatting Options
Field Description
No formatting (data only) Select the No formatting radio button to return raw data to the file
Include column headers Check this check box to add labels to report columns.
Default QMF formatting Select this radio button to return data in the default QMF format, which includes column headers and a horizontal line to separate the headers and data.
QMF formatting from form This field displays the form that will be used for data formatting.
Select form Click Select Form to open the Form Filter dialog box to specify an object owner and object name of the form to use for the report. The Select a Form dialog box opens and lists the forms available to use for data formatting.
Run Click Run to run the SQL

REPORT PROPERTIES - OUTPUT TAB

The Output page of the Report Properties window opens when you select Report--> Properties, then click the Output tab.

Note:
Select the No formatting (data only) radio button on the Formatting page of the Report Properties window to use Microsoft Excel, Lotus 1-2-3, or Microsoft Access as the output application.

Table 55. Output Options
Field Description
Select output application Select or browse for the application for which you want to format the report.

For Microsoft Excel, Lotus 1-2-3, and Microsoft Access applications and the printer option, click Options to define specific output options.

MICROSOFT EXCEL

Select Microsoft Excel from the Select output application drop-down list, then click Options. The Report Output Options dialog box opens.

  • Select or enter a sheet name

    Select a sheet name from the drop-down list or type a new sheet name in the text box for the Microsoft Excel worksheet.

  • Use the QMF object name

    Check this check box to use the object name as the report name.

  • Append the above name with

    Select the date format from the drop-down list to use as a suffix for the report name.

  • Include column names

    Check this check box to display column headers in the formatted report.

  • Output range

    Click the Output range text box to launch Microsoft Excel. The Output range dialog box opens.

    Click the cell in the spreadsheet where the results should be written. The output range will be updated to the specified cell position.

Click Data Options to specify additional formatting options for graphing and grouping data.
Note:
Data Options is disabled if you selected Default QMF formatting or QMF formatting from the Properties--> Formatting tab.

LOTUS 1-2-3

Select Lotus 1-2-3 from the Select output application drop-down list, then click Options. The Report Output Options dialog box opens.

  • Select or enter a sheet name

    Select a sheet name from the drop-down list or type a new name in the text box for the Lotus 1-2-3 worksheet.

    This option is not available if the Use the QMF object name check box is checked.

  • Use the QMF object name

    Check this check box to use the object name as the report name.

  • Append the above name with

    Select the date format from the drop-down list to use as a suffix for the report name.

  • Include column names

    Check this check box to display column headers in the formatted report.

  • Output range

    Click the Output range text box to launch Lotus 1-2-3. The Output range dialog box opens.

    Click the cell in the spreadsheet where the results should be written. The output range will be updated to the specified cell position.

Click Data Options to specify additional formatting options for graphing and grouping data.
Note:
Data Options is disabled if you selected Default QMF formatting or QMF formatting from the Properties--> Formatting tab.

MICROSOFT ACCESS

Select Microsoft Access from the Select output application drop-down list, then click Options. The Report Output Options dialog box opens.

  • Select or enter a table name

    Select a table name from the drop-down list or type a new name in the text box for the Microsoft Access table.

    This option is not available if the Use the QMF object name check box is checked.

  • Use the QMF object name

    Check this check box to use the object name as the table name.

  • Append the above name with

    Select the date format from the drop-down list to use as a suffix for the table name.

  • Overwrite existing data in table

    Check this check box to replace existing data in the named table with data from the most recent report.

  • Select or enter a report name (optional)

    Optional: Select or enter a report name to view a predefined Microsoft Access report when the database opens.

    This option is useful when you want to view the report after it runs.

    Click Data Options to specify additional formatting options for graphing and grouping data.
    Note:
    Data Options is disabled if you selected Default QMF formatting or QMF formatting from the Properties--> Formatting tab.
PRINTER
  • Select a printer

    Select an installed printer from the drop-down list, or click Options to select from other printers.

  • Number of Copies

    Type the number of copies of the report to print.

  • Font Options

    Select the font type and size for data in the report, or click Options to choose other font options.

  • Orientation

    Select the Portrait radio button to print the page with the short edge on top. Select the Landscape radio button to print the page with the long edge at the top.

  • Page Width

    Three options are available to control the width of the report page:

    • Fit to printer page: Select this radio button to size the page width or length to fit the size of the printed page.
    • Characters: Select this radio button, then type the number of character lines for the page size. The page size will be restricted to this number of lines.
    • Continuous: Select this radio button to print continuous pages, without page breaks, or to wrap text for page width
  • Page Length
    • Fit to printer page: Select this radio button to size the page width or length to fit the size of the printed page.
    • Lines: Select this radio button, then type the number of character lines for the page size. The page length will be restricted to this number of lines.
    • Continuous: Select this radio button to print continuous pages without page breaks or wraps.
  • Other Options
    • Include date and time: Check this check box to include a date and time stamp on the report.
    • Include page number: Check this check box to include a page number on the report.
  • Margin (inches)

    Set the top, bottom, left and right margins for the report by using the up and down arrow keys or by typing the value in the input field. Margins are measured in inches.

REPORT PROPERTIES - PROCEDURE TAB

The Procedures page of the Report Properties window opens when you select Report--> Properties, then click the Procedure tab.

Table 56. Procedure Options
Field Description
This procedure produces no output Check this check box to indicate that there is no output, such as report results, produced from this procedure. Instead, the procedure will run and a subsequent action will take place.
The procedure uses the DSQQW_PROC_OUTPUT substitution variable Select this radio button if the procedure uses the DSQQW_PROC_OUTPUT substitution variable. The variable is used to export data to the location you specify in the output location. The output location is passed to the procedure using this substitution variable.

The syntax EXPORT REPORT TO &DSQQW_PROC_OUTPUT substitution variable must be included in the procedure. Substitution variables will not display in the Properties dialog box for the report.

Publish to a temporary file, in the following directory Select this radio button to specify the filename to which the procedure will send output.
Use the temporary directory of the machine running this report Check this check box to use the machine's temporary directory to save the report.
Start file name with Optional: Type the prefix for the file. This option is used with the Publish to a temporary file, in the following directory option.
End file name with Optional: Select a date format to use as a suffix for the file name.

Select RANDOM use assigned suffixes and avoid overwriting existing report names.

This option is used with the Publish to a temporary file, in the following directory option.

Extension Optional: Select one of the following file formats to use for the temporary file:
  • .csv
  • .htm
  • .txt
Publish to a specific file Select this radio button to browse for a filename where the report will be saved
View output after running Check this check box to open the report after it is produced.

REPORT PROPERTIES - VARIABLES TAB

The Variables page opens when you select Report--> Properties, then click the Variables tab.

The Variable name field lists the variables defined for the report.You can present values for each variable.

  1. Type a value for the variable in the Variable value field.
  2. Optional: Select the Variable value field.
  3. Optional: Click List of values to open the Variable Values List dialog box.
    1. Type a value for the variable in the text box at the top of the dialog box.
    2. Click Add.
    3. Optional: Click Remove to delete values from the variable values list.
    4. Optional: Click Move Up or Move Down to resequence the values in the list.
    5. Optional: Click the User can type in their own values when the report is run check box if the user can provide alternate values for the variable when the report is run.
    6. Click OK.

      The Variable value field is updated as follows, indicating that multiple values have been defined for the variable:

      <List Value>
  4. Check the Hide this value check box to hide the value of the variable when you run the report.
  5. Optional: Click Clear Values to delete all values defined for the variables.
  6. Optional: Click Calculated date to define which date to put on the report when you run the report or schedule the report in the report scheduler.

    This is similar to a date wizard. For example, you can use the Calculated date function when you run a report on Mondays, but you want to use the previous Friday's date on the report. The Calculated date function will determine the correct date each time you run the report, or pass in the correct date for a scheduled report.

    Note:
    Use this feature only for queries that accept dates as substitution values.

    The Date Substitution Value dialog box opens.

    Table 57. Date Substitution Values
    Group box Description Task Notes
    Calculated date By days Select this radio button to specify the number of days prior to the current date to use for the report date Type a number in the Number of days prior to current date field or select a number from the drop-down list
    By days of the week Select this radio button to specify the day of the week, whether in the current month, or the last month, to use for the report.
    • Last occurrence in current month: Select this radio button, then select a day to pass to the report, such as the September 24, which is the last Tuesday of this month.
    • First occurrence in current month: Select this radio button, then select a day to pass to the report, such as September 3, which is the first Tuesday of the current month.
    • Last occurrence in previous month: Select this radio button, then select a day to pass to the report, such as August 26, which is the last Tuesday of the previous month.
    • First occurrence in previous month: Select this radio button, then select a day to pass to the report, such as August 6, which is the first Tuesday of the previous month.
    By month Select this radio button to specify the month to use for the report, and whether to use the first day or last day of the specified month on the report. Select By first day of month, then select a number from the Month prior to current drop-down list to calculate the date for the first day of the prior x number of months.

    For example, select the By first day of the month radio button and type 6 in the Month prior to current field, to print March 1 on a report if the current month is September.

    For example, select the By last day of month radio button and type 2 in the Month prior to current field, to print July 31 on a report if the current month is September.

    By quarter Select this radio button to specify the quarter and the day during that quarter to use on the report.
    1. Select the By quarter radio button.
    2. Select the first, second, third or fourth quarter from the From beginning of drop-down list.
    3. Select the first month of the fiscal year from the Fiscal year starts drop-down list.
    Date format options Date format This field controls how the date will be formatted on the report. Select the format in which to display the date on the report from the Date format drop-down list.
    Date separator This field defines the symbol used to separate the elements of the date (year, month, and day). Select a date separator symbol from the Date separator drop-down list.
    Use PC date as current date Use the current date set on your PC Select the Use PC date as current date radio button to use the date stored on the PC as the current date on the report.
    Use DB2 date as current date Use the current date set on the DB2 system (to account for time zones) Select the Use DB2 date as current date radio button to use the date from DB2 as the current date; this enables users to use the correct date, based on their time zones
    Sample date Click View Sample to see an example of how the date will display.
    Current PC date In the lower-right corner of the Date Substitution Value dialog box, displays the current date you have set on your PC

REPORT PROPERTIES - MISC TAB

The Miscellaneous page of the Report Properties window opens when you select Report--> Properties, then click the Miscellaneous tab.

Table 58. Miscellaneous Options
Field Description
Run as a separate process Check this check box to run reports in a separate instance of QMF Report Center, which allows you to continue working within QMF Report Center.
Suppress informational messages Check this check box to hide informational messages
Suppress error messages Check this check box to hide error messages while reports are running
Limit the number of rows returned Type a number in this field to control the number of rows returned to the report, which preserves system resources, especially at peak times.
Send an email message whenever I run the report Check this check box to send an email notification each time the report is run.
Send an email message whenever the scheduler runs a report Check this check box to send an email notification each time the report is run through the report scheduler.
Attach report output to the email Check this check box to include the report output in the email notification.
Note:
For reports produced at the folder level, this option will attach report output for all reports contained under the folder.
Properties Click Properties to open the Internet Mail Wizard where you provide addressing and routing information for the email.

REPORT PROPERTIES - SCHEDULE TAB

The Schedule page of the Report Properties window opens when you select a query in the Favorites folder, select Report--> Properties, then click the Schedule tab.

Table 59. Schedule Options
Field Description
Job ID This field displays the number of each scheduled job. The number is assigned automatically and cannot be edited.
Interval This field displays the frequency with which the job is run, as specified in the Recurrence field.
Days of week This field displays the day or days on which the job is scheduled to run, as specified in the Days of week to run field.

Optionally, this field may be blank or contain <Customized> if the job has been edited using Microsoft's Task Scheduler (R), indicating that QMF Report Center is not able to display the job details.

Days of month This field displays the calendar day of the month on which the job is scheduled to run, as specified in the Days of month to run field.
Time This field displays the time, in a 24-hour time format, at which the job is scheduled to run on the specified days.
Time Type the hour and minute at which to run the report, using a 24-hour time format.
Days of week to run Check the check box next to each day on which the report is scheduled to run.

Optional: Check the Select all check box to select all days of the week.

Days of month to run Check the check box for the day or days during the month when the job is scheduled to run.

Optional: Check the Select all check box to select all days of the month.

Recurrence
  • Today only

    Select this radio button to run the job today only

  • Once for the days marked

    Select this radio button to run the job only once on the days indicated in the Days of week to run or Days of month to run field

  • Every time for the days marked

    Select this radio button to run the job on the day or days selected in the Days of week to run field or in the Days of month to run field

Set Variable Values Click Set Variable Values to open the Variable Input for Sched Job dialog box where you specify variables to be used with the scheduled report.
Edit Variable Values Click Edit Variable Values to open the Variable Input for Scheduled Job dialog box where you can modify the values for a variable.
Note:
Select the report name to activate this command button.

REPORT PROPERTIES - SECURITY TAB

The Security page of the Report Properties window opens when you select the Public Favorites folder and you select Report--> Properties, then click the Security tab.

Use this page to define security information for users or groups of users who can access objects in the Public Favorites folder.

Table 60. Security Options
Field Description
User ID Select the name of the user or user group to which you are assigning permission to the current object. Authorized users and their permissions are displayed in the text box below.
Add Click Add to add the selected user, in the User ID field, to the authorized users for the current object.
Add All Click Add All to add all of the users in the drop-down list to the authorized users for the current object.
Remove Click Remove to remove the selected user or group of users from the authorized users.
Permissions
  • Read

    Check the Read check box to allow the user or user group to view the current Public Favorites and run the objects in it.

  • Write

    Check the Write check box to allow the user or user group to modify properties of the current object and add reports and folders if the selected item is a folder.

  • Administer

    Check the Administer check box to allow the user or group of users to grant or revoke access to the current object.

Take ownership Click Take ownership to grant ownership of the current object to the user or user group.
Note:
This option may not be available, depending on your resource limits.
Use these settings for all reports under this folder Check this check box to apply the security settings to all reports and subfolders contained in the current folder

REPORT PROPERTIES - GLOBAL VARIABLES TAB

The Global Variables page of the Report Properties window opens when you select Report--> Properties, then click the Global Variables tab.

The following are rules for global variables:

Table 61. Global Variables Options
Field Description
Variable Name Type the name of the global variable in the highlighted text box.

Global variable names must be unique, they are not case-sensitive, and they can begin with an ampersand (&).

Variable Value Type the value for the variable in the highlighted box.
Add Click Add to add a global variable.
Remove Click Remove to remove a global variable.
Run Click Run to run the SQL.

Add to Favorites

Select Report--> Add to Favorites to add a pointer in your Favorites folder to the selected table, procedure, or query on a server.

The report will be added to the top of your Favorites folder with the following naming convention:

Objecttype OWNERNAME.OBJECT NAME

For example:

Query QMFGUEST."SELECT"

Create shortcut

Select Report--> Create shortcut to create a shortcut (.qrs file) to a report in your Favorites at a specific location.

You can create a shortcut to reports in your Favorites folder. The shortcut enables you to access a report by launching QMF Report Center and locating the report using the shortcut.

Follow these steps to create a shortcut:

  1. Select a report.
  2. Drag the report to your Favorites folder.
  3. Select Report--> Create shortcut.
  4. Specify the filename and location for the shortcut.
  5. Click OK.

    The file extension .qrs is added to the filename.

  6. Double-click the shortcut to launch the report.

    QMF for Windows opens, runs the report, then closes. The report remains open.

Note:
Shortcuts are launched when the report name is found.

Save changes to Public Favorites

Select Report--> Save changes to Public Favorites to save report changes in the Public Favorites folder.

New Report linked to locally saved query

Select Report--> New Report linked to locally saved query to create a report by selecting a query saved locally on your network or workstation.

  1. Select the Favorites folder.
  2. Select Report--> New Report linked to locally saved query.

    The Locate the QMF for Windows query to link to dialog box opens.

  3. Select the query.

    The query is added to the Favorites folder.

Note:
Only the SQL and server information are used. Other options saved with the .qry file are ignored.

Editing SQL in QMF Report Center

Follow these steps to edit SQL for a report in QMF Report Center. This is the only situation where SQL can be edited by QMF Report Center.

  1. Locate the report on your local machine.
  2. Double-click on the report.
  3. Edit the QMF object text.
  4. Save the changes.

New folder

Select Report--> New folder to create a folder within the current folder.

Empty recycle bin

Select Report--> Empty Recycle Bin to remove the deleted items from the Recycle Bin.

Exit

Select Results--> Exit to exit from QMF Report Center.


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