UNQ. eliminates duplicate rows from query results. If your example table contains two or more P. rows, QMF deletes duplicate rows from the query result by default. However, if your table has only one P. row, and you want to prevent duplicate rows, use UNQ. under the table name in the row with the P. operator.
When you run this query:
Q.ORG | DEPTNUMB | DEPTNAME | MANAGER | DIVISION | LOCATION | ------+----------+----------+---------+----------+----------| UNQ. | | | | P. | | |
QMF produces this result:
DIVISION ---------- CORPORATE EASTERN MIDWEST WESTERN