Re: dbexport problem

If you legitimately feel that duplicates are the problem or are just curious you could search for them with the following SQL: select column_name[s], count(*) from table_name group by column_name[s] having count(*) > 1 where column_name[s] is/are the name[s] of the column[s] in your unique index [separated by commas -- col1, col2,....]. gp@nospam-mabltd.com wrote: > Hi all, > > I am relatively new to informix. > > I need to (db)export a database from a machine (sco/informix 6) and > (db)import it on > > another (linux/informix 7). dbexport fails on the first machine > saying "100 -ISAM error - ...". > > It looks that an unique index contain duplicate values (I cannot figure > out how this > > could be possible). I tried a lot to make the export work (I ran secheck) > but I was unable to > > export the database. I searched the Internet but found > nothing. There is anybody that encountered this > > problem and can suggest a solution ? > > Thanks > > Giampaolo Gallo -- Carlos Benjamin, Jr. x 2364 mailto:inf999@cap-az.com