Re: dbexport and BYTE datatypes

In article <884532895.1164574730@dejanews.com>, pshankey@charlestoncounty.org writes >I can not answer your question, but I am also in the daeth roll with >onload and dbimport. It seems to be much more painful than the docs make >it out to be. Presently I am looking at an error of: ----- lots of stuff >------- hd_head05 char(132), hd_head06 char(132), primary key (hd_id) >constraint "bsi".hd_heads_mstr_p ) extent size 3065 next size 218 lock >mode row; revoke all on "bsi".hd_heads_mstr from "public"; > >*** load table *** >*** put loadcur >239 - Could not insert new row - duplicate value in a UNIQUE INDEX column. > >100 - ISAM error: duplicate value for a record with unique key. > >ifastest@/ifastestbackup> > >Not being a dba and knowing painfully little about sql I do not know what >to do about this error it appears to be a sql thing > > Correct. You have a corrupt table. The column hd_id should be unique but you have two rows in the table with the same value. You need to drop the pimrary key contraint and the unique index on the table. Then create a duplicate index on that column and run select *.hd_id from hd_heads_mstr group by hd_id having count(*) >1 delete the duplicate row, recreate the unique index and then primary key contraint. Finally dbimport again and dbexport. > >-------------------==== Posted via Deja News ====----------------------- > http://www.dejanews.com/ Search, Read, Post to Usenet -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care