× 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.


  1.  Home
  2. MIDRANGE-L
  3. January 2008

Re: data structure input parameter for SPROC

<Snip>
The RPG program is written. I am trying to create an external SQL stored
procedure that wraps around the RPG program that has the data structure
input parameter.
<Snip>

Below is our create procedure that is returning the file data structure as
string. The 462 is just the files record length. It is calling a
procedure in a service program but this should be enough of an example to
start with. Replace the &LIB with your library the SPROC and program
reside in. That is needed for our change management software from Aldon.
Not sure about the Java side of things but hopefully this will help from
the RPG side of it.

CREATE PROCEDURE &LIB/INVMST_READ
(IN Key1 CHAR (20 ),
IN Key2 CHAR (10 ),
OUT Dstring CHAR (462 ))
LANGUAGE RPGLE NOT DETERMINISTIC
MODIFIES SQL DATA
EXTERNAL NAME '&LIB/INVMST(INVMST_READ)'
PARAMETER STYLE GENERAL

Jack Long
CBK Ltd.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
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.