Well...this seems odd. I'm trying to create a procedure like this in
interactive SQL (STRSQL):
CREATE PROCEDURE NEWSYS/MSP_VALIDATESTORE(INOUT IOStore CHAR ( 3))
LANGUAGE RPGLE SPECIFIC NEWSYS/MSPSRVPGM(MSP_VALIDATESTORE) NOT
DETERMINISTIC READS SQL DATA EXTERNAL NAME
'NEWSYS/MSPSRVPGM(MSP_VALIDATESTORE)' PARAMETER STYLE GENERAL
And I get a SQL0491 with reason code 10: 10 -- For external functions and
procedures, LANGUAGE SQL is not allowed
and there must not be a routine body.
So I went into Navigator and played around, and got it to where I think I
want it. Is there a difference between what you can do in interactive SQL
and what you can do in Navigator? Thanks!
As an Amazon Associate we earn from qualifying purchases.
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.