Extended options can be specified on the dbmlsync command line using the -e or -eu options, or they can be stored in the database. You store extended options in the database by using Sybase Central, by using the sp_hook_dbmlsync_set_extended_options event hook, or by using the OPTION clause in any of the following statements:

Priority order

Dbmlsync combines options stored in the database with those specified on the command line. If conflicting options are specified, dbmlsync resolves them as follows. In the following list, options specified by methods occurring earlier in the list take precedence over those occurring later in the list.

You can review extended options in the log and the SYSSYNC system view.

For information about how extended options can be used to tune synchronization, see Using dbmlsync extended options.

See also

• -e option
• -eu option
• CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
• ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
• CREATE SYNCHRONIZATION USER statement [MobiLink]
• ALTER SYNCHRONIZATION USER statement [MobiLink]
• CREATE PUBLICATION statement [MobiLink] [SQL Remote]
• ALTER PUBLICATION statement [MobiLink] [SQL Remote]
• SYSSYNC system view
• sp_hook_dbmlsync_set_extended_options

Example

The following dbmlsync command line illustrates how you can set extended options when you start dbmlsync:

dbmlsync -e "adr=host=localhost;dir=c:\db\logs"...

The following SQL statement illustrates how you can store extended options in the database:

CREATE SYNCHRONIZATION SUBSCRIPTION TO mypub
   FOR mluser
   ADDRESS 'host=localhost'
   OPTION schedule='weekday@11:30am-12:30pm', dir='c:\db\logs'

The following dbmlsync command line opens the usage screen that lists options and their syntax:

dbmlsync -l