SQL Remote User's Guide
  Tutorials for Adaptive Server Anywhere Users
    Tutorial: Adaptive Server Anywhere replication using Interactive SQL and dbxtract
      Set up the consolidated database

Create a SQL Remote message type

All messages sent as part of replication use a message type. A message type description has two parts:

• A message link supported by SQL Remote. In this tutorial, we use the FILE link.

• An address for this message link, to identify the source of outgoing messages.

To create the message type

• In Interactive SQL, create the file message type using the following statement:

CREATE REMOTE MESSAGE
TYPE file
ADDRESS 'hq'

The address (hq) for a file link is a directory in which files containing the message are placed. It is taken relative to the SQLRemote environment variable or registry entry. As you have not set this value, the address is taken relative to the directory from which the Message Agent is run. You should run the Message Agent from your tutorial directory for the addresses to be interpreted properly.

For information about setting the SQLRemote value, see Setting message type control parameters.