Data Replication with SQL Remote
PART 4. Reference
CHAPTER 18. Command Reference for Adaptive Server Enterprise
To create or modify a SQL Remote message type.
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:
|
publisher_address |
The address of the publisher under the specified message type. |
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 registry entry, or of the current directory if that is not set.
For the FILE link, the procedure also causes the Message Agent to look for incoming messages in the address given for each message type.
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 go