User's Guide

Part III. Using SQL Anywhere

Chapter 28. SQL Remote Administration

To subscribe to a publication, each subscriber must be granted REMOTE permissions (see "Granting and revoking REMOTE and CONSOLIDATE permissions") and a subscription must also be created for that user. 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

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

     CREATE SUBSCRIPTION
     TO pub_orders ( '856' )
     FOR SamS

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".