This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Calling DB2 stored procedures

 
hpillai
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi:
Can anyone tell me to how to call a DB2/0S390 v 7.1 stored procedure that is residing on MainFrame in Java. I am able to establish the connection through JDBC-ODBC bridge to the DB2 but, unable to execute the stored procedure. I am able to connect to an Oracle Stored Procedure through the prepareCall,setXXX,registerOutParameter. Is this the same way it works for DB2?
Any help is really appreciated.
Thanks,
Hari
 
mike strong
Greenhorn
Posts: 10
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We are on version 6. Any idea if you can connect with just JDBC without DB2Connect?
 
Frank Carver
Sheriff
Posts: 6920
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"hpillai",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp .
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in again with a new name which meets the requirements.
Thanks.
 
Akshaya Dash
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I could call the DB2 stored procedure from VB using ODBC. If this can help let me know. I can provide more details.
Thanks
Originally posted by hpillai:
Hi:
Can anyone tell me to how to call a DB2/0S390 v 7.1 stored procedure that is residing on MainFrame in Java. I am able to establish the connection through JDBC-ODBC bridge to the DB2 but, unable to execute the stored procedure. I am able to connect to an Oracle Stored Procedure through the prepareCall,setXXX,registerOutParameter. Is this the same way it works for DB2?
Any help is really appreciated.
Thanks,
Hari

 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic