File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Calling DB2 stored procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Calling DB2 stored procedures" Watch "Calling DB2 stored procedures" New topic
Author

Calling DB2 stored procedures

hpillai
Greenhorn

Joined: May 14, 2001
Posts: 2
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

Joined: May 24, 2001
Posts: 10
We are on version 6. Any idea if you can connect with just JDBC without DB2Connect?
Frank Carver
Sheriff

Joined: Jan 07, 1999
Posts: 6920
"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.


Read about me at frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
Akshaya Dash
Greenhorn

Joined: Jul 10, 2001
Posts: 2
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

 
wood burning stoves
 
subject: Calling DB2 stored procedures