Re: data structure input parameter for SPROC

[TAllen@xxxxxxxxxxxx]

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.
The real question is how to define the SQL procecdure create statment and
then how to fill it from the calling Java class.

Thanks,
Todd




                                                                           
             JLong@xxxxxxxxxx                                              
             Sent by:                                                      
             midrange-l-bounce                                          To 
             s@xxxxxxxxxxxx            Midrange Systems Technical          
                                       Discussion                          
                                       <midrange-l@xxxxxxxxxxxx>           
             01/08/2008 10:17                                           cc 
             AM                                                            
                                                                   Subject 
                                       Re: data structure input parameter  
             Please respond to         for SPROC                           
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




We are doing this by passing the ds as a string and having no trouble.
Define the ds like the external file and the string like the ds and just
moving the ds to the string before the call and reversing it inside of the
sproc.

d fileds         e ds            extname(filename)
d filestring       s             like(fileds)

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.