Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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.
Contexte et remarques
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.
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|