• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Calling DB2 stored procedures

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
We are on version 6. Any idea if you can connect with just JDBC without DB2Connect?
 
Sheriff
Posts: 7001
6
Eclipse IDE Python C++ Debian Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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


 
Do you pee on your compost? Does this tiny ad?
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic