Replication options are database options included to provide control over replication behavior.
SyntaxSET [ TEMPORARY ] OPTION [ userid. | PUBLIC. ]option-name = [ option-value ]
| Parameter | Description |
|---|---|
| option-name | The name of the option being changed. |
| option-value | A string containing the setting for the option. |
RemarksThese options are used by the SQL Remote Message Agent, and should be set for the user ID specified in the SQL Remote Message Agent command. They can also be set for general public use.
| 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 [SQL Remote] | 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 |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |