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

CREATE SUBSCRIPTION statement

Function

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

Syntax

CREATE SUBSCRIPTION
TO publication-name [ ( subscription-value ) ]
FOR subscriber-id

publication-name: identifier

subscription-value, subscriber-id : string

subscriber-id : string

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

Permissions

Must have DBA authority.

Side effects

Automatic commit.