Use this statement to identify a message-link and return address for outgoing messages from a database.

Syntax

CREATE REMOTE MESSAGE TYPE message-system
[ ADDRESS address-string ]

message-system: 
FILE 
| FTP 
| SMTP

Parameters

Remarks

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 email system, the address string must be a valid email 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.

To remove the address, execute a CREATE REMOTE MESSAGE TYPE statement without an ADDRESS clause.

The Initialization utility (dbinit) 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.

Permissions

Must have DBA authority.

Side effects

Automatic commit.

See also

• GRANT PUBLISH statement [SQL Remote]
• GRANT REMOTE statement [SQL Remote]
• GRANT CONSOLIDATE statement [SQL Remote]
• DROP REMOTE MESSAGE TYPE statement [SQL Remote]
• SQL Remote message systems

Standards and compatibility

Example

When remote databases are extracted using the extraction utility, the following statement sets all recipients of file message-system messages to send messages back to the company subdirectory.

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

CREATE REMOTE MESSAGE TYPE file
ADDRESS 'company';