16.20 - Choosing the Correct Execution Option - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
Content Type
Programming Reference
Publication ID
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 the proper operation of Teradata Database.

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.