Re: data structure input parameter for SPROC

[JLong@xxxxxxxxxx]

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