Contents Index sp_grant_remote procedure sp_modify_article procedure

SQL Remote User's Guide
  Command Reference for Adaptive Server Enterprise

sp_link_option procedure


Purpose 

To set a message control parameter for a SQL Remote message link.

Syntax 

sp_link_option link-name,
userid,
option-name,
option-value

Parameters 

link-name:
file | ftp | mapi | smtp | vim

link-option-name:
file-option | ftp-option | mapi-option | smtp-option | vim-option

file-option:
debug | directory | unlink_delay

ftp-option:
active_mode | debug | host 
password | port | root_directory | user

mapi-option:
debug | force_download 
ipm_receive | ipm_send | profile

smtp-option:
debug | local_host | pop3_host | pop3_password 
pop3_userid | smtp_host | top_supported

vim-option:
debug | password | path | receive_all 
send_vim_mail | userid

link-option-value:
string

Permissions 

Must have DBA authority. The publisher can set their own options.

Side effects 

Automatic commit.

See also 

SET REMOTE OPTION statement

Description 

The Message Agent saves message link parameters when the user enters them in the message link dialog box when the message link is first used. In this case, it is not necessary to use this procedure explicitly. This procedure is most useful when preparing a consolidated database for extracting many databases.

The option names are case sensitive. The case sensitivity of option values depends on the option: boolean values are case insensitive, while the case sensitivity of passwords, directory names, and other strings depend on the cases sensitivity of the file system (for directory names), or the database (for user IDs and passwords).

userid    If no userid is specified, then the current publisher is assumed.

Option values    The option values are message-link dependent. For more information, see the following locations:

Example 

The following statement sets the FTP host to ftp.mycompany.com for the ftp link for user myuser:

exec sp_link_option ftp, myuser,
   host, 'ftp.mycompany.com'

Contents Index sp_grant_remote procedure sp_modify_article procedure