469,357 Members | 1,816 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,357 developers. It's quick & easy.

How to override the path for my UDF?

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(Arg1 CLOB(800),ParamString CLOB(800) ) returns varchar(800) cast from CLOB(800) specific sOptimMaskStr external name 'C:\IBM\InfoSphere\Optim\DP\bin\ioqdb2udf.11.3.dll !OptimMaskStr' 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\InfoSphere\Optim\DP\bin\ioqdb2udf.11.3.dll !OptimMaskStr' referring to my Windows machine or the database server?

How can I tell DB2 to read from my Windows machine?
Mar 18 '15 #1
0 1120

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Jeff Wagner | last post: by
7 posts views Thread by Dave Y | last post: by
3 posts views Thread by methodios | last post: by
reply views Thread by dba123 | last post: by
5 posts views Thread by Mike Krell | last post: by
5 posts views Thread by Sin Jeong-hun | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.