Re: Locating Primary records with identical detail records

John McKee wrote:

Thanks so much for the suggestions. And, for the time you gave to this problem.
I had wondered if there was an "easier" way to do this than brute force. I had
hopes that SQL could help, and that I could use the issue as another opportunity
to explore the power of SQL.

It can be done in SQL and likely can be done in DB2/400. What would likely work would be to create a Pivot Table. In your case, for each header value you would likely load the count of each function identifier in the row with that value.

You could then join this table to itself looking for function count matches where the header value doesn't match. Here's a dogpile.com search for building pivot tables in SQL:
http://www.dogpile.com/dogpile/ws/results/Web/create%20a%20pivot%20table%20in%20sql/1/417/TopNavigation/Relevance/iq=true/zoom=off/_iceUrlFlag=7?_IceUrl=true

Here's an article that contains code for creating a pivot table using SQL/400: http://www.itjungle.com/fhg/fhg052505-story01.html

Bill