Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Result Set from a DB2 stored procedure  RSS feed

Richard Olmstead
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello colleagues,
My Java call to a DB2 stored procedure isn't working... the error is
String Literals not supported in procedure calls to DB2/390

and, the code is
String inp = "76021592220080101" ;
String sql = "{call ? := G714.GDDPOHP2(?)} " ;

CallableStatement callable = conn.prepareCall( sql );
callable.registerOutParameter(1, java.sql.Types.CHAR);
callable.setString(2, inp);

I'd be grateful for any advice.
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!