DB2 graphic  QMF Version 8

ALL. -- Display duplicate rows

ALL. ensures that all rows, including duplicate rows display. Specify ALL. under the table name in the row with the P. operator. You can only use ALL. in rows with P..

ALL. is the default operator if a sample table has only one P. row. For this query, you would not have to specify ALL. to display all the rows in the report.

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

However, if a table has two or more P. rows, QMF excludes duplicates. See also UNQ. -- Eliminate duplicate rows.


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