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 - Client Administration » SQL Anywhere Clients for MobiLink » MobiLink SQL Anywhere client extended options


ConflictRetries (cr) extended option

Specifies the number of retries if the download fails because of conflicts.

cr=number; ...

When the extended option LockTables is set to OFF (preventing dbmlsync from obtaining locks on the tables being synchronized), it is possible for operations to be applied to the database between the time the upload is built and the time that the download is applied. If these changes affect rows that are also changed by the download, dbmlsync considers this to be a conflict and does not apply the download stream. When this occurs dbmlsync retries the entire synchronization. This option controls the number of retries that are performed.

This option is useful only if the LockTables option is OFF, which is not the default.

The default is -1 (retries should continue indefinitely).

This option has a short form and long form: you can use cr or ConflictRetries.

You can also store extended options in the database. For more information about dbmlsync extended options, see Introduction to dbmlsync extended options.

See also

The following dbmlsync command line illustrates how you can set this option when you start dbmlsync:

dbmlsync -e "cr=5"

The following SQL statement illustrates how you can store this option in the database:

   TO sales_publication
   FOR ml_user1
   OPTION cr='5';