Function Path Issue

[murshidgre]

I am getting following error message, whenever i try to use any built-in function of DB2, e.g.
select RTRIM(custName) from Customer

"SQL0440N No function by the name "RTRIM" having compatible arguments was found in the function path. SQLSTATE=42884 "

I would really appreciate your help.

 

[MarcLodge]

Hi murshidgre,

What version of DB2 are you using, and on what platform?

Marc

 

[murshidgre]

Hi Marc,

The DB2 Ver is 7.2 while the OS is LINUX(REDHAT) 7.3.
I am kind of stuck at this point, i really appreciate your help.

Thanks,

 

[juliane26]

check first in your function list, whether you can see the functions at all, check permissions, but they should be ok when you can select at all

also check your current function path
> db2 values(current function path)
and ensure that SYSIBM and SYSFUN are present

i would suggest rebind your client packages and see what happens
(in sqllib\bind: at least db2cli.lst, see also

http://publib.boulder.ibm.com/infoc...p?topic=/com.ibm.db2.udb.doc/ad/r0007866.htm)

I am not sure in which package these funtions are, but I am sure it is somewhere there in sqllib/bnd



Juliane