Sybase SQL Remote DC38133-01-0902-01 User 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
userid ,
option-name,
option-value
Parameters
link-name:
file | ftp | mapi | smtp | vim
file | ftp | mapi | smtp | vim
link-option-name:
file-option | ftp-option | mapi-option | smtp-option | vim-option
file-option | ftp-option | mapi-option | smtp-option | vim-option
file-option:
debug | directory | unlink_delay
debug | directory | unlink_delay
ftp-option:
active_mode | debug | host
| password | port | root_directory | user
active_mode | debug | host
| password | port | root_directory | user
mapi-option:
debug | force_download
| ipm_receive | ipm_send | profile
debug | force_download
| ipm_receive | ipm_send | profile
smtp-option:
debug | local_host | pop3_host | pop3_password
| pop3_userid | smtp_host | top_supported
debug | local_host | pop3_host | pop3_password
| pop3_userid | smtp_host | top_supported
vim-option:
debug | password | path | receive_all
| send_vim_mail | userid
debug | password | path | receive_all
| send_vim_mail | userid
link-option-value:
string
string
Permissions
Must have DBA authority. The publisher can set their own options.
Side effects
Automatic commit.
See also
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.
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
depends on the option: boolean values are case insensitive, while the case
396