This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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
 
Similar Threads
function sequence error in DB2
ID_NAME in two tables
PreparedStatement error shown
com.ibm.websphere.cpi.CPIException
The specified DLL "DB2I..my_stored_proc" could not be loaded