ASA SQL Reference
  SQL Statements

STOP SYNCHRONIZATION DELETE statement [MobiLink]

Description 

Use this statement to temporarily stop logging of deletes for MobiLink synchronization.

Syntax 

STOP SYNCHRONIZATION DELETE

Usage 

Ordinarily, Adaptive Server Anywhere automatically logs any changes made to tables or columns that are part of a synchronization template and uploads these changes to the consolidated database during the next synchronization. This statement allows you to temporarily suspend logging of changes to an Adaptive Server Anywhere remote database.

When a STOP SYNCHRONIZATION DELETE statement is executed, none of the subsequent delete operations executed on that connection will be synchronized. The effect continues until a START SYNCHRONIZATION DELETE statement is executed. The effects do not nest; that is, subsequent execution of stop synchronization delete after the first will have no additional effect. A single START SYNCHRONIZATION DELETE statement restarts the logging, regardless of the number of STOP SYNCHRONIZATION DELETE statements preceding it.

This command can be useful to make corrections to a remote database, but should be used with caution as it effectively disables MobiLink synchronization.

Permissions 

Must have DBA authority.

Side Effects 

None.

See also 

StartSynchronizationDelete method

StopSynchronizationDelete method

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not applicable.

Example 

For an example, see START SYNCHRONIZATION DELETE statement [MobiLink].