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

publication-name : identifier

subscription-value : string

subscriber-id : string

In SQL Remote, publications and subscriptions are two-way relationships. If you create a subscription for a remote user to a publication on a consolidated database, you should also create a subscription for the consolidated user to a publication on the remote database. By default, the Extraction utility (dbxtract) and the Extract Database Wizard grant the appropriate PUBLISH and CONSOLIDATE permissions to users in the remote databases.

If subscription-value is supplied, it is matched against each SUBSCRIBE BY expression in the publication. The subscriber receives all rows for which the value of the expression is equal to the supplied string.

DBA authority

Automatic commit.

• DROP SUBSCRIPTION statement [SQL Remote]
• GRANT REMOTE statement [SQL Remote]
• GRANT CONSOLIDATE statement [SQL Remote]
• SYNCHRONIZE SUBSCRIPTION statement [SQL Remote]
• START SUBSCRIPTION statement [SQL Remote]
• GRANT PUBLISH statement [SQL Remote]
• ISYSSUBSCRIPTION system table
• Subscriptions
• Replicate the primary key pool
• Publish only some rows in a table
• Publishing only some rows using the SUBSCRIBE BY clause
• Publishing only some rows using a WHERE clause

The following statement creates a subscription for the user p_chin to the publication pub_sales. The subscriber receives all rows for which the subscription expression has a value of Eastern.

CREATE SUBSCRIPTION
TO pub_sales ( 'Eastern' )
FOR p_chin;