SQL Condition

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:

In the Options section of the Data view in the IBM Data Designer, click the Filter cell for the column that you want to filter, and then click .

Specify the SQL condition

Enter the SQL statement that describes the filter condition that you want to use for the column in the table, view, or SQL procedure. The column name is implied for a single condition and the first part of a compound condition.

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.

See Also