User's Manual

Chapter 14. Utilities and Options Reference
not needed in Adaptive Server Anywhere setups, messages will be slightly
smaller with the option off.
Quote_all_identifiers option Controls whether SQL statements being
replicated by SQL Remote should use quoted identifiers. The default is OFF.
When this option is off, the dbremote quotes identifiers that require quotes
by Adaptive Server Anywhere (as it has always done) and ssremote does not
quote any identifiers. When the option is on, all identifiers are quoted.
Replication_error option Specifies a stored procedure called by the
Message Agent when a SQL error occurs. By default no procedure is called.
The replication error procedure must have a single argument of type CHAR,
VARCHAR, or LONG VARCHAR. The procedure may be called once with
the SQL error message and once with the SQL statement that causes the
error.
While the option allows you to track and monitor SQL errors in replication,
you must still design them out of your setup: this option is not intended to
resolve such errors.
You can use a table with DEFAULT CURRENT REMOTE USER to record
the remote site that caused the error.
Save_remote_passwords option When a password is entered into the
message link dialog box on first connection, the parameter values are saved.
By default, Save_remote_passwords is ON and the password is saved. If you
are storing the message link parameters externally, rather than in the
database, you may wish not to save the passwords. You can prevent the
passwords from being saved by setting this option to NO.
SR_Date_Format option The Message Agent uses this option when
replicating columns that store a date. The option is a string build from the
following symbols:
Symbol Description
yy Two digit year
yyyy Four-digit year
mm Two-digit month
mmm Character format for month
dd Two-digit day
Each symbol is substituted with the date being replicated.
If you set the mm format symbol in upper case, the corresponding characters
317