User's Manual

Chapter 18. Command Reference for Adaptive Server Enterprise

sp_remote_type procedure

Purpose To create or modify a SQL Remote message type.

Syntax sp_remote_type type_name publisher_address

Argument Description

type_name

The message type to create or alter. This must be one

of the following:

♦ ﬁle

♦ ftp

♦ smtp

♦ mapi

♦ vim

publisher_address

The address of the publisher under the speciﬁed

message type.

See also “sp_drop_remote_type procedure” on page 388

“ALTER REMOTE MESSAGE TYPE statement” on page 355

Description The Message Agent sends outgoing messages from a database using one of

the supported message links. Return messages for users employing the

speciﬁed link are sent to the speciﬁed 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 speciﬁed message system. If

it is an e-mail system, the address string must be a valid e-mail address. If it

is a ﬁle-sharing system, the address string is a subdirectory of the directory

set in the SQLREMOTE environment variable or registry entry, or of the

current directory if that is not set.

Example The following example creates a FILE message type for a database, and

gives the publisher’s address as a subdirectory of the SQLREMOTE location

named

publisher:

sp_remote_type file, publisher

427