Name   Shows the name of the external environment or language.

Type   Shows the type of object.

Scope   Shows whether the external environment is launched as Connection (one per connection) or Database (one per database).

Supports result sets   Specifies whether the external environment can return result sets to the user. This option applies only to Perl and PHP.

Location   Specifies the directory on the database server computer where the executable/binary for the external environment can be found. Include the executable/binary name in the path. 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 database server can find it.

User   Specifies the database user that has DBA authority. This user account is used to establish the connection to the database when the external environment is initially launched. The default is DBA.

Comment   Provides a place for you to type a text description of the external environment variable.

Test Configuration   Click Test Configuration to determine if the external environment is configured correctly. This button applies to Java, Perl and PHP.