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.

Fields and controls



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