Use this statement to install an object that can be run in an external environment.

Syntax

INSTALL EXTERNAL OBJECT object-name 
[ update-mode ] 
FROM { FILE file-path | VALUE expression }
ENVIRONMENT environment-name

environment-name : 
PERL
| PHP

update-mode : 
NEW 
| UPDATE

Parameters

Remarks

For more information on external environments, see Overview of external environments.

Permissions

Must have DBA authority.

Side effects

None

See also

• Overview of external environments
• ALTER EXTERNAL ENVIRONMENT statement
• REMOVE EXTERNAL OBJECT statement
• START EXTERNAL ENVIRONMENT statement
• STOP EXTERNAL ENVIRONMENT statement
• SYSEXTERNENV system view
• SYSEXTERNENVOBJECT system view

Standards and compatibility

Examples

In this example, you install a Perl script that is located in a file into the database.

INSTALL EXTERNAL OBJECT 'PerlScript' 
NEW 
FROM FILE 'perlfile.pl'
ENVIRONMENT PERL;

Perl code also can be built and installed from an expression, as follows:

INSTALL EXTERNAL OBJECT 'PerlConsoleExample'
NEW
FROM VALUE 'sub WriteToServerConsole { print $sa_output_handle $_[0]; }'
ENVIRONMENT PERL;

Perl code also can be built and installed from a variable, as follows:

CREATE VARIABLE PerlVariable LONG VARCHAR;
SET PerlVariable = 
  'sub WriteToServerConsole { print $sa_output_handle $_[0]; }';

INSTALL EXTERNAL OBJECT 'PerlConsoleExample' 
NEW 
FROM VALUE PerlVariable
ENVIRONMENT PERL;