Online Documentation for SQL Manager for DB2

Adding a new condition

Suppose we need to select data from the sample table EMPLOYEE to view the list of IT specialists hired after 6/15/2009. These criteria are applied to the HIRE_DATE, the DEPT_ID and the POSITION fields.

Click press the button to add a new condition - this will add a new condition to the criteria. Alternatively, you can click the Filter button and select the Add Condition popup menu item.