Re: Looking for SQL to find distinct values of all fields

How about SELECT DISTINCT * FROM LIB/FILE
?

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Alan Shore
Sent: Wednesday, July 18, 2007 9:54 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Looking for SQL to find distinct values of all fields


Hi Donna
to find the DISTINCT values of each of the 15 fields, it looks like you
will have to execute the select 15 different times with a different field
in each of the executions.
If you say
select DISTINCT field1, field2 from LIB/FILE
you will get a listing of the distinct groupings/combinations which is NOT
what I believe you are looking for



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill


donna lester <donna_lester_ny@ yahoo.com> To Sent by: RPG programming on the AS400 / rpg400-l-bounces@ iSeries <rpg400-l@xxxxxxxxxxxx> midrange.com cc Subject 07/18/2007 12:12 Looking for SQL to find distinct PM values of all fields Please respond to RPG programming on the AS400 / iSeries <rpg400-l@midrang e.com>




I have 15 fields in my file.
For one field
I can use SQL like
select DISTINCT field1 from LIB/FILE
How do I extend this SQL to find out distinct values of all 15 fields?




Thanks,

Donna.

---------------------------------
Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's
on, when.
--
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.