Re: SQL

Hi Douglas,

Try

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

Peter Dow
Dow Software Services, Inc.
909 793-9050 voice
909 793-4480 fax
951 522-3214 cell


----- Original Message ----- 
From: "Douglas W. Palme" <dpalme@xxxxxxxxxxxxxxxxxxxxx>
To: "RPG Group" <rpg400-l@xxxxxxxxxxxx>
Sent: Thursday, March 31, 2005 1:40 PM
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.
>
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.8.6 - Release Date: 3/30/2005
>
>



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.6 - Release Date: 3/30/2005