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