The message control parameters are held in the database. Use the following procedure to set the control parameter.
Execute a SET REMOTE OPTION statement.
For example, the following statement sets the FTP host to ftp.mycompany.com for the FTP link for user myuser:
SET REMOTE FTP OPTION myuser.host = 'ftp.mycompany.com';
Query the SYSREMOTEOPTION system view.
SELECT * from SYSREMOTEOPTION;
Earlier versions of SQL Remote stored the message link parameters outside the database. The external storage of message link parameters is not recommended.
The message link control parameters are stored in the following locations:
Windows In the registry, at the following location:
\\HKEY_CURRENT_USER \Software \Sybase \SQL Remote
The parameters for each message link are stored in a key under the SQL Remote key, with the name of the message link (4, SMTP, for example).
Unix The FILE system directory setting is stored in the SQLREMOTE environment variable.
The SQL Remote environment variable stores a path that can be used as an alternative to one of the control parameters for the FILE messaging system.
When the Message Agent (dbremote) loads a message link, the link uses the setting of the current publisher or, if a setting is not specified, of groups to which the publisher belongs.
On Windows, when the Message Agent (dbremote) that supports storing the message link parameters in the database is run for the first time, it copies the link options from the registry to the database.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|