Re[2]: DUPLICATE KEYS

Yes, the fields are the same. ______________________________ Reply Separator _________________________________ Subject: Re: DUPLICATE KEYS Author: inf_bb@hermes1.sps.mot.com (Bob Baskett) at emh_1-submepp Date: 10/25/94 12:38 PM that all depends: are the truely duplicate rows (every field the same)? if so, the unix solution would be to unload to a file and then sort -u the file and drop/create/reload/index that table. im sure there are sort routines for DOS if that is what you are using. if the rows are not truely unique, then what method would you use to weed out the extra rows??? > > > > Again, many thanks to those of you who came to my rescue for > a technique for finding the duplicate keys. I'd like to take > the problem a step further. I found that the file I'm > talking about has over 7k records with duplicate keys. Is > there a coding technique I could use to get rid of the dups > other than by the one'zies? > > > Many thanks in advance > > > e-mail: sheltra@emh-l.submepp.navy.mil > > -- regards, +----------------------------------------------------------------------------+ | . . | Bob Baskett | | ... ... | Software Engineer | | ..... ..... | Business Systems Integration Group | | .. ... .. | Semiconductor Products Sector | | . . . | Mesa, AZ | | | President, Informix Users Group Of Arizona | | Motorola, Inc. | | +----------------------------------------------------------------------------+ | Sun 690MP 4.1.3, Online 5.01, 4.10.UD1 Tools, Fourgen v4.10.UC1 | +----------------------------------------------------------------------------+