Re: data structure input parameter

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
>