Re: DBSCHEMA ERROR

I ran into the same problem. This is from Informix tech support. 1. Discover the tablename from dbschema. 2. In dbaccess, select tabid, tabname from systables where tabname = "tablename" Note the tabid. 3. select * from sysobjstate where tabid = [tabid from step 2]; Note index and contraint names. Run steps 4-7 for each index found. 4. select * from sysobjstate where name = "[index/constraint name]" We had two entries with different tabids. Note the bogus tabid. 5. select tabid, tabname from systables where tabid = [bogus tabid] We had "no rows found". Table does not exist. 6. delete from sysobjstate where name = "[index name]" and tabid = [bogus tabid] 7. select * from sysobjstate where name = "[index/constraint name]" just to check. Should only return 1 row. 8. Run dbschema for that table. It should work. "Eduardo MORALES" <ejmorale@apme-ops.dhl.com> on 02/03/2000 08:34:22 PM To: informix-list@iiug.org cc: (bcc: Kernoal Stephens/STS/AUTOZONE) Subject: DBSCHEMA ERROR Hi Gurus, I have this problem, when i run the "dbschema -d <dbname> -t <tabname>" i got this two errors for each table, 1. -284 - A subquery has returned not exactly one row. 2. 100 - ISAM error: duplicate value for a record with unique key. Can anyone give me an idea where/which systable should i look into. Regards, Jojo