Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Configuring Your Database » Database options » Introduction to database options » Option classification

 

SQL Remote options

The following options are included to provide control over SQL Remote replication behavior.

Option Values Default
blob_threshold option [SQL Remote] Integer (in kilobytes) 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
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0