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.