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
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0