Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Remote » SQL Remote Utilities and Options Reference

Extraction utility Next Page

SQL Remote options


Function

Replication options are database options included to provide control over replication behavior.

Syntax

SET [ TEMPORARY ] OPTION
[ userid. | PUBLIC. ]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

These options are used by the Message Agent, and should be set for the user ID specified in the Message Agent command. They can also be set for general public use.

The following options are available.

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 [MobiLink client] [SQL Remote] [Replication Agent] 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
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