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