DB2 graphic  QMF Version 8

Presenting certain columns of a table

To see data from only selected columns of an example table, put P. under the names of the columns you want to see.

When you run this query:

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

QMF produces this report:

DEPTNUMB  DEPTNAME
--------  --------------
      84  MOUNTAIN
      66  PACIFIC
      10  HEAD OFFICE
      15  NEW ENGLAND
      20  MID ATLANTIC
      38  SOUTH ATLANTIC
      42  GREAT LAKES
      51  PLAINS           


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