Set remote message type control parameters

The message control parameters are held in the database. Use the following procedure to set the control parameter.

To set a message control parameter (SQL)

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';
See SET REMOTE OPTION statement [SQL Remote].

To view the message link parameters (SQL)

Query the SYSREMOTEOPTION system view.

For example:
SELECT * from SYSREMOTEOPTION;
See SYSREMOTEOPTION system view.

Message link parameters stored on disk

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 SQL Remote 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 SQL Remote 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.