Knut Anders Hatlen <[EMAIL PROTECTED]> writes:
>
> Marco Schilling <[EMAIL PROTECTED]> 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
