QMF displays all rows, including duplicate rows, by default if you have just one P. row in your query. To eliminate duplicate rows, specify UNQ. (unique) under the table name in the row with the P. operator.
Both of the following examples have P. in the DIVISION column. The report in Example 1 presents all the rows, including duplicates.
Example 1:
Without UNQ.
Q.ORG | DEPTNUMB | DEPTNAME | MANAGER | DIVISION | LOCATION |
------+----------+----------+---------+----------+----------|
| | | | P. | |
|
QMF produces this report:
DIVISION -------- CORPORATE EASTERN EASTERN EASTERN MIDWEST MIDWEST WESTERN WESTERN
Example 2 specifies UNQ. under the table name. Therefore, QMF eliminates all columns that contain duplicate data in the presented column.
Example 2:
With UNQ.
Q.ORG | DEPTNUMB | DEPTNAME | MANAGER | DIVISION | LOCATION | ------+----------+----------+---------+----------+----------| UNQ. | | | | P. | | |
QMF produces this report:
DIVISION -------- CORPORATE EASTERN MIDWEST WESTERN
If your example table has two or more P. rows, QMF does not display duplicate rows. (See ALL. -- Display duplicate rows and UNQ. -- Eliminate duplicate rows.)