Using QMF

Present some of the columns in a table

To see selected columns, put P. under the names of the columns you want to see. You can put the P. before or after other things you put under the column heading.

When you run this query:

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

QMF produces this report:

DEPTNUMB  DIVISION    LOCATION
--------  ----------  -------------
      84  WESTERN     DENVER
      66  WESTERN     SAN FRANCISCO
      10  CORPORATE   NEW YORK
      15  EASTERN     BOSTON
      20  EASTERN     WASHINGTON
      38  EASTERN     ATLANTA
      42  MIDWEST     CHICAGO
      51  MIDWEST     DALLAS