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.

Select Query --> Add --> Row Conditions or click the icon in Row Conditions list box to open the Row Conditions dialog box and specify the row conditions.

Table 21. Row Conditions Dialog
Part of the row condition Function
Connector An "And" or "Or" statement that links one row condition with another. These radio buttons are available only when a row condition has been added to the query.
Left side Select the column from the list box to examine for inclusion in the query results
Operator Select the Is or Is Not radio button to determine the relationship between the left- and right sides of the row. Also, select the operation to be applied to the row condition from the Operator drop-down menu. The available operators are:
  • Equal To
  • Less Than
  • Less Than or Equal to
  • Greater than
  • Greater than or Equal to
  • Between
  • Starting with
  • Ending with
  • Containing
  • Null
  • Equal in area to
  • Larger than
  • Larger than or equal to
Right side Type the condition for which to check the rows. Only rows that meet this condition will be selected for the query
Expression Builder Use the Expression Builder for building SQL expressions for the prompted query.

The Expression Builder offers a palette of common elements used to create SQL expressions, such as column names, constants, functions, and operators. When you click the Expression Builder buttons, templates for expression elements are inserted into the associated SQL query window or prompted query window.

You can invoke the Expression Builder by:

  1. pressing Alt + .
  2. clicking the browse icon to the right of the Enter a sort condition field


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