File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes DB2 stored procedure call Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB2 stored procedure call" Watch "DB2 stored procedure call" New topic

DB2 stored procedure call

Michael Waserman

Joined: Jul 10, 2004
Posts: 28
Calling the DB2-Cobol storprocedure from my Java program I had the table unavailability problems and decided to set COMMIT ON RETURN parameter to YES. Resource unavailability problem is gone, but also I've lost my result set:
"[NEON][SCODBCTS DLL]No result set available to fetch from"

Any help is greately appreciated.
I agree. Here's the link:
subject: DB2 stored procedure call