Choosing the Correct Execution Option | Teradata Vantage - 17.10 - Choosing the Correct 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)

Use the following table to choose the correct execution option for a UDF.

IF … THEN use …
you are in the UDF development phase and are debugging a function EXECUTE PROTECTED.
the function opens a file or uses another operating system resource that requires tracking by the operating system EXECUTE PROTECTED.

Running such a function in nonprotected mode could interfere with proper Vantage operation.

the function is a computational function that does not use any operating system resources EXECUTE NOT PROTECTED.

Running a UDF in nonprotected mode speeds up the processing of the function considerably.

Use this option only after thoroughly debugging the function and making sure it produces the correct output.