I need to use a DB2 UDF provided by IBM.
I am only using DB2 client for Windows, and I have copied all the UDF related files into my Windows machine.
I was able to run this command:
Create function OptimMaskStr(Ar g1 CLOB(800),Param String CLOB(800) ) returns varchar(800) cast from CLOB(800) specific sOptimMaskStr external name 'C:\IBM\InfoSph ere\Optim\DP\bi n\ioqdb2udf.11. 3.dll!OptimMask Str' Language C parameter style SQL not deterministic fenced threadsafe called on null input no sql external action scratchpad 100 final call dbinfo allow parallel;
However, when I test the UDF, it cannot locate this UDF.
Error SQL0444N
Reason code: "4". SQLSTATE=42724
Is the external name 'C:\IBM\InfoSph ere\Optim\DP\bi n\ioqdb2udf.11. 3.dll!OptimMask Str' referring to my Windows machine or the database server?
How can I tell DB2 to read from my Windows machine?
I am only using DB2 client for Windows, and I have copied all the UDF related files into my Windows machine.
I was able to run this command:
Create function OptimMaskStr(Ar g1 CLOB(800),Param String CLOB(800) ) returns varchar(800) cast from CLOB(800) specific sOptimMaskStr external name 'C:\IBM\InfoSph ere\Optim\DP\bi n\ioqdb2udf.11. 3.dll!OptimMask Str' Language C parameter style SQL not deterministic fenced threadsafe called on null input no sql external action scratchpad 100 final call dbinfo allow parallel;
However, when I test the UDF, it cannot locate this UDF.
Error SQL0444N
Reason code: "4". SQLSTATE=42724
Is the external name 'C:\IBM\InfoSph ere\Optim\DP\bi n\ioqdb2udf.11. 3.dll!OptimMask Str' referring to my Windows machine or the database server?
How can I tell DB2 to read from my Windows machine?