SQL Remote User's Guide
  Tutorials for Adaptive Server Anywhere Users
    Tutorial: Adaptive Server Anywhere replication using Sybase Central
      Setting up a consolidated database

Add 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.

Adaptive Server Anywhere databases already have message types created, but you need to supply an address for the message type you will use.

To add an address to a message type

1. From Sybase Central, connect to the HQ database.

2. Open the SQL Remote Users folder for the HQ database.

3. In the right pane, click the Message Types tab.

4. In the right pane, right-click the FILE message type and choose Properties from the popup menu.

5. Enter a publisher address to provide a return address for remote users. Enter the directory you have created to hold messages for the consolidated database (HQ).

   The address 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.

6. Click OK to save the message type.