ALTER/DROP SCRIPT ENVIRONMENT

To drop a script environment:

Usage

DROP SCRIPT ENVIRONMENT script-env [CASCADE]

To remove a script environment:

DROP SCRIPT ENVIRONMENT script-env [CASCADE]

Notes

If a command to drop a script environment is submitted Kognitio will only complete the command if there are no dependent external scripts using the environment. This behaviour can be overwritten using the CASCADE option.

Warning

using CASCADE will result in all external scripts currently using the script environment also being dropped. This mirrors the behaviour of dropping a schema which contains tables and views. Note at present there is no option to INVALIDATE dependent external scripts.

To obtain a list of scripts dependent on a script environment use Kognitio console or submit the following SQL:

    SELECT s.name schema_name
    , aes.name script_name
    FROM sys.ipe_external_script aes
    JOIN sys.ipe_schema s
    ON aes.schema_id=s.id
    WHERE script_environment_id
    IN ( SELECT id
         FROM sys.ipe_script_environment
         WHERE name = 'PYTHON27'
)

The environment used here is ‘PYTHON27’ but this can be replaced by any script environment name on the system.