SQL Remote User's Guide
Command Reference for Adaptive Server Anywhere
Use this statement to create a subscription for a user to a publication.
CREATE SUBSCRIPTION
TO publication-name [ ( subscription-value ) ]
FOR subscriber-id
publication-name: identifier
subscription-value, subscriber-id: string
subscriber-id: string
| Parameter | Description |
|---|---|
| publication-name | The name of the publication to which the user is being subscribed. This may include the owner of the publication. |
| subscription-value | A string that is compared to the subscription expression of the publication. The subscriber receives all rows for which the subscription expression matches the subscription value. |
| subscriber-id | The user ID of the subscriber to the publication. This user must have been granted REMOTE permissions. |
Must have DBA authority.
Automatic commit.
CREATE SUBSCRIPTION statement [SQL Remote]
SYNCHRONIZE SUBSCRIPTION statement