Use the following procedure to create a publication using the SUBSCRIBE BY clause. For information about using the SUBSCRIBE BY clause and its alternative the WHERE clause, see Publish only some rows in a table.
Use the SQL Anywhere 12 plug-in to connect to the consolidated database as a user with DBA authority.
In the left pane, 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 SUBSCRIBE BY Restrictions page:
Click a table in the Articles list.
Click Column and click a column from the dropdown list.
Connect to the database as a user with DBA authority.
Execute a CREATE PUBLICATION statement that includes a SUBSCRIBE BY clause.
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|