Re: [BPCS-L] How to check for duplicate BOM's

[Tom Jedrzejewicz <tomjedrz@xxxxxxxxx>]

Perhaps . . . 

1. Create a file, with 2 fields, item # and a big text field.

2. Write an RPG program that reads the MBM file, and write one record
per item, with the relevant fields from each component

Read MBM
Dow !EOF
  Clear text field
    Dow !EOF & parent unchanged
      If withing effective dates, 
        Append child, other relevant fields . . .  to text field
      Read next MBM
    EndDo
  Write work field
EndDo

3. Query this file for duplicates - SELECT TEXTFIELD, COUNT(*) FROM
FILE ORDER BY TEXTFIELD HAVING COUNT(*) > 1

I'll bet there is a way to do it directly using SQL using joins or
unions or subselects, but it is beyond my little brain.

On Wed, 8 Dec 2004 15:28:55 -0500, Daniel Warthold
<daniel.warthold@xxxxxxxxx> wrote:
> 
> Hi everyone,
> 
> Is there an easy way, to check if there are duplicate BOM's, meaning the
> exact same components, quantities, no more no less, in the same facility,
> same method, but with 2 (or more) different parents? Does mot matter if the
> MBM.BSEQ, MBM.BBUBB, the effectivity dates, or any other fields, including
> the BOM notes (MPN) and ref des (MBZ) are different. Basically I'm trying to
> look for 2 or more manufactured items that are identical in regards to  the
> list of their components, but have different item number. Like if the
> engineers designed again an already existing item, but given it a different
> item number?
> 
> Thanks
> Daniel Warthold P. ENG CPIM

-- 
Tom Jedrzejewicz
tomjedrz@xxxxxxxxx