Sybase SQL Remote DC38133-01-0902-01 User Manual

Chapter 17. 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 be-
ing 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.