ASA SQL Reference
SQL Statements
Use this statement to restart logging of deletes for MobiLink synchronization.
START SYNCHRONIZATION DELETE
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. You can temporarily suspend automatic logging of delete operations using the STOP SYNCHRONIZATION DELETE statement. The START SYNCHRONIZATION DELETE statement allows you to restart the automatic logging.
When a STOP SYNCHRONIZATION DELETE statement is executed, none of the 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.
Must have DBA authority.
None.
STOP SYNCHRONIZATION DELETE statement [MobiLink]
StartSynchronizationDelete method
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not applicable.
The following sequence of SQL statements illustrates how to use START SYNCHRONIZATION DELETE and STOP SYNCHRONIZATION DELETE.
-- Prevent deletes from being sent -- to the consolidated database STOP SYNCHRONIZATION DELETE; -- Remove all records older than 1 month -- from the remote database, -- NOT the consolidated database DELETE FROM PROPOSAL WHERE last_modified < months( CURRENT TIMESTAMP, -1 ) -- Re-enable all deletes to be sent -- to the consolidated database -- DO NOT FORGET to start this START SYNCHRONIZATION DELETE; -- Commit the entire operation, -- otherwise rollback everything -- including the stopping of the deletes commit;