User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To stop a subscription for a user to a publication.

Syntax

     STOP SUBSCRIPTION TO publication-name [ ( constant ) ]
          ...     FOR userid,...

Usage

Anywhere. This statement is applicable only to SQL Remote.

Permissions

Must have DBA authority.

Side effects

Automatic commit.

See also

• CREATE SUBSCRIPTION statement
• SYNCHRONIZE SUBSCRIPTION statement
• "Synchronizing databases",

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