SQL Remote User's Guide
SQL Remote Administration
Using message types
Each message link has several parameters that govern aspects of its behavior. The parameters differ from message system to message system, but all are managed in the same way.
When you first use the Message Agent for a particular message link, it displays a dialog box showing a set of parameters that control the behavior of the link. These parameters may be a user ID for the message system, a host name where ftp messages are held, and so on. The parameters you enter are saved by the Message Agent. You can also set these parameters explicitly.
The message control parameters are held in the database. You can set the options as follows:
To set a message control parameter (Adaptive Server Anywhere)
Execute the following statement:
SET REMOTE link-name OPTION
[username.]option-name = option-value
To set a message control parameter (Adaptive Server Enterprise)
Execute the following statement:
exec sp_link_option link-name, [username],
option-name, option-value
You can see the current message link parameters by querying the sys.sysremoteoptions view (Adaptive Server Anywhere) or the sr_remoteoptions view (Adaptive Server Enterprise).
Earlier versions of this software stored the message link parameters outside the database. You can still use this method, but storing the parameters inside the database is recommended unless you have specific reasons to choose otherwise.
The message link control parameters are stored in the following places:
Windows In the registry, at the following location:
\\HKEY_CURRENT_USER
\Software
\Sybase
\SQL RemoteThe parameters for each message link go in a key under the SQL Remote key, with the name of the message link (4, smtp, and so on).
NetWare You should create a file named dbremote.ini in the sys:\system directory to hold the FILE system directory setting. This file is not a Windows-format INI file: it must consist of a single line, holding only the directory name.
For example, if the directory is user:\dbr43, then the dbremote.ini file would contain the following:
user:\dbr43
UNIX The FILE system directory setting is held in the SQLREMOTE environment variable.
The sqlremote environment variable holds a path that can be used as an alternative to one of the control parameters for the file sharing system.
The parameters available for each message system are discussed in the following sections. Each section describes a single message system.
When the Message Agent loads a message link, the link uses the settings of the current publisher or, of a setting is not specified, of groups to which the publisher belongs. On Windows, the first time a version of the Message Agent is run that supports storing the message link parameters in the database, it copies the link options from the registry to the database.