RE: Arrays

My first thoughts go toward embedded SQL as mentioned in a couple of other 
posts.  If that won't work, or maybe in addition to embedded SQL, you might 
want to check out user indexes.

Conceptually, they function like work files but are faster and you define the 
index on the fly.  Each entry has an index portion at the beginning.  Whatever 
you place into this area becomes the key value.  No matter what order entries 
are placed into the index they can be retrieved in index order.  The maximum 
size escapes me at the moment but I think it is something like 16Gb.  Check out 
the user index API's for more information.  There have also been several 
discussions on the list so the archives will have some useful information.

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Douglas W. Palme
Sent: Tuesday, March 29, 2005 8:27 AM
To: RPG programming on the AS400 / iSeries
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.



Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.