More than one single filter for the same data store

This following steps describe how to apply the second filtered class SURNAME to the second column SURNAME of a data store CUSTOMER which has been included in a Method from the Work with Method window. The query is created with a UNION statement within the two filter criteria.

At the end of the Method confirmation phase, in order to apply the second class, copy the data store to a new step by clicking Copy Selected Step. To copy the data store:

1. Select the appropriate row in the Work with Method window and click the button.
2. Right-click on new row to display the context menu, point to Elaboration, and then click Clear Selection class and Disconnect Filter.
3. Right-click on new row to display the context menu, point to Elaboration, and then click Selection class / Filter properties and select the class SURNAME assigned to column SURNAME.
4. Right-click on new row to display the context menu, point to Move selected to and then click 20 - STEP CLASSES.

To create a query with the INTERSECT statement, follow steps 1 through 4 above, and then:

1. Select the two rows related to the DB2 table CUSTOMER.
2. Right-click; then select Utility from the context menu.
3. Select the Create filter in AND voice.