I created a UDF function under the schema ICMADMIN named testselect, which has one integer as a paramerter and returns a CLOB(1M) object. However when I try to invoke this function from the control center, the following error occurs.
database manager error occurred. : [IBM][CLI Driver][DB2/NT]
SQL0390N The function "ICMADMIN.TESTSELECT1" resolved to
specific function "SQL030721103802700" that is not valid in the
context where it is used. SQLSTATE=42887
I have no idea which context I need to be using, since I thought I would have all the priviledges I needed if ICMADMIN created the function and it is being invoked on it's home machine. Any ideas?