Modifying MLE Environments

Existing MLE environments can be modified using the ALTER MLE ENV command.

It is possible to modify language options and the imports clause.

Altering Language Options

You can modify language options provided to an MLE module.

Use the ALTER MLE ENV clause to modify language options, as shown in the following snippet:

ALTER MLE ENV MyEnvOpt
    SET LANGUAGE OPTIONS 'js.strict=false';

Modifying Module Imports

In the context of MLE module imports, the ALTER MLE ENV command allows you to add additional imports as well as modify and drop existing imports.

Imports not specified during an environment’s creation can be added to existing MLE environments using the ADD IMPORTS clause. Import names, once defined, are static and must be dropped before they can be added as desired. Assuming you have run a new CREATE MLE DDL to replace IMPORT_EXAMPLE_MODULE from Example: Creating a JavaScript Module in the Database with the module name IMPORT_EXAMPLE_MODULE_V2, the following statement will run successfully:

ALTER MLE ENV po_env
ADD IMPORTS (
    'import_example' MODULE IMPORT_EXAMPLE_MODULE_V2
);

Any imports no longer needed can be dropped using the DROP IMPORTS clause:

ALTER MLE ENV po_env DROP IMPORTS('import_example');

The case of the import identifier must match that in the data dictionary’s USER_MLE_ENV_IMPORTS view.