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

environment-name : 
PERL
| PHP

update-mode : 
NEW 
| UPDATE

For more information about external environments, see SQL Anywhere external environment support.

DBA authority

None

• SQL Anywhere external environment support
• ALTER EXTERNAL ENVIRONMENT statement
• REMOVE EXTERNAL OBJECT statement
• START EXTERNAL ENVIRONMENT statement
• STOP EXTERNAL ENVIRONMENT statement
• SYSEXTERNENV system view
• SYSEXTERNENVOBJECT system view

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;