SQL Remote options

Replication options are database options included to 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 [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
sr_timestamp_with_time_zone_format [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

Discuter à propos de cette page dans DocCommentXchange.