Generated indices for constraints are numbered and will not show up in
dbschema output as 'create index'. Instead they will show up as
constraints. Genrally their names start with space, followed by tabid,
underscore, and I forget the rest.

j.
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]On Behalf Of
mohitanchlia@gmail.com
Sent: Monday, June 18, 2007 8:26 PM
To: informix-list@iiug.org
Subject: Flaw in dbschema


I don't know why but when I count number of indexes generated by
dbschema for specific "database and owner" is different than the
number I get when I look at sysindexes table for specific "database
and owner".

All I can tell is they are 3 idexes off and all 3 indexes name that
wasn't generated by dbschema starts with number.

Could you please tell me why or how can I get these indexes.

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list