scn={ ON | OFF }; ...

SendColumnNames={ ON | OFF }; ...

The default is ON.

Because column name are sent by default, the ml_add_column stored procedure is not required for most deployments. If you want ml_add_column names to be used, this option must be set to OFF. This approach is required if you want to refer to remote column names using aliases, or if the column information added using ml_add_column is preferred over the information automatically sent up from the remote. See ml_add_column system procedure.

The column names are used by the MobiLink server for direct row handling. When using the row handling API to refer to columns by name rather than by index, this option should be set to ON. See Direct row handling.

If you are using the mlreplay utility, this option should be set to ON so the replay API has meaningful column names.

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

dbmlsync -e "scn=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 scn='on';