473,594 Members | 2,806 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem with a UDF

Hello,

I've been going through the DB2 application development manuals and
have no idea what I'm doing wrong with my UDF.

Basically, I created a C++ library that compares 2 strings and returns
their similarity as a double. I wanted to use this function inside DB2
so I created the following code:

similarity.cpp ---
#include "mcwpa.h"
#include <sqludf.h>

extern "C"
SQL_API_RC SQL_API_FN similarity ( SQLUDF_VARCHAR *in1,
SQLUDF_VARCHAR *in2,
SQLUDF_DOUBLE *sim,
SQLUDF_NULLIND *in1NullInd,
SQLUDF_NULLIND *in2NullInd,
SQLUDF_NULLIND *simNullInd,
SQLUDF_TRAIL_AR GS )
{
MCWPA algorithm(in1, in2);

*sim = algorithm.sim() ;

return 0;
}
--- end similarity.cpp

I compiled this into a shared object called libdb2_sim.so:

command output ---
truth@tiamat2:~/mcwpa/src> nm libdb2_sim.so
000042c0 d DW.ref.__gxx_pe rsonality_v0
0000480c A _DYNAMIC
00004904 A _GLOBAL_OFFSET_ TABLE_
00002b8c t _GLOBAL__I__ZN5 MCWPAC2EPKcS1_
w _Jv_RegisterCla sses
U _Unwind_Resume@ @GCC_3.0
00002b0e t _Z41__static_in itialization_an d_destruction_0 ii
0000284c T _ZN5MCWPA3simEv
00001c52 T _ZN5MCWPAC1EPKc S1_
0000239a T _ZN5MCWPAC1EPKc S1_b
000019bc T _ZN5MCWPAC2EPKc S1_
00001ee8 T _ZN5MCWPAC2EPKc S1_b
00001970 W _ZN5MCWPAD1Ev
00002e8c T _ZN6Window12n_a ccessibleEv
00002f0a T _ZN6Window4mark Ev
00002f60 T _ZN6Window4next Ev
00002e80 T _ZN6Window4size Ev
00002ed8 T _ZN6Window7patt ernEv
00002d52 T _ZN6WindowC1ESs
00002c24 T _ZN6WindowC2ESs
00002bec W _ZN9__gnu_cxx17 __normal_iterat orIPcSsEC1ERKS1 _
00002ba6 W _ZN9__gnu_cxx17 __normal_iterat orIPcSsEppEi
00002be2 W _ZNK9__gnu_cxx1 7__normal_itera torIPcSsEdeEv
U _ZNKSs4findEPKc j@@GLIBCPP_3.2
U _ZNKSs4findERKS sj@@GLIBCPP_3.2
U _ZNKSs4findEcj@ @GLIBCPP_3.2
U _ZNKSs4sizeEv@@ GLIBCPP_3.2
U _ZNKSs6lengthEv @@GLIBCPP_3.2
U _ZNKSs6substrEj j@@GLIBCPP_3.2
U _ZNSaIcEC1Ev@@G LIBCPP_3.2
U _ZNSaIcED1Ev@@G LIBCPP_3.2
U _ZNSolsEPFRSoS_ E@@GLIBCPP_3.2
U _ZNSolsEi@@GLIB CPP_3.2
U _ZNSolsEj@@GLIB CPP_3.2
U _ZNSs5beginEv@@ GLIBCPP_3.2
U _ZNSs5eraseEjj@ @GLIBCPP_3.2
U _ZNSs7replaceEj jPKc@@GLIBCPP_3 .2
U _ZNSs7replaceEj jRKSsjj@@GLIBCP P_3.2
U _ZNSsC1EPKcRKSa IcE@@GLIBCPP_3. 2
U _ZNSsC1ERKSs@@G LIBCPP_3.2
U _ZNSsC1Ev@@GLIB CPP_3.2
U _ZNSsD1Ev@@GLIB CPP_3.2
U _ZNSsaSEPKc@@GL IBCPP_3.2
U _ZNSsaSERKSs@@G LIBCPP_3.2
U _ZNSsaSEc@@GLIB CPP_3.2
U _ZNSspLEc@@GLIB CPP_3.2
00003210 V _ZNSt15basic_st reambufIcSt11ch ar_traitsIcEE13 _S_pback_sizeE
00003214 V _ZNSt15basic_st reambufIwSt11ch ar_traitsIwEE13 _S_pback_sizeE
U _ZNSt8ios_base4 InitC1Ev@@GLIBC PP_3.2
U _ZNSt8ios_base4 InitD1Ev@@GLIBC PP_3.2
00002c1c W _ZNSt8iteratorI St26random_acce ss_iterator_tag ciPcRcEC2Ev
U _ZSt4cout@@GLIB CPP_3.2
U
_ZSt4endlIcSt11 char_traitsIcEE RSt13basic_ostr eamIT_T0_ES6_@@ GLIBCPP_3.2
000049f8 b _ZSt8__ioinit
U
_ZStlsISt11char _traitsIcEERSt1 3basic_ostreamI cT_ES5_PKc@@GLI BCPP_3.2
U _ZdlPv@@GLIBCPP _3.2
U _Znwj@@GLIBCPP_ 3.2
000048f4 d __CTOR_END__
000048ec d __CTOR_LIST__
000048fc d __DTOR_END__
000048f8 d __DTOR_LIST__
00004660 r __FRAME_END__
00004900 d __JCR_END__
00004900 d __JCR_LIST__
000049f4 A __bss_start
U __cxa_atexit@@G LIBC_2.1.3
U __cxa_begin_cat ch@@CXXABI_1.2
U __cxa_end_catch @@CXXABI_1.2
w __cxa_finalize@ @GLIBC_2.1.3
000031b0 t __do_global_cto rs_aux
000016b0 t __do_global_dto rs_aux
000042b8 d __dso_handle
w __gmon_start__
U __gxx_personali ty_v0@@CXXABI_1 .2
00002b62 t __tcf_0
000049f4 A _edata
000049fc A _end
000031e4 T _fini
00001320 T _init
00001680 t call_gmon_start
000049f4 b completed.1
00001720 t frame_dummy
000042bc d p.0
U pow@@GLIBC_2.0
000017ea T similarity
U sqrt@@GLIBC_2.0
U strlen@@GLIBC_2 .0
U toupper@@GLIBC_ 2.0
--- end command output

