Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 17. Command Reference for Adaptive Server Anywhere       

STOP SUBSCRIPTION statement

Function 

To stop a subscription for a user to a publication.

Syntax 

STOP SUBSCRIPTION
... TO publication-name [ ( subscription-value) ]
... FOR subscriber-id,...

Parameters 

Parameter	Description
publication-name	The name of the publication to which the user is being 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.
subscriber-id	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.

See also 

CREATE SUBSCRIPTION statement

SYNCHRONIZE SUBSCRIPTION statement

Description 

A SQL Remote subscription is said to be started when publication updates are being sent from the consolidated database to the remote database.

The STOP SUBSCRIPTION statement prevents any further messages being sent to the subscriber. The START SUBSCRIPTION statement is required to restart messages being sent to the subscriber. However, you should ensure that the subscription is properly synchronized before restarting: that no messages have been missed.

Example 

The following statement starts the subscription of user SamS to the pub_contact publication.

STOP SUBSCRIPTION TO pub_contact
FOR SamS