Execute UDFs in the CLR, ESQL and ODBC, Java, Perl, or PHP external environments.
Prerequisites
There are no licensing prerequisites. The external runtime environments do not require the IQ_IDA license. The external runtime environments do not require the
a_v3_extfn or
a_v4_extfn APIs.
Task- Set up the external environment to be used on the database server.
ALTER EXTERNAL ENVIRONMENT environment-name
[ LOCATION location-string ]
- Install external objects (CLR, ESQL and ODBC, Java, Perl, or PHP) into the database.
- Use CREATE PROCEDURE and CREATE FUNCTION statements to create stored procedures and functions that make use of these objects within the external environment.
- Reference the stored procedure or function. Reference stored procedures in the FROM clause of your query.