db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marco Schilling" <marco.schill...@gmx.de>
Subject calling a function over odbc fails
Date Thu, 07 Dec 2006 10:19:59 GMT
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";

Any help is appreciated,
thank you very much,

Marco
-- 
"Ein Herz für Kinder" - Ihre Spende hilft! Aktion: www.deutschlandsegelt.de
Unser Dankeschön: Ihr Name auf dem Segel der 1. deutschen America's Cup-Yacht!

Mime
View raw message