×
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.
Where is the data structure input parameter?
Thanks,
Todd
JLong@xxxxxxxxxx
Sent by:
midrange-l-bounce To
s@xxxxxxxxxxxx Midrange Systems Technical
Discussion
<midrange-l@xxxxxxxxxxxx>
01/08/2008 12:59 cc
PM
Subject
Re: data structure input parameter
Please respond to for SPROC
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>
<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.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/midrange-l.
midrange.com
