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
================================================== ======

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 (AT) fwellers (DOT) com>wrote: