ASA SQL Reference
  SQL Statements

SET REMOTE OPTION statement [SQL Remote]

Description 

Use this statement to set a message control parameter for a SQL Remote message link.

Syntax 

SET REMOTE link-name OPTION
[ userid.| PUBLIC.]link-option-name = link-option-value

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

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

common-option:
debug | output_log_send_on_error
| output_log_send_limit | output_log_send_now

file-option:
directory | unlink_delay

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

mapi-option:
 force_download | ipm_receive | ipm_send | profile

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

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

link-option-value:
string

Parameters 

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:

• The file message system.

• The ftp message system.

• The MAPI message system.

• The SMTP message system.

• The VIM message system.

Usage 

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 statement explicitly. This statement 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).

Permissions 

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

Side effects 

Automatic commit.

See also 

sp_link_option procedure

Troubleshooting errors at remote sites

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

Examples 

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

SET REMOTE FTP OPTION myuser.host = 'ftp.mycompany.com'