lt={ ON | OFF | SHARE | EXCLUSIVE }; ...

LockTables={ ON | OFF | SHARE | EXCLUSIVE }; ...

SHARE means that dbmlsync locks all synchronization tables in shared mode. EXCLUSIVE means that dbmlsync locks all synchronization tables in exclusive mode. For all platforms except Windows Mobile, ON is the same as SHARE. For Windows Mobile devices, ON is the same as EXCLUSIVE.

The default is OFF. By default, dbmlsync does not lock any synchronization tables except for the following situations:

• If there is a publication that uses script-based upload in the current synchronization or if there is an sp_hook_dbmlsync_schema_upgrade hook defined in the remote database, dbmlsync locks the synchronization tables with SHARE.

Set to ON to prevent modifications during synchronization.

For more information about shared and exclusive locks, see How locking works and LOCK TABLE statement.

For more information about locking tables in MobiLink applications, see Concurrency during synchronization.

When synchronization tables are locked in exclusive mode (the default for Windows Mobile devices), no other connections can access the tables, and so dbmlsync stored procedures that execute on a separate connection are not able to execute if they require access to any of the synchronization tables.

For information about hooks that execute on separate connections, see Event hooks for SQL Anywhere clients.

• Summary of dbmlsync extended options

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

dbmlsync -e "lt=on"

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

CREATE SYNCHRONIZATION SUBSCRIPTION
   TO sales_publication
   FOR ml_user1
   OPTION lt='on';