Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Stored proc on DB2 error 42703

 
louise rochford
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Forgot to say... The procedure runs fine from a COBOL program - its just a problem accessing it through java.
 
Adam Kreiss
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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...)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic