SET REMOTE OPTION statement [SQL Remote]

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  
| smtp
link-option-name:
common-option 
| file-option 
| ftp-option 
| smtp-option
common-option:
debug 
| output_log_send_on_error
| output_log_send_limit 
| output_log_send_now
file-option:
directory 
| invalid_extensions 
| unlink_delay
ftp-option:
active_mode 
| host 
| invalid_extensions
| password 
| port 
| root_directory 
| user 
| reconnect_retries 
| reconnect_pause
smtp-option:
 local_host 
| pop3_host 
| pop3_password 
| pop3_userid
| smtp_host 
| top_supported
link-option-value : string
Parameters
Remarks

The Message Agent saves message link parameters when the user enters them in the message link window 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
Standards and compatibility
  • SQL/2003   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';

The following statement stops SQL Remote from using the specified file extensions for messages that are generated:

SET REMOTE ftp OPTION "Public"."invalid_extensions" =
'exe,pif,dll,bat,cmd,vbs';