Re: Removing duplicates from unique

At 07:20 04/06/97 GMT, you wrote: }In article <01bc7061$998685c0$36cc0280@vince.iss.bassinc.com>, } "Vince Pachiano" <pachiano@dayton.bassinc.com> wrote: }>Somehow some duplicate data "sneaked" into my database }>that should have a unique index constraint. Well, I have plugged the }>leaks, but now I am stuck with a database that I cannot re-index }>due to the duplicate data. }> }>How can I easily (AUTOMATED) remove the duplicate data? }> }>I can probably write some UNIX scripts to sort/sort -u, etc., but }>I was hoping there was a better way } }Its pretty simple if you have OL7 (I'm not sure of the other }versions). } }OL7 provides the facility to fiddle with the mode of your index. }Along with the the violations & diagnostic tables, this can be a very }safe way of fixing your data. What you'd have to do goes something }like this. <loads of good stuff snipped> WOW! Can someone tell me exactly which release of OnLine this first appeared in? (Still on 5.03 here, but could be useful for some ex-colleagues of mine). TIA, Richard.