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)
To view the message link parameters (SQL)
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 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.

See also