ALTER EXTERNAL ENVIRONMENT statement

Specifies the location of an external environment such as Java, PHP, or Perl.

Syntax

ALTER EXTERNAL ENVIRONMENT environment-name 
LOCATION location-string

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

Parameters

environment-name
Use environment-name to specify the external environment you are altering.
location-string
Use location-string 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.

Remarks

In general, the ALTER EXTERNAL ENVIRONMENT statement is used to help the database server locate an external environment module when it cannot be located using standard search techniques (such as searching the software install location, system PATH, etc.).

CLR The LOCATION string is used to identify both the location and version of the CLR external environment support module. For example, dbextclr[VER_MAJOR]_v4.5 indicates that support for .NET 4.x is required. In this example, the file path is not specified so the database server will locate the module using standard search techniques. The dbextclr[VER_MAJOR] module supports .NET 2 and 3.5. The dbextclr[VER_MAJOR]_v4.5 module supports .NET 4.x. For portability to newer versions of the software, use [VER_MAJOR] in the LOCATION string rather than the current software release version number. The database server will replace [VER_MAJOR] with the appropriate version number.

DBMLSYNC In cases where there are multiple versions of the database server software installed on the same system, or if the dbmlsync executable is not located in the same directory as the database server and cannot be found in the PATH environment variable, use the ALTER EXTERNAL ENVIRONMENT command to specify the location of the dbmlsync executable.

Privileges

You must have the MANAGE ANY EXTERNAL ENVIRONMENT system privilege.

Side effects

None

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

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';