Re: data structure input parameter

[TAllen@xxxxxxxxxxxx]

   This data structure has packed numeric fields and the file format on which
   the data structure was created is more than 60 fields.  I may come back to
   this when time permits but at this point I think we are going to create a
   front-end RPG program that will be wrapped by an SQL stored procedure. 
   This "middleware" program will call the program with the DS entry
   parameter.
   Thanks,
   T

   -----java400-l-bounces@xxxxxxxxxxxx wrote: -----

     To: "Java Programming on and around the iSeries / AS400"
     <java400-l@xxxxxxxxxxxx>
     From: "Michael Ryan" <michaelrtr@xxxxxxxxx>
     Sent by: java400-l-bounces@xxxxxxxxxxxx
     Date: 01/08/2008 08:53AM
     Subject: Re: data structure input parameter

     Numeric fields in a data structure are zoned by default, so they
     shouldn't cause a problem. A data structure *is* a big string that can
     be subdivided with an RPG definition. The length of the string is the
     length of the data structure.

     On Jan 8, 2008 8:49 AM,  <TAllen@xxxxxxxxxxxx> wrote:
     > The input parameter is an externally defined data structure.  I've not
     > tried anything yet since I was unsure if this would be the equivalent
     of
     > passing in one long string.  What did you mean that the parm is
     actually
     > one field, with the total length of the data structure?  These are the
     sort
     > of things I need to find out if we're going to try to make this work.
     > If the data structure is treated as one long string, then it seems the
     > numeric fields in the DS could cause problems and make this more
     trouble
     > than it's worth.  I've not seen anything in the JT400 toolbox for data
     > structures that would apply here.
     >
     > Any tips are appreciated.
     >
     > Thanks,
     > Todd
     >
     >
     >
     >
     >
     >              "Walden H.
     >              Leverich"
     >              <WaldenL@TechSoft                                        
      To
     >              Inc.com>                  "Java Programming on and around
     the
     >              Sent by:                  iSeries / AS400"
     >              java400-l-bounces         <java400-l@xxxxxxxxxxxx>
     >              @midrange.com                                            
      cc
     >
     >                                                                  
      Subject
     >              01/08/2008 08:32          RE: data structure input
     parameter
     >              AM
     >
     >
     >              Please respond to
     >              Java Programming
     >              on and around the
     >               iSeries / AS400
     >              <java400-l@midran
     >                   ge.com>
     >
     >
     >
     >
     >
     >
     > What's the problem? Don't forget that the parm is actually just one
     > field, with the total length of the data structure, so you'll have to
     > assemble the appropriate structure on the caller. Are you trying to
     > define the subfields on the stored proc? You can't. What error(s) are
     > you getting on the call?
     >
     > -Walden
     >
     > --
     > Walden H Leverich III
     > Tech Software
     > (516) 627-3800 x3051
     > WaldenL@xxxxxxxxxxxxxxx
     > http://www.TechSoftInc.com
     >
     > Quiquid latine dictum sit altum viditur.
     > (Whatever is said in Latin seems profound.)
     >
     >
     > -----Original Message-----
     > From: java400-l-bounces@xxxxxxxxxxxx
     > [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
     TAllen@xxxxxxxxxxxx
     > Sent: Monday, January 07, 2008 4:14 PM
     > To: java400-l@xxxxxxxxxxxx
     > Subject: data structure input parameter
     >
     >
     > Has anyone used an external SQL stored procedure that wraps around an
     > RPG
     > program that has a data structure as an input parameter.
     > So far my searches have been fruitless so I'm hoping someone can tell
     me
     > if
     > this is possible or not.
     >
     > Thanks,
     > Todd
     >