Setting remote message type control parameters

The message control parameters are held in the database. To set the control parameter, execute a SET REMOTE OPTION statement. You must have the SYS_REPLICATION_ADMIN_ROLE system role.

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';

To view the message link parameters (using SQL), query the SYSREMOTEOPTION system view:

SELECT * from SYSREMOTEOPTION;

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.

Setting remote message type control parameters

Message link parameters stored on disk

See also