Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » MobiLink - Server Administration » MobiLink Reference » MobiLink server system procedures » MobiLink system procedures


ml_reset_sync_state system procedure

Use this procedure to reset synchronization state information in MobiLink system tables.

ml_reset_sync_state ( 




VARCHAR(128). The MobiLink user name.


VARCHAR(128). The remote ID.


The parameters can be null. If both parameters are null, this procedure does nothing.

This stored procedure sets the progress, last_upload_time, and last_download_time columns in the ml_subscription table to their default values for the given user_name and remote ID. The default value for the progress is 0. The default value for the last_upload_time and last_download_time columns is '1900/01/01 00:00:00'.

If the remote ID is null and the MobiLink user name is not null, this procedure sets those columns to the default values for the rows in the ml_subscription table referenced by the given MobiLink user name. If the MobiLink user name is null and the remote ID is not null, it sets them to the default values for the rows in the ml_subscription table with the given remote ID.

Use this stored procedure with extreme caution. The MobiLink server does not do any synchronization status checking for this remote ID the next time the MobiLink client requests synchronization for this remote ID. It may cause data inconsistency to reset a remote ID that did not have a successful synchronization in the last synchronization.

For DB2 mainframe consolidated database types, this procedure is called ml_reset_sstate. See IBM DB2 mainframe system procedure name conversions.