Contents Index SET REMOTE OPTION statement STOP SUBSCRIPTION statement

SQL Remote User's Guide
  Command Reference for Adaptive Server Anywhere

START SUBSCRIPTION statement


Function 

Use this statement to start a subscription for a user to a publication.

Syntax 

START SUBSCRIPTION
TO publication-name [ ( subscription-value ) ]
FOR subscriber-id, ...

Parameters 
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 value is required here because each subscriber may have more than one subscription to a publication.
subscriber-id The user ID of the subscriber to the publication. This user must have a subscription to the publication.
Permissions 

Must have DBA authority.

Side effects 

Automatic commit.

See also 

START SUBSCRIPTION statement [SQL Remote]

CREATE SUBSCRIPTION statement

REMOTE RESET statement

SYNCHRONIZE SUBSCRIPTION statement

sp_subscription procedure


Contents Index SET REMOTE OPTION statement STOP SUBSCRIPTION statement