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

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
cgttsp01Asked:
Who is Participating?
 
cheekycjConnect With a Mentor Commented:
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
 
cheekycjCommented:
Thanx for the "A" and good luck.

CJ
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.