User's Manual

Chapter 14. Utilities and Options Reference
SQL Remote options
Function Replication options are database options included to provide control over
replication behavior.
Adaptive Server
Anywhere Syntax
SET [ TEMPORARY ] OPTION
[ userid. | PUBLIC. ]option_name = [ option_value ]
Adaptive Server
Enterprise syntax:
exec sp_remote_option option-name, option-value
Parameters
Argument Description
option_name The name of the option being changed.
option-value A string containing the setting for the option.
Description The following options are available.
OPTION VALUES DEFAULT
Blob_threshold integer, in kb 256
Compression –1 to 9 6
Delete_old_logs ON, OFF OFF
External_remote_options ON, OFF OFF
Qualify_owners ON, OFF ON
Quote_all_identifiers ON, OFF OFF
Replication_error procedure-name NULL
Save_remote_passwords ON, OFF ON
SR_Date_Format date-string yyyy/mm/dd
SR_Time_Format time-string hh:nn:ss.Ssssss
SR_Timestamp_Format timestamp-string yyyy/mm/dd
hh:nn:ss.Ssssss
Subscribe_by_remote ON,OFF ON
Verify_threshold integer 256
Verify_all_columns ON,OFF OFF
These options are used by the Message Agent, and should be set for the user
315