DB2 graphic  QMF Version 8

Present all the columns in a table

To see all the columns in a table, put P. under the table name in the example table. All the columns shown in the example table appear.

When you run this query:

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

QMF produces this report:

DEPTNUMB  DEPTNAME        MANAGER  DIVISION    LOCATION
--------  --------------  -------  ----------  -------------
      84  MOUNTAIN            290  WESTERN     DENVER
      66  PACIFIC             270  WESTERN     SAN FRANCISCO
      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          


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