Re: how to use the Select Distinct

To give some further distinction, "if" your system has the STRQM command
you may wish to use that to build your queries.
It allows you to create queries using a prompting method similar to
WRKQRY, or,
you can create queries using sql syntax thereby fully opening up to you
items like distinct, etc.

The STRQM command is part of 57##ST1 - IBM DB2 Query Manager and SQL
Development Kit for i


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Gary Thompson <gthompson@xxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 06/02/2014 02:02 PM
Subject: RE: how to use the Select Distinct
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



FYI
Query Manager provides a way to use select distinct
A query definition can be converted to a query manager query

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Hoteltravelfundotcom
Sent: Monday, June 02, 2014 11:58 AM
To: Midrange Systems Technical Discussion
Subject: Re: how to use the Select Distinct

the case here is that i am using query/400 to get data and there are some
duplicate part #'s we are only interested in 1 part# not the duplicates.

So I thought to use the SQL select distinct. sorry i had left this out.


On Mon, Jun 2, 2014 at 12:22 AM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

Yeah, I hear you -

Take care!
Vern


On 6/1/2014 11:12 PM, Jim It wrote:

Vern,


I will say that while I love to participate, any topic created by op
is ignored by myself due to the fact the question is completely open
and usually ridiculous.


Jim





From: Vernon Hamberg
Sent: ‎Sunday‎, ‎June‎ ‎1‎, ‎2014 ‎11‎:‎46‎ ‎PM
To: Midrange Systems Technical Discussion





Oh well, I just decide to do what I do, and although I agree that
more information would be nice, I also have responded to this OP
enough in the past to have an idea, at least sufficient for me.

-snip-

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.