Chapter 10. SQL Remote Administration
publisheraddress at a consolidated database is used by the database
extractionutility as a return address when creating remote databases. Itis
alsoused by the Message Agent to identify where to look for incoming
messagesfor the filesystem.
Theaddress supplied with a message type definition is closely tied to the
publisherID of the database. Validaddresses are considered in following
sections.
Beforeyou can use a message system, you must set the publisher’s address.
Using Sybase Central to work with message types
Youcan create and alter message types in Sybase Central. Message types
appearon the Message Types tab in the right pane when the SQL Remote
Usersfolder is selected. Thissection applies only to Adaptive Server
Anywheredatabases.
Youmust have DBA authority to create and alter message types.
❖Toadd a message type (Sybase Central)
1. Connect to a database.
2. In the left pane, open the SQL Remote Users folder for that database.
3. In the right pane, click the Message Types tab.
4. From the File menu, choose New ➤Message Type.
TheMessage Type Creation wizard appears.
5. In the Message Type Creation wizard, enter a message type name. The
nameshould correspond to a message-type DLL already installed in your
AdaptiveServer Anywhere directory. Click Next.
6. Enter a publisher address and click Finish to save the definition in the
database.
Ifyou wish to change the publisher’s address, you can do so by altering a
messagetype. Youcannot change the name of an existing message type;
instead,you must delete it and create a new message type with the new
name.
❖Toalter a message type (Sybase Central)
1. In the left pane, open the SQL Remote Users folder for a database.
2. In the right pane, click the Message Types tab.
211