Re: Arrays

["Richard ECUYER" <recuyer@xxxxxxx>]

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.
>
>