RE: Arrays -- RPG400-L

SQL is well worth the coin paid to obtain it.  Harness it's power & you'll
never want to type the command WRKQRY again....

Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Douglas W. Palme
Sent: Tuesday, March 29, 2005 9:37 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Arrays


Currently its installed but its not a licensed program so we are running 
tight on the temp license, I have thought about purchasing a license key for

it but have not done so so far.




On Tue, 29 Mar 2005 17:15:39 +0200, Richard ECUYER wrote
> 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.
> >
> >
> 
> -- 
> 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.