User's Manual

Deprecated feature
In the next major release of SQL Anywhere Studio, SQL Remote for
Adaptive Server Enterprise will not be present. MobiLink provides a
more flexible and scalable solution for data synchronization between
Adaptive Server Enterprise and Adaptive Server Anywhere databases.
You can also run the Message Agent from your own application by calling
into the DBTools library. For more information, see the file dbrmt.h in the h
subdirectory of your SQL Remote installation directory.
For Adaptive Server Anywhere, the user ID in the Message Agent command
must have either REMOTE DBA or DBA authority. For Adaptive Server
Enterprise, the user ID must have replication role.
The optional directory parameter specifies a directory in which old
transaction logs are held, so that the Message Agent has access to events
from before the current log was started.
The Message Agent uses a number of connections to the database. For a
listing, see “Connections used by the Message Agent” on page 224.
☞ For information on REMOTE DBA authority, see “The Message Agent
and replication security” on page 243.
Option details @data Use this option to read in options from the specified environment
variable or configuration file. If both exist with the same name, the
environment variable is used.
The environment variable may contain any set of options. For example, the
first of the following pair of statements sets an environment variable holding
a set of options for a database server that starts with a cache size of 4 Mb,
receives messages only, and connects to a database named field on a server
named myserver. The set statement should be entered all on one line:
set envvar=-m 4096 -r
-c "eng=myserver;dbn=field;uid=sa;pwd=sysadmin"
ssremote @envvar
The configuration file may contain line breaks, and may contain any set of
options. For example, the following command file holds a set of options for
a Message Agent that starts with a cache size of 4 Mb, sends messages only,
and connects to a database named field on a server named myserver:
-m 4096
-s
-c "eng=myserver;dbn=field;uid=sa;pwd=sysadmin"
If this configuration file is saved as c:\config.txt , it can be used in a
command as follows:
294