Filtering data at the subscription level

Procedure

1. Create or edit a JDBC subscription or DataPropagator subscription.
2. Click Define Subscription. The Define Replication Subscription window opens.
3. Click Advanced. For DB2 DataPropagator subscriptions, the Advanced Subscription Definition notebook opens. For JDBC subscriptions, the Advanced Replication Subscription notebook opens.

Note:

Horizontal filtering only occurs from server to client. If a client inserts a row that is not be included in the filter, the rows will be inserted into the source.

On the rows page of the subscription notebook, type an SQL clause in the All rows needed box. The entire SQL clause must be typed on one line using the following format:

city='myValue'

Do not type WHERE at the beginning of the SQL clause. WHERE is automatically appended to the clause typed in the box. For example, the following clause will synchronize only columns that have a city column value equal to Los Angeles:

city='Los Angeles, CA 90061'

Related tasks

• Filtering data from data sources
• Filtering data horizontally
• Defining simple horizontal filters
• Filtering data at the group level
• Filtering data at the user level
• Defining complex horizontal filters
• Filtering data vertically
• Filtering data vertically

Related reference

• Syntax for filters