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.
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
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 connect to the database. 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.
For more information about how to work with external environments, see Overview of external environments.
Must have DBA authority.
SQL/2003 Vendor extension.
The following example identifies a user with DBA authority that is used by the external environment to connect to the database server and the location of the Perl executable.
ALTER EXTERNAL ENVIRONMENT PERL USER DBADMIN LOCATION 'c:\\Perl64\\bin\\perl.exe';
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|