RE: dbschema failed in IDS7.31.UD7
Miyaki
I've tried this on Aix 5 and 7.31 UD7 with no problems.
What other tables/columns do you have in the database, any
with the same names?
Have you run any oncheck against the system tables?
What was the dbschema syntax you used (I was successful with
dbschema -d database -t tableand
dbschema -ss -d database -t table
Keith
-> -----Original Message-----
-> From: miyaki [mailto:lcib@yahoo.com]
-> Sent: Monday, January 24, 2005 12:45 PM
-> To: informix-list@iiug.org
-> Subject: dbschema failed in IDS7.31.UD7
->
->
-> Hi all,
->
-> I'm having a problem with dbschema where it returns
-> ISAM error 100 after changing the table structure
-> (either add column or delete column). Does anyone
-> experience this problem before? Is it a known problem
-> in UD7? Any resolution?
->
-> OS = Solaris 2.7 x86 platform
-> IDS = 7.31.UD7
->
-> This is how I produce the error.
->
-> 1) Create a table
->
-> create table table1
-> (
-> item char(15),
-> fileid char(64),
-> userid char(10),
-> primary key (item) constraint "informix".pk_fileid
-> ) extent size 53 next size 16 lock mode row;
->
-> 2) Change table structure
->
-> alter table table1
-> add (align char(4) default "NONE" not null);
->
-> 3) run dbschema command to retrieve the schema. It
-> failed with the following error.
->
-> 100 - ISAM error: duplicate value for a record with
-> unique key.
->
-> TIA,
-> Miyaki
->
->
->
->
->
->
->
->
->
-> __________________________________
-> Do you Yahoo!?
-> Yahoo! Mail - now with 250MB free storage. Learn more.
-> http://info.mail.yahoo.com/mail_250
-> sending to informix-list
->
**********************************************************************************
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
**********************************************************************************
sending to informix-list