Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Specifies the location of an external environment such as Java, PHP, or Perl.
ALTER EXTERNAL ENVIRONMENT environment-name LOCATION location-string
environment-name : C_ESQL32 | C_ESQL64 | C_ODBC32 | C_ODBC64 | CLR | DBMLSYNC | JAVA | JS | PERL | PHP
Use environment-name to specify the external environment you are altering.
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.
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.
You must have the MANAGE ANY EXTERNAL ENVIRONMENT system privilege.
Not in the standard.
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';