ASA SQL Reference
  SQL Statements

DROP SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

Description 

Use this statement to drop a synchronization subscription within a MobiLink remote database or a MobiLink reference database. You can also use it to drop a default subscription, which contains default subscription values, for the specified publication.

Syntax 

DROP SYNCHRONIZATION SUBSCRIPTION
TO publication-name
[ FOR ml_username, ... ]

Parameters 

TO clause    Specify the name of a publication.

FOR clause    Specify one more MobiLink users.

Omitting this clause drops the default subscription for the publication. MobiLink users subscribed to a publication inherit as defaults the values in a default publication.

Usage 

Drop a synchronization subscription in a MobiLink remote or reference database.

Permissions 

Must have DBA authority. Requires exclusive access to all tables referred to in the publication.

Side Effects 

Automatic commit.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

Examples 

Unsubscribe MobiLink user ml_user1 to the sales publication.

DROP SYNCHRONIZATION SUBSCRIPTION
   TO sales_publication
   FOR "ml_user1"

Drop the default subscription, which contains default subscription values, for the sales publication (by omitting the FOR clause).

DROP SYNCHRONIZATION SUBSCRIPTION
   TO sales_publication