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. |