RE: Stored Procedures

[Buck Calabro <buck.calabro@xxxxxxxxxxxxxxxxx>]

Cary Kellems wrote:

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

Use a multiple occurrence data structure instead of an array.

>Do I uses an SQL statement within the 
>RPGLE to accomplish this?  If so how
>is this coded.  

C/EXEC SQL SET RESULT SETS ARRAY :ARY FOR :CTR ROWS 
C/END-EXEC                                          

>Also, how is the CREATE PROCEDURE 
>statement defined?  

STRSQL, type CREATE PROCEDURE and prompt for it.  That should get you
started.  IBM's web site has the SQL manuals on it: http://www.as400.ibm.com
I believe you take the "library" link, and then the "Info Centre" link.

If you have a specific problem, perhaps you could try the RPG list, the RPG
gurus hang out over there...

Buck Calabro
Aptis; Albany, NY
"We are what we repeatedly do.
 Excellence, then, is not an act, but a habit." --Aristotle


Billing Concepts Corp., a NASDAQ Listed Company, Symbol: BILL
+---
| 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
+---