Choosing the Correct Execution Option for a C/C++ UDF | Teradata Vantage - Choosing the Correct Execution Option for a C/C++ UDF - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-03-30
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
qnu1472247494689
lifecycle
latest
Product Category
Teradata Vantageā„¢

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

Situation Run Option
You are in the UDF development phase and are debugging a function. EXECUTE PROTECTED.
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.

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 debugging the function.