jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Stored proc on DB2 error 42703 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Stored proc on DB2 error 42703" Watch "Stored proc on DB2 error 42703" New topic
Author

Stored proc on DB2 error 42703

louise rochford
Ranch Hand

Joined: Apr 04, 2002
Posts: 119
Hi all,
We're trying to run a Stored procedure for the first time in java & get the following error message:
Caught SQLException during lookup printing
getErrorCode-206
getMessage[IBM][CLI Driver][DB2] SQL0206N "PKGNAME " is not valid in the context where it is used. SQLSTATE=42703
getSQLState42S22
We're connecting to DB2 (version 7, I think), via DB2Connect the run time client, from WSAD 5.1.0.
Does anyone have any ideas how to fix it?
Many thanks,
Louise
louise rochford
Ranch Hand

Joined: Apr 04, 2002
Posts: 119
Forgot to say... The procedure runs fine from a COBOL program - its just a problem accessing it through java.
Adam Kreiss
Ranch Hand

Joined: Sep 12, 2005
Posts: 35
Did you ever figure out a solution for this? I'm having a very similar problem on the same version of DB2 (scary huh? 3 years later...)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Stored proc on DB2 error 42703
 
It's not a secret anymore!