Contents Index Primary key pool summary SQL Remote Design for Adaptive Server Enterprise

SQL Remote User's Guide
  SQL Remote Design for Adaptive Server Anywhere

Creating subscriptions


To subscribe to a publication, each subscriber must be granted REMOTE permissions and a subscription must also be created for that user. The details of the subscription are different depending on whether or not the publication uses a subscription expression.

Working with subscriptions in Sybase Central 

To create and manage subscriptions in Sybase Central

  1. In the left pane, open the Publications folder.

  2. Select the desired publication. You can perform the following tasks in Sybase Central:

  3. In the right pane, click the SQL Remote Subscriptions tab. You can configure the appropriate settings as follows:

Subscriptions with no subscription expression 

To subscribe a user to a publication, if that publication has no subscription expression, you need the following information:

The following statement creates a subscription for a user ID SamS to the pub_orders_samuel_singer publication, which was created using a WHERE clause:

CREATE SUBSCRIPTION
TO pub_orders_samuel_singer
FOR SamS
Subscriptions with a subscription expression 

To subscribe a user to a publication, if that publication does have a subscription expression, you need the following information:

The following statement creates a subscription for Samuel Singer (user ID SamS, employee ID 856) to the pub_orders publication, defined with a subscription expression sales_rep, requesting the rows for Samuel Singer's own sales:

CREATE SUBSCRIPTION
TO pub_orders ( '856' )
FOR SamS
Starting a subscription 

In order to receive and apply updates properly, each subscriber needs to have an initial copy of the data. The synchronization process is discussed in Synchronizing databases.

For more information, see CREATE SUBSCRIPTION statement.


Contents Index Primary key pool summary SQL Remote Design for Adaptive Server Enterprise