Chapter 4. Tutorialsfor Adaptive Server Anywhere Users
❖Toadd 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
Propertiesfrom the popup menu.
5. Enter a publisher address to provide a return address for remote users.
Enterthe directory you have created to hold messages for the
consolidateddatabase (HQ).
Theaddress is taken relative to the SQLRemote environment variable or
registryentry. As you have not set this value, the address is taken relative
tothe directory from which the Message Agent is run. Youshould run the
MessageAgent from your tutorial directory for the addresses to be
interpretedproperly.
☞Forinformation about setting the SQLRemote value, see “Setting
messagetype control parameters” on page 214.
6. Click OK to save the message type.
Add the publisher and remote user to the database
InSQL Remote’s hierarchical replication system, each database may have
zeroor one database immediately above it (the consolidated database) and
zeroor more databases immediately below it (remote databases).
Inthis tutorial, the current database is the consolidated database of a
two-levelsystem. Ithas no database above it, and only one remote database
belowit.
Thefollowing 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