User's Manual

Chapter 10. SQL Remote Administration
If you wish to change the publisher’s address, you can do so by altering the
message type.
❖ To alter a message type (SQL)
1. Make sure you have decided on a new address for the publisher under the
message type.
2. Execute an ALTER REMOTE MESSAGE TYPE statement.
For Adaptive Server Anywhere, the ALTER REMOTE MESSAGE TYPE
statement has the following syntax:
ALTER REMOTE MESSAGE TYPE type-name
ADDRESS address-string
For Adaptive Server Enterprise, use the sp_remote_type procedure in the
same way as creating a message type. This procedure takes the following
arguments:
sp_remote_type type-name, address-string
In these statements, type-name is one of the message systems supported
by SQL Remote, and address-string is the publisher’s address under that
message system.
You can also drop message types if they are no longer used in your
installation. This has the effect of removing the publisher’s address from the
definition.
❖ To drop a message type (SQL)
1. Execute a DROP REMOTE MESSAGE TYPE statement.
For Adaptive Server Anywhere, the DROP REMOTE MESSAGE TYPE
statement has the following syntax:
DROP REMOTE MESSAGE TYPE type-name
For Adaptive Server Enterprise, use the sp_drop_remote_type
procedure in the same way as creating a message type. This procedure
takes the following arguments:
sp_drop_remote_type type-name
In these statements, type-name is one of the message systems supported
by SQL Remote.
☞ See also
♦ “CREATE REMOTE MESSAGE TYPE statement” on page 357
213