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

SAP Sybase SQL Anywhere 16.0 » MobiLink - Client Administration » SQL Anywhere clients for MobiLink » SQL Anywhere clients » Publications

 

Creating a publication using a WHERE clause

When no WHERE clause is specified in an article definition, all changed rows in the table are uploaded. Add WHERE clauses to articles in the publication to limit the rows to be uploaded to those that have changed and that satisfy the search condition in the WHERE clause.

Prerequisites

There is an existing remote database and you have the SYS_REPLICATION_ADMIN_ROLE system role.

Context and remarks

The search condition in the WHERE clause can only reference columns that are included in the article. In addition, you cannot use any of the following in the WHERE clause:

  • subqueries

  • variables

  • non-deterministic functions

These conditions are not enforced, but breaking them can lead to unexpected results. Any errors relating to the WHERE clause are generated when the DML is run against the table referred to by the WHERE clause, and not when the publication is defined.

 Task
  1. Connect to the remote database using the SQL Anywhere 16 plug-in.

  2. Double-click Publications.

  3. Click File » New » Publication.

  4. In the What Do You Want To Name The New Publication field, enter a name for the new publication. Click Next.

  5. Click Next.

  6. On the Available Tables list, select a table. Click Add.

  7. Click Next.

  8. Click Next.

  9. In the Articles List, select a table and enter the search condition in the The Selected Article Has the following WHERE clause pane.

  10. Click Finish.

Results

The new publication is created.

 See also