CREATE SUBSCRIPTION statement
Function Usethis statement to create a subscription for a user to a publication.
Syntax CREATESUBSCRIPTION
TOpublication-name [ ( subscription-value ) ]
FORsubscr iber-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
Astring that is compared to the subscription expression
of the publication. The subscriber receives all rows
for which the subscription expression matches the
subscriptionvalue.
subscriber-id
The user ID of the subscriber to the publication. This
usermust have been granted REMOTE permissions.
Permissions Musthave DBA authority.
Sideeffects Automaticcommit.
Seealso “CREATESUBSCRIPTION statement [SQL Remote]” [ASA SQL Reference,
page400]
“DROPSUBSCRIPTION statement” on page 363
“GRANTREMOTE statement” on page 366
“SYNCHRONIZESUBSCRIPTION statement” on page 377
“STARTSUBSCRIPTION statement” on page 375
“sp_subscriptionprocedure” on page 433
358