Contents Index STOP SUBSCRIPTION statement UPDATE statement

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

SYNCHRONIZE SUBSCRIPTION statement


Function 

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

Syntax 

SYNCHRONIZE SUBSCRIPTION
TO publication-name [ ( subscription-value) ]
FOR remote-user, ...

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.
remote-user 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 

SYNCHRONIZE SUBSCRIPTION statement [SQL Remote]

CREATE SUBSCRIPTION statement

START SUBSCRIPTION statement


Contents Index STOP SUBSCRIPTION statement UPDATE statement