Re: Error in Dbschema ????
Ing. Melvin Perez Cedano 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 ????
STUPID PROBE:
Please try this:
Using the root user, define your environment variables for Informix
access , you know INFORMIXDIR and PATH=$PATH:$INFORMIXDIR/bin and try
the dbschema command as root.
Sometime this function
Regards
Jpuente