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

ALTER REMOTE MESSAGE TYPE statement

Function 

To change the publisher's address for a given message system, for a message type that has been created.

Syntax 

ALTER 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 

CREATE REMOTE MESSAGE TYPE statement

Description 

The statement changes the publisher's address for a given message type.

The Message Agent sends outgoing messages from a database by one of the supported message links. The extraction utility uses this address when executing the GRANT CONSOLIDATE statement in the remote database.

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 specified by 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 ALTER REMOTE MESSAGE TYPE statement also causes the Message Agent to look for incoming messages in the address given for each message type.

Example 

The following statement changes the publisher's address for the FILE message link to new_addr.

CREATE REMOTE MESSAGE TYPE file
ADDRESS 'new_addr'