×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
midrange.com
