Re: calling a function over odbc fails

2006-12-07 Thread Marco Schilling
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

calling a function over odbc fails

2006-12-07 Thread Marco Schilling
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 "AP