User's Manual

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” on page 374
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
396