Re: RPG use of Stored Procedure result set

I have a Java 'stored procedures tester' which exercises any stored
procedure, prompting for input parameters, displaying all outputs & also
any result set (currently only one result set, but would be relatively easy
to modify to handle as many as are returned) - let me know offline if you
(or anyone) would like a copy. It uses either the DB2 or the Toolbox JDBC
driver depending what parameter you specify, so will run on PC or AS/400 as
required.
You can't pick up returned stored procedure result sets in RPG, only in C
or Java, unfortunately, because RPG doesn't support the SQL Call Level
Interface.
Mandy





AIV <aiv@ctv.es> on 14/12/2000 00:01:25

Please respond to MIDRANGE-L@midrange.com

To:   Midrange-List <MIDRANGE-L@midrange.com>
cc:    (bcc: Mandy Shaw/Pacific/UK)
Subject:  RPG use of Stored Procedure result set




Hi,
we have been doing some testing with ADO/OLE/DB and Stored Procedures on
the AS/400.
Since we run into some problems, I want to test these same stored
procedures from within the AS/400 itself, instead of  from VB or Delphi.

Reading old editions from News/400, Paul Conte's articles on Stored
procedures (back in end of 1997 !!!) I found an article that had an
example of how to use a Stored Procedure from an "client" RPG program,
but the example shown did NOT include the use of returning a "result
set" from the stored procedure back to the client program, normally VB
or Delphi.
The question is, if my Stored Procedure returns a result set, and I want
to read it from an RPG client program, how am I supposed to
define/use/read it in RPG ?
Any one had any experience with this?
--
Antonio Fernandez-Vicenti
aiv@ctv.es


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---



      Regards,
      Mandy Shaw

      Catalyst Solutions plc
      Kingfisher House
      Frimley Business Park
      Camberley
      Surrey
      GU16 5SG
      UK

      http://www.catalyst-solutions.com
      Email: Mandy.Shaw@uk.catalyst-solutions.com

      Telephone: +44 (0)870 166 1000
      DDI: +44 870 166 1324
      Facsimile: +44 870 168 3920
      Mobile: +44 410 447966






----------------------------------------------------------------------
Catalyst Solutions plc.  Registered No 2918101.
Registered @ Kingfisher House, Frimley Business Park, Frimley,
Surrey. GU16 5SG   U.K.

NOTICE:
This message is intended only for the named addressee(s) and may
contain confidential and/or privileged information. If you are not the
named addressee you should not disseminate, copy or take any action
or place any reliance on it. If you have received this message in error
please notify postmaster@catalyst-solutions.com and delete the message
and any attachments accompanying it immediately.
----------------------------------------------------------------------


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---