Chapter 7. SQL Remote Design for AdaptiveSer verAnywhere
Creating subscriptions
Tosubscribe to a publication, each subscriber must be granted REMOTE
permissionsand a subscription must also be created for that user. Thedetails
ofthe subscription are different depending on whether or not the publication
usesa subscription expression.
Workingwith
subscriptions in Sybase
Central ❖Tocreate and manage subscriptions in Sybase Central
1. In the left pane, open the Publications folder.
2. Select the desired publication. Youcan perform the following tasks in
SybaseCentral:
3. In the right pane, click the SQL Remote Subscriptions tab. Youcan
configurethe appropriate settings as follows:
♦Tosubscribe a remote user to the publication, from the File menu
chooseNew ➤SQL Remote Subscription and follow the instructions
inthe SQL Remote Subscription Creation wizard.
♦Tounsubscribe a remote user, right-click the user in the Subscribers
listand choose Delete from the popup menu.
♦Tomanually start, stop, or synchronize subscriptions, select the user in
theSubscribers list and choose Properties from the popup menu.
Clickthe Advanced tab. On this tab, click Start Now to start
subscriptions,Stop Now to stop subscriptions, or Synchronize Now to
synchronizesubscriptions.
Thesubscriptions are affected as soon as you click the button.
Subsequentlyclicking Cancel on the property sheet does
not
cancel
yourstart/stop/synchronize action.
Subscriptions with no
subscription expression Tosubscribe a user to a publication, if that publication has no subscription
expression,you need the following information:
♦UserID Theuser who is being subscribed to the publication. Thisuser
musthave been granted remote permissions.
♦Publicationname Thename of the publication to which the user is
beingsubscribed.
Thefollowing statement creates a subscription for a user ID SamS to the
pub_orders_samuel_singerpublication, which was created using a
WHEREclause:
139