RE: SQL

[Holden Tommy <Tommy.Holden@xxxxxxxxxxxxxxxxx>]

select ilnsoldto, sum(ilneprice) from impiln00
  group by ilsoldto

to use sum() or other functions grouping *may* be necessary as in this
case...

Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Douglas W. Palme
Sent: Thursday, March 31, 2005 3:40 PM
To: RPG Group
Subject: SQL


As a follow up to the questions I had the other day, I've ordered the 
appropriate license key for the SQL and have started working on learning 
embedded sql to use with my rpg.

Needless to say, it'll delay some reports a bit but I think in the long run 
it'll help.

One question I do have, I am running the sql interactive query and I am just

playing with it a bit, but have run into a problem that maybe one of you can

help me out with; considering the slightly different syntax between sql for 
the iSeries and what I am used to.

I have a PF that cotnains among other fields, ilneprice (which contains 
extended price amount), and a ilnsoldto field which is a reference field for

the customer number.

When I run 'select ilnsoldto' by itself it runs fine, when I run sum
(ilneprice) by itself its fine but when I run the following command it tells

me the ilnsoldto field is incorrect:

select ilnsoldto, sum(ilneprice) from impiln00

Suggestions? Comments?

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