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.

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.
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:
1. Click a table in the Articles list.
2. Type a WHERE clause into the The Selected Article Has The Following WHERE Clause field.
Click Finish.

Results

The publication is created as specified.

Next

Add a subscription.