User's 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: identiﬁer

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.

See also “CREATE SUBSCRIPTION statement [SQL Remote]” [ASA SQL Reference,

page 400]

“DROP SUBSCRIPTION statement” on page 363

“GRANT REMOTE statement” on page 366

“SYNCHRONIZE SUBSCRIPTION statement” on page 377

“START SUBSCRIPTION statement” on page 375

“sp_subscription procedure” on page 433

358