Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Remote » SQL Remote Administration » Using message types » Working with message types

Using Sybase Central to work with message types Next Page

Using commands to work with message types

To create a message type (SQL)

  1. Make sure you have decided on an address for the publisher under the message type.

  2. 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.

    3. If you want 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.

      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.

      3. 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)
    See also