Q and A

Asked and Answered

Where can I find an example of using stored procedures with DB2 and JDBC? We currently use all JDBC and have some long running queries. I would like to run a test by converting these to a stored procedure.

Robert Catterall responds:

I would direct you to the IBM Redbook "DB2 Java Stored Procedures" (document number SG24-5945). You can find it online at http://www.redbooks.ibm.com/ . Once on the Redbooks site, you can enter the document number in the search field to get more information. You can order the hard copy, as I did, or access a PDF or an HTML version of the document. Section 3.7 contains client code samples, including an example of a Java client invoking a stored procedure via JDBC.

See a complete archive of reader/author Q&As .