Using QMF

Presenting all the columns of a table

To retrieve data from a table in the database and display it in a report, use the P. keyword. You can use the D., I, and U. keywords in a similar way to delete, insert, and update data in the database.

To display the data in all the columns of a table, put P. under the table name and do not remove any of the column headings, as in this example table:

Q.ORG | DEPTNUMB | DEPTNAME | MANAGER | DIVISION | LOCATION |
------+----------+----------+---------+----------+----------|
P.    |          |          |         |          |          |

With this query on your screen, enter RUN QUERY on the command line (or press the Run function key) to produce the following report.

DEPTNUMB  DEPTNAME        MANAGER  DIVISION    LOCATION
--------  --------------  -------  ----------  -------------
      10  HEAD OFFICE         160  CORPORATE   NEW YORK
      15  NEW ENGLAND          50  EASTERN     BOSTON
      20  MID ATLANTIC         10  EASTERN     WASHINGTON
      38  SOUTH ATLANTIC       30  EASTERN     ATLANTA
      42  GREAT LAKES         100  MIDWEST     CHICAGO
      51  PLAINS              140  MIDWEST     DALLAS
      66  PACIFIC             270  WESTERN     SAN FRANCISCO
      84  MOUNTAIN            290  WESTERN     DENVER