ALTER EXTERNAL ENVIRONMENT statement

Use this statement to specify the location of an external environment such as JAVA, PHP, or Perl, or to specify a user with DBA authority to be used by the external environment for connecting to the database.

Syntax
ALTER EXTERNAL ENVIRONMENT environment-name 
    [ USER user-name ]
    [ LOCATION location-string ]
environment-name : 
JAVA
| PERL
| PHP
| CLR
| C_ESQL32
| C_ESQL64
| C_ODBC32
| C_ODBC64
Parameters
  • environment-name   Use environment-name to specify the external environment you are altering.

  • USER clause   Use the USER clause to specify the name of a user in the database that has DBA authority. When the external environment is initially launched, it must make a connection back to the database to set things up for the external environment's usage. By default, this connection is made using the DBA user ID, but if the database administrator prefers to have the external environment use a different user ID with DBA authority, use user-name to indicate the user.

  • 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.

Remarks

For more information on how to work with external environments, see Overview of external environments.

Permissions

Must have DBA authority.

Side effects

None

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

In this example, you identify a user with DBA authority that is to be used by the external environment to connect to the database server, as well as the location of the Perl executable.

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