ALTER EXTERNAL ENVIRONMENT statement

ALTER EXTERNAL ENVIRONMENT environment-name 
LOCATION location-string

environment-name : 
JAVA
| PERL
| PHP
| CLR
| C_ESQL32
| C_ESQL64
| C_ODBC32
| C_ODBC64
| DBMLSYNC

environment-name Use environment-name to specify the external environment you are altering.
LOCATION clause Use the LOCATION clause to specify the location on the database server computer where the executable/binary for the external environment can be found. It includes the executable/binary name. This path can either be fully qualified or relative. If the path is relative, then the executable/binary must be in a location where the server can find it.

The location of dbmlsync utility can be set using this statement. If, during synchronization, the dbmlsync executable image cannot be located using the database server's PATH environment variable, then use this statement to record the location of the executable.

You must have the MANAGE ANY EXTERNAL ENVIRONMENT system privilege.

None

SQL/2008 Vendor extension.

The following example specifies the location of the Perl executable for use when using Perl as an external environment.

ALTER EXTERNAL ENVIRONMENT PERL
LOCATION 'c:\\Perl64\\bin\\perl.exe';

ALTER EXTERNAL ENVIRONMENT statement

Syntax

Parameters

Remarks

Privileges

Side effects

See also

Standards and compatibility

Example