Re: Arrays

["Richard ECUYER" <recuyer@xxxxxxx>]

if you have SQL product (enter strsql to see it), i can sand yu some piece
of code, you 'll see that :

    - it is easy to use
    - very easy to maintain the code
    - performance are pretty nice
    - You can make total, sub total without any new piece of code..

In one word : use it if you can.

----- Original Message ----- 
From: "Douglas W. Palme" <dpalme@xxxxxxxxxxxxxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, March 29, 2005 5:03 PM
Subject: Re: Arrays


> I have not worked with embedded sql to this point.
>
>
> On Tue, 29 Mar 2005 16:51:46 +0200, Richard ECUYER wrote
> > Did you try embeded sql ?
> > You can get the total from one request and the detail from another one.
> >
> > If you have the good access path, result will be fast.
> >
> > ----- Original Message ----- 
> > From: "Douglas W. Palme" <dpalme@xxxxxxxxxxxxxxxxxxxxx>
> > To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
> > Sent: Tuesday, March 29, 2005 4:27 PM
> > Subject: Re: Arrays
> >
> > > I have never used work files, so I would have to do some research on
> that,
> > > not that I am opposed to such a venture, but I was hoping to resuse
some
> > of
> > > my existing skills.
> > >
> > > The whole reason behind this question is that I have to create a
subfile
> > > that will display based on what salesman number the user enters, YTD
> > > hardgood sales (which is contained within the customer master file)
and
> > then
> > > Cylinder rent which would be a cumulative amount from the line item
file
> > > (which contains 1.3 million records) and then a calculated field
showing
> > the
> > > total, this has to be done for each different customer number assigned
to
> > > the salesman, and to top it off, I need the data displayed in
descending
> > > order LOL
> > >
> > > Pulling the info from the customer master is easy enough, but I would
> have
> > > to loop through the line item file hundreds or even thousands of times
 to
> > > get the totals.
> > >
> > > I thought about creating a logical file for each salesman in customer
> > order
> > > but maintenance would be heavy, as each time we add a new salesman I
have
> > to
> > > create a new logical file and then modify the code.
> > >
> > > I suppose I could create a logical joined file with the pertinent info
> and
> > > then key in on the salesman and then customer, but I am not sure if
that
> > is
> > > the best answer.
> > >
> > > I am open ears to anyone with any suggestions :)
> > >
> > > -- 
> > > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> > > To post a message email: RPG400-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > > or email: RPG400-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/rpg400-l.
> > >
> > >
> >
> > -- 
> > This is the RPG programming on the AS400 / iSeries (RPG400-L)
> >  mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To
> > subscribe, unsubscribe, or change list options, visit:
> > http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-
> > L-request@xxxxxxxxxxxx Before posting, please take a moment to
> > review the archives at http://archive.midrange.com/rpg400-l.
>
>
> --
> Open WebMail Project (http://openwebmail.org)
>
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>