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 » SQL Remote » Creating SQL Remote systems » Publications and articles » Publish only some rows in a table

 

Publishing only some rows using a WHERE clause

Create a publication that uses a WHERE clause to include all the columns, but only some of the rows of a table.

Prerequisites

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Context and remarks

Users can subscribe to more than one publication, and can have more than one subscription to a single publication.

For information about using the WHERE clause and its alternative the SUBSCRIBE BY clause, see Publish only some rows in a table.

 Task
  1. Using Sybase Central, connect to the consolidated database.

  2. Double-click the Publications folder.

  3. Click File » New » Publication.

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

  5. Click Next.

  6. In the Available Tables list, click a table. Click Add. Click Next.

  7. On the Available Columns tab, double-click the table's icon to expand the list of Available Columns. Click each column you want to publish and click Add. Click Next.

  8. On the Specify WHERE Clauses page:

    1. Click a table in the Articles list.

    2. Type a WHERE clause into the The Selected Article Has The Following WHERE Clause field.

  9. Click Finish.

Results

The publication is created as specified.

Next

Add a subscription.

 See also