RE: Stored Procedures

Sorry I don't have an example to hand but I seem to remember that the trick
is in the way it's compiled, not really the way it's written.

Alistair

-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Kellems, Cary
Sent: 21 August 2000 04:01
To: 'MIDRANGE-L@midrange.com'
Subject: Stored Procedures


Hello All,

Does anyone have an example of an RPGLE program that can be used as a stored
procedure that returns a result set?  I have attempted to use a internal
array as the result set but am unsure(unsuccessful) as to how to code this.
Do I uses an SQL statement within the RPGLE to accomplish this?  If so how
is this coded.  Also, how is the CREATE PROCEDURE statement defined?  Any
help is always appreciated.   TIA


+---
| 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
+---

+---
| 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
+---