Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Remote » SQL Remote reference » SQL Remote utilities and options reference

SQL Remote options

Replication options are database options that provide control over replication behavior.

Syntax
SET [ 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.
Remarks

These 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 option [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 option [SQL Remote] timestamp-string yyyy/mm/dd hh:nn:ss.Ssssss
sr_timestamp_with_time_zone_format option [SQL Remote] timestamp-with-time-zone-string yyyy/mm/dd hh:nn:ss.Ssssss +hh:nn
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