Chapter 10. SQL Remote Administration

publisher address at a consolidated database is used by the database extraction utility as a return address when creating remote databases. It is also used by the Message Agent to identify where to look for incoming messages for the file system.

The address supplied with a message type definition is closely tied to the publisher ID of the database. Valid addresses are considered in following sections.

Before you can use a message system, you must set the publisher’s address.

Using Sybase Central to work with message types

You can create and alter message types in Sybase Central. Message types appear on the Message Types tab in the right pane when the SQL Remote Users folder is selected. This section applies only to Adaptive Server Anywhere databases.

You must have DBA authority to create and alter message types.

To add 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. The Message Type Creation wizard appears.

5.In the Message Type Creation wizard, enter a message type name. The name should correspond to a message-type DLL already installed in your Adaptive Server Anywhere directory. Click Next.

6.Enter a publisher address and click Finish to save the definition in the database.

If you wish to change the publisher’s address, you can do so by altering a message type. You cannot change the name of an existing message type; instead, you must delete it and create a new message type with the new name.

To alter 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

Page 229
Image 229
Sybase DC38133-01-0902-01 manual Using Sybase Central to work with message types, To add a message type Sybase Central