Specifying a subset of rows for a subscription

Use the Rows page of the Advanced Subscription Definition notebook to create a WHERE clause to specify that only a subset of rows be copied to the target table.

To specify a subset of rows for a subscription:

1. Open the Rows page of the Advanced Subscription Definition notebook.

2. Optional: Click on Examples for a list of sample predicates.

3. Type any valid SQL predicate in the WHERE field. Only source table rows meeting the conditions of the WHERE clause are copied to the target table.

   Do not type the word WHERE. The replication program automatically provides this word. Do not end the clause with a semicolon. Enclose expressions separated by the boolean OR operator in parentheses.

4. If you are finished with this notebook, click on OK. Otherwise, click on one of the other two notebook tabs to specify additional information for the subscription.

Related information

• Setting up sources and targets for a subscription
• Specifying read-only, replica, or row replica target tables for a subscription
• Specifying target columns for a subscription

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]