dbexport failed
I am trying to export a database with dbexport and I am getting the
following error:
100- ISAM error: duplicate value for a record with unique key.
The index or constraint is not in the table listed last on the bottom of
the output file. How can I identify what table the error is in. I have
tried by the next higher tabid but that wasn't the problem
[posted and mailed]
Hi Don,
do you use Informix-SE ? There are some problems with unique-indexes,
primary keys and foreign keys and the tool 'isql'. Your entries in the
systables are damaged for a table. You have to drop the constaints on
the table and recreate them. Use the following order to be right :
1. create unique indexes
2. create primary keys for 1.
3. create indexes for columns to be referenced.
4. create foreign keys for 3.
HTH
Dirk
djohnson@usdl.com (don johnson) wrote in <94ks90$5ir$1@news.xmission.com>:
>
>I am trying to export a database with dbexport and I am getting the
>following error:
>
>100- ISAM error: duplicate value for a record with unique key.
>
>The index or constraint is not in the table listed last on the bottom of
>the output file. How can I identify what table the error is in. I have
>tried by the next higher tabid but that wasn't the problem
>