troubleshooting Question

DB2 functions not working under Vista

Avatar of Peter_Dyk
Peter_Dyk asked on
4 Comments1 Solution1075 ViewsLast Modified:
We are in the process of moving our application from W2K and DB2 V8.2 to Windows Vista and DB2 Express C free V9.1.2.  Most of our DB2 processes and queries are working correctly except for when we attempt to use any functions contained in the db2clifn.dll file (e.g., ascii, chr, sqrt, etc.).  For example, the query

DB2 select sqrt(4) from user

where the table user has two rows in it.  It should return the value 2 twice, but instead generates the error:

SQL0444N  Routine "SYSFUN.SQRT" (specific name "SQRT") is implemented with
code in library or path "\db2clifn", function "CLI_udfSQRT" which cannot be
accessed.  Reason code: "4".  SQLSTATE=42724

I have checked that the db2clifn.dll file is located in a directory that is on our path variable and, in fact, we have several user-created functions in the same directory that work properly.  This is our first foray into Vista, so it is also possible that there is some security issue we are not aware of causing this.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros