Stored Procedures

Can someone explain how I create a RPGLE program into a Stored Procedure and
if I can do that without the lic prod SQL Development Kit for AS400? We are
getting an imaging system which calls the RPGLE program as a Stored
Procedure to get index field values returned.  I've got "Who Knew You Could
Do That in RPG IV?" book and see where it says you can use API calls to
execute SQL but didn't know if it'll also do CREATE PROCEDURE.  Perhaps I
don't need to execute the SQL CREATE command, maybe just creating it as ILE
works?? Can someone steer me in the right direction? TIA.
-------------------------
Brad Bird                         mailto:bbird@primeinc.com
Prime, Inc.                                http://www.primeinc.com
2740 N Mayfair
Springfield, MO  65803
phone:(417) 866-0001 x3211
fax:  (417) 521-6863



http://www.primeinc.com
**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed.  If you have received this email
in error please reply to the sender of the message.

The views expressed in this correspondence may not
reflect the views of Prime, Inc.

This footnote also confirms that this email message has
been scanned for the presence of computer viruses.
***********************************************************************

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