vr={ ON | OFF }; ...

VerboseRowValues={ ON | OFF }; ...

This option is identical to dbmlsync -vr. If you specify both -v and the extended options and there are conflicts, the -v option overrides the extended option. If there is no conflict, the verbosity logging options are additive—all options that you specify are used. When logging verbosity is set by extended option, the logging does not take effect immediately, so startup information is not logged. By the time of the first synchronization, the logging behavior is identical between the -v options and the extended options.

The default is OFF.

• Summary of dbmlsync extended options
• -v dbmlsync option
• Verbose (v) extended option
• Verbose (v) extended option
• VerboseMin (vm) extended option
• VerboseOptions (vo) extended option
• VerboseRowCounts (vn) extended option
• VerboseUpload (vu) extended option

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

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