The following options are included to provide control over SQL Remote replication behavior.
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 |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |