Choosing the Correct Execution Option | Teradata Vantage - Choosing the Correct Execution Option - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
rin1593638965306.ditamap
dita:ditavalPath
rin1593638965306.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

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.