× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.