User's Manual

Chapter 4. Tutorials for Adaptive Server Anywhere Users
❖ 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” on page 214.
6. Click OK to save the message type.
Add the publisher and remote user to the database
In SQL Remote’s hierarchical replication system, each database may have
zero or one database immediately above it (the consolidated database) and
zero or more databases immediately below it (remote databases).
In this tutorial, the current database is the consolidated database of a
two-level system. It has no database above it, and only one remote database
below it.
The following diagram illustrates the two databases:
field
hq
Database: hq
Publisher: hq_user
Remote user: field_user
Database: field
Publisher: field_user
Consolidated user:
hq_user
35