• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

Stored proc on DB2 error 42703  RSS feed

 
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.
 
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...)
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!