---

Return to the SQL Tips

---

Creating Stored Procedures.

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)

[report a broken link by clicking here]

---