DB2 graphic  QMF Version 8

Writing filter expressions

You can write filter expressions to modify data returned from a query using the Advanced Query wizard and the Query editor. You can filter row data (one specific record in your database), group data (all grouped records), and all data results from the query.

Filter expressions are equations that include one or more of the following elements:

The typical format for a filter expression is variable=value, where variable can be a function expression, column, or query parameter; value can be a constant or query parameter; and = (equals) can be any operator.

Note: If you use the Advanced Query wizard or the Query Diagram view, you should not include the WHERE keyword in your filter expression; QMF Visionary includes it automatically.

For example, you might want to see sales data for a particular year. To do so, you can create a query of all sales totals that filters the results so only sales above specific amounts are in the result set: sales > 50.


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