Re: Error in Dbschema ????
Thanks all for reply.
My solucion was to delete the records on systables,
sysreferences,sysconstraints
whenever that problematic table apear.
Then I update statistics and all is OK.
At 01:18 27/11/97 -0400, you wrote:
}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 ????
}
}
}
}
}