FW: Stored Procedures

["Kellems, Cary" <cary.kellems@xxxxxxxxxxxxxx>]

Brad,

Yes you can do it without the SQL Devl Kit, just type STRSQL and then enter
your CREATE PROCEDURE.  An example is:

CREATE PROCEDURE FILEA/RSET2 (IN WO_NUMBER CHAR(5), TBTYPE  CHAR(5),
 TBDETL CHAR(1), TBCODE CHAR(10)) RESULT SETS 1 EXTERNAL NAME       
KELLEMC/X79500 LANGUAGE RPGLE GENERAL                               

(Where FILEA/RSET2 is the Stored procedure name, IN specifies these fields
(WO_NUMBER CHAR(5), etc.) as Input, RESULT SETS specify that the output is a
Result set, EXTERNAL NAME  KELLEMC/X79500 is an RPGLE pgm which is called) 

I hope this helps.

Cary

> -----Original Message-----
> From: Brad Bird [SMTP:BBird@PRIMEINC.COM]
> Sent: Friday, September 15, 2000 6:23 AM
> To:   RPG400-L@midrange.com
> Subject:      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
> +---
+---
| 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
+---