RE: Arrays

[<SRamanujan@xxxxxxxxxxxxxxxxxx>]

Doug,
As others have suggested, I feel, the embedded sql will reduce the
amount of work involved in this scenario.  You could use the dynamic sql
and open cursors with condition and fetch result set into the subfile.
The code for the total can also be done in 1 aggregate statement than
several rpg codes.  On a work file, the creation of the file and I/O
could be more CPU intense than an embedded sql. 
Thanks,
Sudha


Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax

-----Original Message-----
From: Douglas W. Palme [mailto:dpalme@xxxxxxxxxxxxxxxxxxxxx] 
Sent: Tuesday, March 29, 2005 9:04 AM
To: RPG programming on the AS400 / iSeries
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.