Contents Index Increment (inc) extended option Memory (mem) extended option

MobiLink Synchronization Reference
  MobiLink Synchronization Client
    dbmlsync options
      -e extended options

LockTables (lt) extended option

Function 

Specifies that articles (table or parts of tables in the publications being synchronized) should be locked before synchronizing.

Syntax 

dbmlsync -e lt= { ON | OFF | SHARE | EXCLUSIVE }; ...

Description 

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 CE, ON is the same as SHARE. For Windows CE devices, ON is the same as EXCLUSIVE. The default is ON.

Set to OFF to allow 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 CE devices), no other connections can access the tables, and so dbmlsync stored procedures that require a separate connection will not be able to execute if they require access to any of the synchronization tables. The stored procedures that require a separate connection are

This option has a short form and long form: you can use lt or LockTables.

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

Example 

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';

Contents Index Increment (inc) extended option Memory (mem) extended option