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? -- Knut Anders