Solved

Anyone know the query syntax for calling a Stored Procedure in DB2?

Posted on 2002-04-15
3
244 Views
Last Modified: 2011-09-20
I would like to start using stored procedures in DB2 with JSP, but I don't know the query syntax and the IBM site is almost useless.

Anyone have query examples they can share?
Thanks
0
Comment
Question by:cgttsp01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 52

Expert Comment

by:Ryan Chong
ID: 6943739
0
 
LVL 19

Accepted Solution

by:
cheekycj earned 50 total points
ID: 6944855
calling a stored proc in JSP is the same as in standard Java.  Use the CallableStatement Object.

http://www.j-netdirect.com/GenStoredProcedures.htm
http://java.sun.com/docs/books/tutorial/jdbc/basics/sql.html

Sun's entire tutorial is an excellent resource:
http://java.sun.com/docs/books/tutorial/jdbc/index.html

for db2 specific info:
http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg245945.pdf

CJ
0
 
LVL 19

Expert Comment

by:cheekycj
ID: 8692632
Thanx for the "A" and good luck.

CJ
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
xjc and jaxb 2 99
How to find missing packages when using Netbeans IDE 8.1 ? 19 84
maven set up 2 206
jsp error 6 67
I took on this little project as a proof of concept for IoT devices. My main goals were to find the easiest, cheapest way to stream data to the cloud. This article describes how to stream telemetry data to ThingSpeak via REST API. This can also be d…
A hard and fast method for reducing Active Directory Administrators members.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question