db-derby-user mailing list archives

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