Release Notes

40.2 Precaution for registering C/C++ routines (UDFs, stored procedures, or methods) on Windows

When registering a C or C++ routine (UDF, stored procedure, or method) on Windows^(R) operating systems, take the following precaution when identifying a routine body in the CREATE statement's EXTERNAL NAME clause. If you use an absolute path id to identify the routine body, you must append the .dll extension. For example:

CREATE PROCEDURE getSalary( IN inParm INT, OUT outParm INT )
  LANGUAGE c
  PARAMETER STYLE sql 
  DYNAMIC RESULT SETS 1
  FENCED THREADSAFE
  RETURNS NULL ON NULL INPUT
  EXTERNAL NAME 'd:\mylib\myfunc.dll'