Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 17. Command Reference for Adaptive Server Anywhere       

CREATE REMOTE MESSAGE TYPE statement

Function 

To identify a message-link and return address for outgoing messages from a database.

Syntax 

CREATE REMOTE MESSAGE TYPE message-system
...ADDRESS address-string

Parameters 

Parameter	Description
message-system	One of the message systems supported by SQL Remote. It must be one of the following values: FILE FTP MAPI SMTP VIM
address-string	A string containing a valid address for the specified message system.

Permissions 

Must have DBA authority.

Side effects 

Automatic commit.

See also 

GRANT PUBLISH statement

GRANT REMOTE statement

GRANT CONSOLIDATE statement

Using message types

Description 

The Message Agent sends outgoing messages from a database using one of the supported message links. Return messages for users employing the specified link are sent to the specified address as long as the remote database is created by the extraction utility. The Message Agent starts links only if it has remote users for those links.

The address is the publisher's address under the specified message system. If it is an e-mail system, the address string must be a valid e-mail address. If it is a file-sharing system, the address string is a subdirectory of the directory set in the SQLREMOTE environment variable, or of the current directory if that is not set. You can override this setting on the GRANT CONSOLIDATE statement at the remote database.

For the FILE link, the CREATE REMOTE MESSAGE TYPE statement also causes the Message Agent to look for incoming messages in the address given for each message type.

The initialization utility creates message types automatically, without an address. Unlike other CREATE statements, the CREATE REMOTE MESSAGE TYPE statement does not give an error if the type exists; instead it alters the type.

Example 

• When remote databases are extracted using the extraction utility, the following statement sets all recipients of FILE messages to send messages back to the company subdirectory of the SQLREMOTE environment variable.

  The statement also instructs DBREMOTE to look in the company subdirectory for incoming messages.

  CREATE REMOTE MESSAGE TYPE file
  ADDRESS 'company'