DB2 graphic QMF Version 8

Row conditions

Use can specify row conditions to limit the rows that are returned in the query results. Without row conditions, all qualifying rows will be returned from the query.

You use the following fields in the bottom section of the diagram window to specify the row conditions:

Row conditions and ors

Use this field to specify simple conditions that apply to the specific column. You can use any of the valid SQL operators. For example, enter "=1" in a row condition for a numeric column. This will specify that only those rows with a value of "1" in this column will be included in the query results.

Additional row conditions

Use this field to add additional row conditions. You have the choice of adding the conditions using an And or Or operator. You can type any valid SQL expression using connectors and columns.

Include duplicate rows

Check this check box to specify that duplicate rows will be included in the query results.


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