Re: Stored Procedures

["John Taylor" <john.taylor@xxxxxxxxxxxxxxx>]

Hi Cary,

I recently posted an example of an RPGLE stored procedure that returns a
result set, and the accompanying CREATE PROCEDURE statement. (Recently being
within the last 2 weeks)

Try searching for "RPGLE STORED PROCEDURES" in the midrange-l archive. If
you still have questions, contact me off-list and I'll try to assist you.


Regards,

John Taylor
Canada

> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Kellems, Cary
> Sent: Sunday, August 20, 2000 8:01 PM
> 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
+---