× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.