Re: Locating Primary records with identical detail records

Still confused....

If all you're looking for is duplicate FUNCTIONs

select * from detail
where FUNCTION in (select FUNCTION, count(*) from detail having count(*) > 1)
order by FUNCTION

But, this wouldn't have required an array in RPG, simply reading
detail via a logical keyed over FUNCTION would have done the trick.

So I think I'm still missing something....

Charles

On Fri, May 29, 2009 at 11:29 AM, John McKee <jmmckee@xxxxxxxxxxxxxx> wrote:

Think of two customers.  They ordered the same merchandise.  Master is
customer,
detail is what was ordered.  How many times does that happen?  That is the
question?  This isn't about merchandise, though.  Just looking to
identify when
detail for one master is the same as the detail for another master.  But,
without knowing a particular Master id.

John McKee

Quoting Charles Wilt <charles.wilt@xxxxxxxxx>:

Ok...so?

That doesn't answer my question.

How can two detail records be the "same" yet "not match".

Are you simply saying the "same" FUNCTION shows up with multiple IDs?
Yet the rest of the fields in the detail can different ("not match")
or can be the same ("match")?

Try describing what you want in English.

Charles

On Fri, May 29, 2009 at 10:37 AM, John McKee <jmmckee@xxxxxxxxxxxxxx> wrote:

An earlier effort, in RPG III, had to work with the limit of an array.  Been
years since I attempted this.  Point was that I could not fit all the Detail
record FUNCTIONS into a record for sorting.  Likely, the size limit has been
eased over the years.  But, a record length of 10000 just to accommodate all
possibilities seemed a bit excessive.

John McKee

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