I have a DB2 instance running at /u01/mercuryd, and placed the file in
that directory. My fenced user "mdfenc" has read access to this
directory. I also created a symlink:

lrwxrwxrwx 1 mercuryd merciadm 27 2005-08-19 15:02
/u01/mercuryd/sqllib/function/libdb2_sim -> /u01/mercuryd/libdb2_sim.so

I then registered my UDF with the following command:
db2 "create function similarity (v1 VARCHAR(255), v2 VARCHAR(255))
returns DOUBLE EXTERNAL NAME 'libdb2_sim!sim ilarity' LANGUAGE C
PARAMETER STYLE SQL DETERMINISTIC FENCED THREADSAFE RETURNS NULL ON
NULL INPUT NO SQL "
DB20000I The SQL command completed successfully.
Now my problem. Executing this SQL results in error, and I don't know
why:
truth@tiamat2:~/mcwpa/src> db2 "select clients.clinum,
clients.cliname 1, ofac.name, similarity(varc har(clients.cli name1, 255),
varchar(ofac.na me,255)) as sim from clients, ofac"
SQL0440N No authorized routine named "SIMILARITY " of type "FUNCTION"
having
compatible arguments was found. SQLSTATE=42884

truth@tiamat2:~/mcwpa/src> db2 describe table clients

Column Type Type
name schema name Length
Scale Nulls
------------------------------ --------- ------------------ --------
----- ------
CLINUM SYSIBM CHARACTER 12
0 Yes
CLIREPNUM SYSIBM CHARACTER 10
0 Yes
CLINAME1 SYSIBM CHARACTER 30
0 Yes
....

truth@tiamat2:~/mcwpa/src> db2 describe table ofac

Column Type Type
name schema name Length
Scale Nulls
------------------------------ --------- ------------------ --------
----- ------
ID SYSIBM BIGINT 8
0 No
NAME SYSIBM VARCHAR 255
0 No
....

I've also tried the SQL without converting the types to VARCHAR (the
manual stated that everything would be promoted to VARCHAR
automatically) with the same results.

