db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: calling a function over odbc fails
Date Thu, 07 Dec 2006 10:42:58 GMT
Marco Schilling <marco.schilling@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

View raw message