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

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
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 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.