Chapter 10. SQL Remote Administration
Ifyou wish to change the publisher’s address, you can do so by altering the
messagetype.
Toalter a message type (SQL)
1. Make sure you have decided on a new address for the publisher under the
messagetype.
2. Execute an ALTER REMOTE MESSAGE TYPE statement.
ForAdaptive Server Anywhere, the ALTER REMOTE MESSAGETYPE
statementhas the following syntax:
ALTERREMOTE MESSAGE TYPE type-name
ADDRESS address-string
ForAdaptive Server Enterprise, use the sp_remote_type procedure in the
sameway as creating a message type. Thisprocedure takes the following
arguments:
sp_remote_type type-name,address-string
Inthese statements,
type-name
isone of the message systems supported
bySQL Remote, and
address-string
isthe publisher’s address under that
messagesystem.
Youcan also drop message types if they are no longer used in your
installation. This has the effect of removing the publisher’saddress from the
definition.
Todrop a message type (SQL)
1. Execute a DROP REMOTE MESSAGE TYPE statement.
ForAdaptive Server Anywhere, the DROP REMOTE MESSAGE TYPE
statementhas the following syntax:
DROPREMOTE MESSAGE TYPE type-name
ForAdaptive Server Enterprise, use the sp_drop_remote_type
procedurein the same way as creating a message type. Thisprocedure
takesthe following arguments:
sp_drop_remote_typetype-name
Inthese statements,
type-name
isone of the message systems supported
bySQL Remote.
Seealso
“CREATEREMOTE MESSAGE TYPE statement” on page 357
213