Re: Error in Dbschema ????

I've had that problem on INFORMIX-SE 7.x /SCO without any solution from Informix Tech Support. That was registered as a bug, but they said that it was an specific problem of this combination (SE/SCO). Anyway the problem is not regarding about your data, is on the system catalogs instead. I haven't found a reliable solution to this problem, I have had to identify the table with the problem and then drop/recreate. :-( If you find a better solution, please let me know! Julio Cesar de Figueiredo wrote: } Hi All, } We have Informix OL 5.03 } HP-UX 9.03 } } and the error is: } dbschema -d dbnmame -t tabname } create ... } ( } ... } ); } ... } alter table ...; } } ISAM error: duplicate value for a record with unique key. } STOPED } I can't DROP that table! } There are no records on that table now! } WHAT IS HAPPENING HERE ????