Use the SQL Condition window to specify the SQL expression for filtering table data, view data, or data that results from running an SQL or SPL procedure or function.
To open the SQL Condition window:
The syntax for a filter expression is:
For a single condition:
<operator> <condition value>
for example, < 5000
For a compound condition:
<operator> <condition value> <logical connector> <column name> <operator> <condition value>
for example, < 5000 or CUSTOMERID = 9999
Additional information is available in your DB2 documentation.
You can also find information in
DB2 SQL documentation that is available through
The
SQL Reference for Cross-Platform Development Web page
on developerWorks.