Does anybody know what is happening?

Thanks,

Tom

Nov 12 '05 #1
1 2010
Snick wrote:
Hello,

I've been going through the DB2 application development manuals and
have no idea what I'm doing wrong with my UDF.

Basically, I created a C++ library that compares 2 strings and returns
their similarity as a double. I wanted to use this function inside DB2
so I created the following code:

similarity.cpp ---
#include "mcwpa.h"
#include <sqludf.h>

extern "C"
SQL_API_RC SQL_API_FN similarity ( SQLUDF_VARCHAR *in1,
SQLUDF_VARCHAR *in2,
SQLUDF_DOUBLE *sim,
SQLUDF_NULLIND *in1NullInd,
SQLUDF_NULLIND *in2NullInd,
SQLUDF_NULLIND *simNullInd,
SQLUDF_TRAIL_AR GS )
{
MCWPA algorithm(in1, in2);
You don't handle errors here, do you?
*sim = algorithm.sim() ;
You also might want to set the output null indicator here:

*simNullInd = 0;
return 0;
}
--- end similarity.cpp

I compiled this into a shared object called libdb2_sim.so:

command output ---
truth@tiamat2:~/mcwpa/src> nm libdb2_sim.so [...] --- end command output

I have a DB2 instance running at /u01/mercuryd, and placed the file in
that directory. My fenced user "mdfenc" has read access to this
directory. I also created a symlink:

lrwxrwxrwx 1 mercuryd merciadm 27 2005-08-19 15:02
/u01/mercuryd/sqllib/function/libdb2_sim -> /u01/mercuryd/libdb2_sim.so
So the lib is accessible from the sqllib/function/ directory - that's good.
I then registered my UDF with the following command:
db2 "create function similarity (v1 VARCHAR(255), v2 VARCHAR(255))
returns DOUBLE EXTERNAL NAME 'libdb2_sim!sim ilarity' LANGUAGE C
PARAMETER STYLE SQL DETERMINISTIC FENCED THREADSAFE RETURNS NULL ON
NULL INPUT NO SQL "
DB20000I The SQL command completed successfully.
Now my problem. Executing this SQL results in error, and I don't know
why:
truth@tiamat2:~/mcwpa/src> db2 "select clients.clinum,
clients.cliname 1, ofac.name, similarity(varc har(clients.cli name1, 255),
varchar(ofac.na me,255)) as sim from clients, ofac"
SQL0440N No authorized routine named "SIMILARITY " of type "FUNCTION"
having
compatible arguments was found. SQLSTATE=42884
Do you execute the SELECT statement as the same user who also run the CREATE
FUNCTION statement? I have some doubts there because you said your
instance is named "mercuryd" and the user running the SELECT is named
"truth".

You have to remember that each object in DB2 (tables, triggers, procedures,
functions, ...) is always in a schema. (A schema is something like a
namespace.) Once you connected to a database, you can query the CURRENT
SCHEMA special register to see what the current schema will be for objects
that are created without an explicit schema name. So you might want to
check the schema name of your function:

SELECT routineschema FROM syscat.routines WHERE routinename = 'SIMILARITY'

Once you know that, you can either qualify your function name in the SELECT
statement with the schema name:

SELECT clients.clinum, clients.cliname 1, ofac.name,
<schema>.simila rity(clients.cl iname1, ofac.name) AS sim
FROM clients, ofac

or you set the list of schemas that will be searched by DB2 to find an
appropriate function. Then you can call the function by its unqualified
name. This list is in the CURRENT FUNCTION PATH special register:

SET CURRENT FUNCTION PATH = CURRENT FUNCTION PATH, <schema>

SELECT clients.clinum, clients.cliname 1, ofac.name,
similarity(clie nts.cliname1, ofac.name) AS sim
FROM clients, ofac

Personally, I always prefer the first appreach because it avoids
misunderstandin gs and you can't run into trouble if the user changes
his/her function path somewhere else.
truth@tiamat2:~/mcwpa/src> db2 describe table clients

