Protected Mode Execution Option | Teradata Vantage - 17.10 - Protected Mode Execution Option - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

The ALTER FUNCTION statement provides an option that controls whether Vantage invokes the function directly or runs the function indirectly as a separate process.

The option applies to functions that were created without specifying the EXTERNAL SECURITY clause in the CREATE FUNCTION or REPLACE FUNCTION statement. Functions that specify the EXTERNAL SECURITY clause are executed using separate secure server processes.

IF ALTER FUNCTION specifies … THEN Vantage
EXECUTE PROTECTED runs the function indirectly as a separate process.

If the function fails during execution, the transaction fails.

EXECUTE NOT PROTECTED invokes the function directly.

If you subsequently use REPLACE FUNCTION to replace the function, the execution mode reverts back to protected mode.

If the ALTER FUNCTION statement specifies EXECUTE NOT PROTECTED, and the function fails during execution, the database software will probably restart.

Only an administrator, or someone with sufficient privileges, can use the ALTER FUNCTION statement.