db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marco Schilling <marco.schill...@gmx.de>
Subject Re: calling a function over odbc fails
Date Thu, 07 Dec 2006 19:41:59 GMT
Knut Anders Hatlen <Knut.Hatlen@...> writes:

> 
> Marco Schilling <marco.schilling@...> writes:
> 
> > Hello everyone,
> >
> > I wrote a function called CHKANI(ani varchar(50)) and it works
> > pretty fine in ij. Now I try to use it with the DB2 ODBC-Driver and
> > it fails with "... is not recognized as a function or
> > procedure". The statement looks like this: SELECT CHKANI('0123456')
> > AS "ANI", "PHONE" from "APP"."SAMPLE";
> 
> Does CHKANI live in the current schema? Perhaps APP.CHKANI would work?
> 

Hello everyone,

CHKANI was not available in the namespace. I´ve changed the user and now
everything works fine.

Thank you for helping.

Marco






Mime
View raw message