Replication options are database options included to provide control over replication behavior.
SET [ TEMPORARY ] OPTION [ userid. | PUBLIC. ]option-name = [ option-value ]
| Argument | Description |
|---|---|
|
option-name |
The name of the option being changed. |
|
option-value |
A string containing the setting for the option. |
These options are used by the Message Agent, and should be set for the user ID specified in the Message Agent command. They can also be set for general public use.
The following options are available.
| Option | Values | Default |
|---|---|---|
| blob_threshold option [SQL Remote] | Integer (in bytes) | 256 |
| compression option [SQL Remote] | Integer, from -1 to 9 | 6 |
| delete_old_logs option [MobiLink client] [SQL Remote] [Replication Agent] | On, Off, Delay, n days | Off |
| external_remote_options [SQL Remote] | On, Off | Off |
| qualify_owners option [SQL Remote] | On, Off | On |
| quote_all_identifiers option [SQL Remote] | On, Off | Off |
| replication_error option [SQL Remote] | Stored procedure name | (no procedure) |
| replication_error_piece option [SQL Remote] | Stored procedure name | (no procedure) |
| save_remote_passwords option [SQL Remote] | On, Off | On |
| sr_date_format option [SQL Remote] |
date-string |
YYYY/MM/DD |
| sr_time_format option [SQL Remote] |
time-string |
HH:NN:SS.SSSSSS |
| sr_timestamp_format [SQL Remote] |
timestamp-string |
YYYY/MM/DD HH:NN:SS.SSSSSS |
| subscribe_by_remote option [SQL Remote] | On, Off | On |
| verify_all_columns option [SQL Remote] | On, Off | Off |
| verify_threshold option [SQL Remote] | Integer (in bytes) | 1000 |
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |