Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » Context-Sensitive Help » SQL Anywhere plug-in help » Introduction to SQL Anywhere properties windows

 

Publication Properties window: SUBSCRIBE BY Restrictions tab

The SUBSCRIBE BY Restrictions tab lets you define a subset of rows of a table for inclusion in the article.

This tab only applies to SQL Remote publications and is only shown if the publication has a synchronization type of log scan.

This tab has the following components:

Articles list   Select an article from the list of articles included in the publication.

This article has the following SUBSCRIBE BY restriction   You can choose one of the following options for the SUBSCRIBE BY restriction for the article:

  • None   Select this option if the article does not have a SUBSCRIBE BY restriction.

  • Column   Sets the article to partition rows from the table based on a column (SUBSCRIBE BY columns). Once you select this option, you must select a column from the dropdown list.

  • Expression   Sets the article to partition rows from the table based on an expression specified in the field below.

See also