Re: execute DB2 stored procedure from Squirrel

On 2/21/07, David Schmitt <davidschmitt@xxxxxxxxxxx> 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

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV