|
From: Robert M. <rob...@gm...> - 2007-02-22 11:49:10
|
On 2/21/07, David Schmitt <dav...@ho...> wrote: > This is the code I'm trying to execute within Squirrel: call > DBSCH1.J5143106(10983,0,@x,@y); > > where @x, and @y are CHAR OUT parms. The two IN parms are INTEGER. The proc > also returns a result set. > > This is the error: > > Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL0440N No > function by the name "J5143106" having compatible arguments was found in the > function path. SQLSTATE=42884 > , SQL State: 42884, Error Code: -440 I looked at some examples on IBM's website of calling stored procedures from various apps (CLI, Java, C). It appears that "db2" CLI parses the "call ..." and handles it different than "select * from .." or some other such query. I think we may need to detect this "call..." and handle it differently (instead of using Statement, using CallableStatement). The new pluggable QueryTokenizer could be used for part of this task, but I'll need to see how we are handling CallableStatements (I don't know that we are currently so that might be new functionality as well). If you come across any additional information (using Statement to execute stored procs for instance) please send it my way. Rob |
