Re: Mimixing pure SQL stored procedures.

I've updated my Mimix case with basically a different procedure is not
replicating. Apparently they do a fine job of chopping most of the sql
out of QSYS2/SYSPROCS. But they are missing the varibles listed in
IN_PARMS, OUT_PARMS, INOUT_PARMS. Which causes their recreate (RUNSQLSTM)
to fail with SQL0312 variable not defined. Actually, the variables are
not listed; just the quantities of each. This causes this:
1 create procedure ROUTINES/DRPCODE ( in lib char(10), in name
char(10), in
2 type char(1) )
...
to become:
1 SET PATH *LIBL ;
2
3 CREATE PROCEDURE ROUTINES.DRPCODE (
4 )
5 LANGUAGE SQL
6 SPECIFIC ROUTINES.DRPCODE
7 NOT DETERMINISTIC
8 MODIFIES SQL DATA
9 CALLED ON NULL INPUT
10 SET OPTION ALWBLK = *ALLREAD ,
11 ALWCPYDTA = *OPTIMIZE ,
12 COMMIT = *NONE ,
13 DECRESULT = (31, 31, 00) ,
14 DFTRDBCOL = *NONE ,
15 DLYPRP = *NO ,
16 DYNDFTCOL = *NO ,
...
With no "in"'s.

Frankly I don't know how they would recreate this. I'll leave that up to
them.

Rob Berendt