iAnywhere.com - Priority order for extended options and connection parameters

Priority order for extended options and connection parameters

The CREATE/ALTER SYNCHRONIZATION USER and CREATE/ALTER SYNCHRONIZATION SUBSCRIPTION statements allow you to store extended options and connection parameters in the database and associate them with subscriptions, users or publications. The dbmlsync utility reads this information from the database.

Note: You specify options for a publication by using the CREATE SYNCHRONIZATION SUBSCRIPTION statement and omitting the FOR clause.

If extended options are specified in both the database and the command line, the option strings are combined. If conflicting options are specified, dbmlsync resolves them as follows, where options specified by earlier in the list take precedence over those occurring later in the list.

options specified in the sp_hook_dbmlsync_set_extended_options event hook.
options specified on the command line that aren't extended options. (For example, -ds overrides -e "ds=off".)
options specified on the command line with the dbmlsync -eu option.
options specified on the command line with the dbmlsync -e option.
options saved with the subscription definition (whether using SQL statements or Sybase Central).
options saved with the user definition (whether using SQL statements or Sybase Central).
options saved with the publication definition (whether using SQL statements or Sybase Central).

If the connection TYPE or ADDRESS is specified in more than one place, the one specified with the highest priority according to the list above overrides any other specification.