Create a publication that uses a WHERE clause to include all the columns, but only some of the rows of a table.
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.
Using Sybase Central, connect to the consolidated database.
Double-click the Publications folder.
Click File » New » Publication.
In the What Do You Want To Name The New Publication field, type a name for the publication. Click Next.
In the Available Tables list, click a table. Click Add. Click Next.
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.
On the Specify WHERE Clauses page:
Click a table in the Articles list.
Type a WHERE clause into the The Selected Article Has The Following WHERE Clause field.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|