User's Manual

Chapter 18. Command Reference for Adaptive Server Enterprise
sp_remote_option procedure
Purpose To set a SQL Remote option.
Syntax sp_remote_option option_name,
option_value
Argument Description
option_name The name of one of the SQL Remote options
option_value The value to which the option is set.
See also “SQL Remote options” on page 315.
Description The SQL Remote options provide control over replication behavior. The
following options are available in Adaptive Server Enterprise:
OPTION VALUES DEFAULT
Blob_threshold Integer, in K 256
Compression -1 to 9 6
Delete_old_logs ON, OFF OFF
Qualify_owners ON, OFF ON
Quote_all_identifiers ON, OFF OFF
Replication_error procedure-name NULL
SR_Date_Format time-string hh:mm:ss.Ssssss
SR_Time_Format date-string yyyy/mm/dd
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
☞ For a complete description of these options, see “SQL Remote options”
on page 315.
Example
♦ The following statement sets the Verify_all_columns option to OFF, so
that old values of update statements applied by the Message Agent are
not checked automatically for all columns.
425