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

SQL Anywhere 12.0.1 » Context-Sensitive Help » SQL Anywhere plug-in help » SQL Anywhere properties windows

 

Publication Properties window: WHERE Clauses tab

Articles defined for MobiLink and SQL Remote publications use a WHERE clause to define a subset of rows of a table to be included in an article. This tab only applies and is only shown when the publication has a synchronization type of log scan.

The WHERE Clauses tab lets you supply a WHERE clause to restrict the rows that are included in the client database.

This tab has the following components:

  • Articles list   Select an article (a table) from the list of articles included in the publication.

  • The selected article has the following WHERE clause   In the text box, type the WHERE clause for the table to restrict the rows that are included in the article.

The following example creates a single-article publication that includes all sales order information for sales rep number 856.

CREATE PUBLICATION pub_orders_samuel_singer
 ( TABLE SalesOrders
     WHERE SalesRepresentative = 856 );
 See also