Filtering data vertically

Vertical filtering uses the Target columns page of the Advanced Subscription Definition notebook for DB2 DataPropagator subscriptions and the Rows page of Advanced Replication Subscription notebook for JDBC subscription. 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.

This section uses a sample table with 7 columns. The characteristics of this sample table are: 

Column name    data type  nullable?    default value
NOTNULLINT1    INTEGER    NO
NOTNULLCHAR1   CHAR       NO
NOTNULLDATE1   DATE       NO
DEFAULTINT1    INT        YES          1000
DEFAULTCHAR1   CHAR       YES          'a'
DEFAULTDATE1   DATE       YES          '2001-06-29'
ID             INTEGER    NO

The ID column is the primary key.

Procedure

To vertically filter data:

  1. On the Target Columns page, unsubscribe the columns you do not want to synchronize to the client. To unsubscribe a column, clear the Subscribe check box. For example, using the sample table, clear the Subscribe check box for the first four columns: NOTNULLINT1, NOTNULLCHAR1, NOTNULLDATE1, and DEFAULTINT1.
  2. Select each unsubscribed column, and click Change to add a default value data filter. The Change Column window opens.
  3. Type a default value data filter parameter in the Default value data filter field. Repeat for all unsubscribed columns. The example table uses the parameters: :PARAMINT1, :PARAMCHAR1, :PARAMDATE1, and :PARAMINT2.
  4. Close the Subscription notebook.

The default value data-filter parameters are used by the group to provide a default value for the unsubscribed columns. Data inserted to the data source from the client will be composed of the columns of data on the client combined with default column values defined for the group to complete the rows of data inserted to the data source. The next step is to define the default value data filter parameter values.

Related tasks

Related reference