Accroding to IQ' udf guide,
create udf procedure as below:
Declare the UDF to the server by using the CREATE FUNCTION or CREATE AGGREGATE FUNCTION
Write the UDF library identification function
Define the UDF as a set of C or C++ functions.
Implement the function entry points in C/C++.
- Compile the UDF functions and the library identification functions
- Link the compiled file into a dynamically linkable library.
After I alreary done the all procedure, and Declare CREATE FUNCTION in Interactice SQL, I call function and got error response as below:
`
Could not execute statement.
Could not find 'my_sample_function' in dynamic library 'libudfex.so' SQLCODE=-621, ODBC 3 State="HY000" Line 1, column 1 SELECT my_sample_function(test.a, test.b) as aaa FROM test WHERE test.a = 3
`