Filtering data horizontally

Horizontal filtering at the subscription level, group level, or user level uses an SQL clause to select data from the source data source. The contents of the SQL clause are controlled by the Rows page of the Advanced Subscription Definition notebook for DB2 DataPropagator subscriptions and the Rows page of Advanced Replication Subscription notebook for JDBC subscriptions. To open either of these notebooks:

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.

Nota:

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.

This topic show you how to define two types of horizontal filters:

• Defining simple horizontal filters
• Defining complex horizontal filters

Tareas relacionadas

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

Consulta relacionada

• Syntax for filters