Running a query and displaying a report

When you run a query, QMF displays the data you select as a report.

You can run a query with only one table selected, and some or all columns selected.

To run a query:

  1. From the Specify panel, press the Cancel function key. The Prompted Query panel displays your query.
  2. Press the Run function key.

    Or you can do the following:

    Enter RUN QUERY on the QMF command line.

    When QMF finishes running your query, it displays a report that shows all of the data that you selected.

    If your query selects a large number of rows, you might need to scroll forward to see all the data.

    Figure 51. QMF displays your data as a report.
       NAME         DEPT    JOB      SALARY        COMM
       ---------  ------  -----  ----------  ----------
       JAMES          20  CLERK    13504.60      128.20
       NGAN           15  CLERK    12508.20      206.60
       NAUGHTON       38  CLERK    12954.75      180.00
       YAMAGUCHI      42  CLERK    10505.90       75.60
       KERMISCH       15  CLERK    12258.50      110.10
       ABRAHAMS       38  CLERK    12009.75      236.50
       SNEIDER        20  CLERK    14252.75      126.50
       SCOUTTEN       42  CLERK    11508.60       84.20
       LUNDQUIST      51  CLERK    13369.80      189.65
       WHEELER        51  CLERK    14460.00      513.30
       BURKE          66  CLERK    10988.00       55.50
       GAFNEY         84  CLERK    13030.50      188.00
  3. If you want to make changes to the query, press the Query function key to return to the Prompted Query panel.
[ Previous Page | Next Page | Contents | Index ]