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.