Re: Stored Procedures

["David Morris" <dmorris@xxxxxxxxxxxxx>]

Brad,

You can create a stored procedure without the SQL licensed product.  The 
easiest way without 
the licensed product is to use Operations Navigator.  One of the database 
options is run sql 
statement.  The April issue of Midrange Computing had an article that describes 
RPG UDFs.  
You can read it here:

http://www.midrangecomputing.com/mc/article.cfm?titleid=a289&md=20004 

David Morris

>>> BBird@PRIMEINC.COM 09/15/00 07:22AM >>>
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 


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