Re: data structure input parameter for SPROC

[TAllen@xxxxxxxxxxxx]

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.