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 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.
For more information on how to work with external environments, see Overview of external environments.
Must have DBA authority.
SQL/2003 Vendor extension.
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';
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|