Using commands to work with message types

To create a message type (SQL)

Make sure you have decided on an address for the publisher under the message type.
Execute a CREATE REMOTE MESSAGE TYPE command.

The CREATE REMOTE MESSAGE TYPE statement has the following syntax:
```
CREATE REMOTE MESSAGE TYPE type-name
ADDRESS address-string
```
where type-name is one of the message systems supported by SQL Remote, and address-string is the publisher's address under that message system.

If you want to change the publisher's address, you can do so by altering the message type.

To alter a message type (SQL)

Make sure you have decided on a new address for the publisher under the message type.
Execute an ALTER REMOTE MESSAGE TYPE statement.

The ALTER REMOTE MESSAGE TYPE statement has the following syntax:
```
ALTER REMOTE MESSAGE TYPE type-name
ADDRESS address-string
```
where 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)

Execute a DROP REMOTE MESSAGE TYPE statement.

The DROP REMOTE MESSAGE TYPE statement has the following syntax:
```
DROP REMOTE MESSAGE TYPE type-name
```
where type-name is one of the message systems supported by SQL Remote.

Using commands to work with message types

See also