Sybase DC38133-01-0902-01 manual To alter a message type SQL, To drop a message type SQL, 213

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-nameADDRESS 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-nameis one of the message systems supported by SQL Remote, and address-stringis 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-nameis one of the message systems supported by SQL Remote.

☞See also

♦“CREATE REMOTE MESSAGE TYPE statement” on page 357

213