Executing memberfunction in udf

[JB]

After searching a lot on the ibmsite and googling a lot, i still dont
know how to execute a memberfunction in an udf.

Example:
-----------A.h --------------
class A
{
public:
void run();
}

------------udf.c------------
#include "sqludf.h"
#include "A.h"

SQL_API_RC SQL_API_FN run ( SQLUDF_VARCHAR* out,
SQLUDF_NULLIND* outnul,
SQLUDF_TRAIL_ARGS )
{
A a;
a.run();
strcpy(out,"done");
}

----------------------------
After bldrtn and

create function run () returns varchar(80)
external name 'udf!run'
language C
parameter style SQL
;

I get the error running[select run() from R]:

SQL0444N Routine "BEN.RUN" (specific name "SQL040526125305300") is
implemented with code in library or path ".../sqllib/function/A",
function
"run" which cannot be accessed. Reason code: "6". SQLSTATE=42724.

Paul Cowell

[Knut Stolze]

JB wrote:

After searching a lot on the ibmsite and googling a lot, i still dont
know how to execute a memberfunction in an udf.

Example:
-----------A.h --------------
class A
{
public:
void run();
}

------------udf.c------------
#include "sqludf.h"
#include "A.h"

You need this here as well:

extern "C" SQL_API_RC SQL_API_FN run ( SQLUDF_VARCHAR* out,
The return type for UDFs needs to be "void".
SQLUDF_NULLIND* outnul,
SQLUDF_TRAIL_ARGS )
{
A a;
a.run();
strcpy(out,"done");
}

----------------------------
After bldrtn and

create function run () returns varchar(80)
external name 'udf!run'
language C
parameter style SQL
;

I get the error running[select run() from R]:

SQL0444N Routine "BEN.RUN" (specific name "SQL040526125305300") is
implemented with code in library or path ".../sqllib/function/A",
function
"run" which cannot be accessed. Reason code: "6". SQLSTATE=42724.

I think that your problem is that the function named "run" was not exported
as C symbol, so your compiler used C++ name mangling. But DB2 requires the
C name mangling and, thus, it did look for the symbol "run" and couldn't
find it. The above mentioned 'extern "C"' should fix your problem.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[Paul Cowell]

> I think that your problem is that the function named "run" was not exported

as C symbol, so your compiler used C++ name mangling. But DB2 requires the
C name mangling and, thus, it did look for the symbol "run" and couldn't
find it. The above mentioned 'extern "C"' should fix your problem.

I did all this, but still the same error...
The class A that I include in the udf.c came from [>db2 prep a.sqC]...

[Knut Stolze]

Paul Cowell wrote:

I think that your problem is that the function named "run" was not
exported
as C symbol, so your compiler used C++ name mangling. But DB2 requires
the C name mangling and, thus, it did look for the symbol "run" and
couldn't
find it. The above mentioned 'extern "C"' should fix your problem.

I did all this, but still the same error...
The class A that I include in the udf.c came from [>db2 prep a.sqC]...

I already answered your question that you sent by email. I suspect there is
just a minor issue that you need to find and fix. The detailed steps I
provided should help you with that.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena