Need help with Java JDBC talking to DB2 Stored Procedure

IBM's flagship relational database management system

Need help with Java JDBC talking to DB2 Stored Procedure

Postby Balr14 » Sat Nov 20, 2010 5:17 am

Here's the problem: We have a client who communicates with the mainframe DB2 via Java JDBC dynamic SQL. They are changing to using stored procedures on the mainframe, using our software to help save mips. Our software will significantly improve DB2 performance by caching DB2 tables and providing much faster access. The stored procedures must be written in COBOL or C; we do not support Java. If you declare the cursor "with return" in the stored procedure, it is supposed to return the result set to Java (in theory). However, we need to modify what is returned, because we are accessing non-DB2 tables in memory pools. When we do this, we must build the output in the stored procedure that's delivered to the Java server, as far as I know anyway. Unfortunately, it is in the wrong format.

I need to find a way to deliver the result set in JDBC format, without using DB2 global temporary tables. We are willing to contract with any individual who knows how to do this and we will provide remote access to our mainframe.
Posts: 41
Joined: Fri Oct 01, 2010 9:43 pm
Has thanked: 0 time
Been thanked: 1 time

Return to DB2


  • Related topics
    Last post