Re: removing dups with HPL ??

That depends, is there a unique key? If not, how should one decide which to delete? If you can provide a rule, you can write an app or sometimes even a single query to remove the 'duplicates'; Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Mar 21, 2011 at 2:33 PM, Floyd Wellershaus <floyd@fwellers.com>wrote: > Is there a good way to remove duplicate records from a table while > unloading with hpl ? > > Thanks, > floyd > > > -- > Floyd Wellershaus > Dba/Sa Informix/Oracle/Linux/Aix > > http://photos.fwellers.com > ======================================================== > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >