DB2 graphic  QMF Version 8

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            


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