I want to change the execution mode of the function to unprotected. I understand that I can use the alter statement as ALTER FUNCTION <funcitonname> EXECUTION NOT PROTECTED.
but how do I find out what is the actual mode of the function. I am not able to view the execution mode when I do a show function.
Yeah.. I got it. Thanks Dieter.
Do you think running functions in unprotected mode will have a huge performance impact for udf's like isdate?
For simple C-functions protected mode might be 5 to 10 times slower & uses much more CPU than Unprotected.
Whenever you CREATE or REPLACE a C-UDF it's created in protected mode, you need to
ALTER FUNCTION my_C-UDF EXECUTE NOT PROTECTED;
Hi Dieter ,
Thanks for the reply. That means We cannot create/replace a UDF in unprotected mode. Right??
Also, Can we change the execution mode of a SQLUDF to unprotected or it is restricted to an External UDF only.
When i am trying to alter the execution mode of SQLUDF I am getting is error "Operation not allowed on SQLUDF"