Column Type Type
name schema name Length
Scale Nulls
------------------------------ --------- ------------------ --------
----- ------
CLINUM SYSIBM CHARACTER 12
0 Yes
CLIREPNUM SYSIBM CHARACTER 10
0 Yes
CLINAME1 SYSIBM CHARACTER 30
0 Yes
...

truth@tiamat2:~/mcwpa/src> db2 describe table ofac

Column Type Type
name schema name Length
Scale Nulls
------------------------------ --------- ------------------ --------
----- ------
ID SYSIBM BIGINT 8
0 No
NAME SYSIBM VARCHAR 255
0 No
...

I've also tried the SQL without converting the types to VARCHAR (the
manual stated that everything would be promoted to VARCHAR
automatically) with the same results.


Right, you shouldn't need the casts. I would leave them out because it
actually makes the query harder to understand.

--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
3745
by: Kostatus | last post by:
I have a virtual function in a base class, which is then overwritten by a function of the same name in a publically derived class. When I call the function using a pointer to the derived class (ClassB* b; b->func(); ) the base-class function is called instead of the new function in the derived class. All other similar functions (virtual in the base class and overwritten in the the derived class) work fine, it's just this one function. ...
117
7152
by: Peter Olcott | last post by:
www.halting-problem.com
18
6155
by: Ian Stanley | last post by:
Hi, Continuing my strcat segmentation fault posting- I have a problem which occurs when appending two sting literals using strcat. I have tried to fix it by writing my own function that does the strcat (mystract). Program below. However this appears not to have fixed the problem and I don't know why it shouldn't ? Any further help as to what else I am doing wrong will be appreciated regards
28
5195
by: Jon Davis | last post by:
If I have a class with a virtual method, and a child class that overrides the virtual method, and then I create an instance of the child class AS A base class... BaseClass bc = new ChildClass(); .... and then call the virtual method, why is it that the base class's method is called instead of the overridden method? How do I fix this if I don't know at runtime what the child class is? I'm using Activator.CreateInstance() to load the...
6
3794
by: Ammar | last post by:
Dear All, I'm facing a small problem. I have a portal web site, that contains articles, for each article, the end user can send a comment about the article. The problem is: I the comment length is more that 1249 bytes, then the progress bar of the browser will move too slow and then displaying that the page not found!!!! If the message is less than or equal to 1249 then no problem.
16
4891
by: Dany | last post by:
Our web service was working fine until we installed .net Framework 1.1 service pack 1. Uninstalling SP1 is not an option because our largest customer says service packs marked as "critical" by Microsoft must be installed on their servers. Now german Umlaute (ä, ü, ö) and quotes are returned incorrectly in SOAP fault responses. This can be easily verified: Implement the following in a web service method (just raises a SOAPException with a...
2
4541
by: Mike Collins | last post by:
I cannot get the correct drop down list value from a drop down I have on my web form. I get the initial value that was loaded in the list. It was asked by someone else what the autopostback was set to...it is set to false. Can someone show me what I am doing wrong and tell me the correct way? Thank you. In the page load event, I am doing the following:
0
2944
by: =?Utf-8?B?am8uZWw=?= | last post by:
Hello All, I am developing an Input Methop (IM) for PocketPC / Windows Mobile (PPC/WM). On some devices the IM will not start. The IM appears in the IM-List but when it is selected from the list athe result is that the standard (QWERTY) keyboard appears. I found that many ( all?) ISV's who make IM's have customers reporting this problem. My research on the internet brought me to the conclusion it is some
1
5110
by: sherifbk | last post by:
Problem description ============== - I have 4 clients and 1 server (SQL server) - 3 clients are Monitoring console 1 client is operation console - Monitoring console collects some data from the control unit and store them into the Sql server - The operation console then retrieve this data from the sql for reporting and statistics purposes - I am using ODBC connection - The problem is that the operation console is not able to...
9
3640
by: AceKnocks | last post by:
I am working on a framework design problem in which I have to design a C++ based framework capable of solving three puzzles for now but actually it should work with a general puzzle of any kind and I need your able help in this activity. Objective - In this activity you will design a framework capable of solving any puzzle of a specific type and, as a test of this framework, use the framework to solve a very simple puzzle. In this first...
0
7946
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8374
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8009
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8240
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6661
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
5739
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5411
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
1482
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1216
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.