SQL Remote User's Guide
Command Reference for Adaptive Server Enterprise
To set a SQL Remote option.
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. |
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 | OFF |
Quote_all_identifiers | ON, OFF | OFF |
Replication_error | procedure-name | NULL |
SR_Date_Format | time-string | hh:nn: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.
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.
sp_remote_option Verify_all_columns, OFF go