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

In the left pane, open the Publications folder.
Select the desired publication. You can perform the following tasks in Sybase Central:
In the right pane, click the SQL Remote Subscriptions tab. You can configure the appropriate settings as follows:
- To subscribe a remote user to the publication, from the File menu choose New » SQL Remote Subscription and follow the instructions in the Create SQL Remote Subscription Wizard.
- To unsubscribe a remote user, right-click the user in the Subscribers list and choose Delete.
- To manually start, stop, or synchronize subscriptions, select the user in the Subscribers list and choose Properties.
  Click the Advanced tab. On this tab, click Start Now to start subscriptions, Stop Now to stop subscriptions, or Synchronize Now to synchronize subscriptions.
  
  The subscriptions are affected as soon as you click the button. Subsequently clicking Cancel on the properties window does not cancel your start/stop/synchronize action.

Subscriptions with no subscription expression

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

User ID The user who is being subscribed to the publication. This user must have been granted remote permissions.
Publication name The name of the publication to which the user is being subscribed.

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

CREATE SUBSCRIPTION
TO PubOrdersSamuelSinger
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:

User ID The user who is being subscribed to the publication. This user must have been granted remote permissions.
Publication name The name of the publication to which the user is being subscribed.
Subscription value The value that is to be tested against the subscription expression of the publication. For example, if a publication has the name of a column containing an employee ID as a subscription expression, the value of the employee ID of the subscribing user must be provided in the subscription. The subscription value is always a string.

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

CREATE SUBSCRIPTION
TO PubOrders ( '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.

See CREATE SUBSCRIPTION statement [SQL Remote].

Send feedback about this page via email or DocCommentXchange