You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Marco Schilling <ma...@gmx.de> on 2006/12/07 11:19:59 UTC
calling a function over odbc fails
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";
Any help is appreciated,
thank you very much,
Marco
--
"Ein Herz für Kinder" - Ihre Spende hilft! Aktion: www.deutschlandsegelt.de
Unser Dankeschön: Ihr Name auf dem Segel der 1. deutschen America's Cup-Yacht!
Re: calling a function over odbc fails
Posted by Marco Schilling <ma...@gmx.de>.
Knut Anders Hatlen <Kn...@...> writes:
>
> Marco Schilling <ma...@...> 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
Re: calling a function over odbc fails
Posted by Knut Anders Hatlen <Kn...@Sun.COM>.
Marco Schilling <ma...@gmx.de> 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?
--
Knut Anders