IBM Database Add-Ins for Visual Studio  

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:


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

For a DB2 database 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

Data, Designer


.NET Development Forum   DB2 FAQs   IDS FAQs

© Copyright IBM Corporation 2002, 2019. All Rights Reserved.