Re: JDBC CallableStatement and SQL Procedure example

["Richard Dettinger" <cujo@xxxxxxxxxx>]

"I'm looking for an example of an SQL procedure (written
in RPG) that returns 1 or more ResultSets being used
in a java program. I'm wondering if this is possible..."

I could really use this too... I don't need the Java program to use it, as
long as someone gives me the create procedure
information so that I can get the stored procedure created.  I'd like to
use this information in helping people with an
RPG background and code base understand how to build stored procedures that
they can leverage in their Java
programs.

If someone with a background in RPG could help this Java programmer out,
I'd be very grateful.

Richard D. Dettinger
iSeries Java Data Access Team

Democracy's enemies have always underestimated the courage of the American
people.
It was true at Concord Bridge.  It was true at Pearl Harbor.  And it was
true today.

         Rochester Post-Bulletin
         Tuesday September 11, 2001