Re: Index creation problem

Have you realy checked that ther is no such index. I mean run dbschema or used dbaccess (or was it isql at the time). If there is no such index you might have run across a bug in a product so old your only option is to upgrade. Before you do that you might want to try to dbexport your database, drop it and import it again just to make sure there is no inconsistency in the database. Running bcheck or tbcheck first might also be an idea. dllewell@dimensional.com (Daniel Llewellyn) wrote: : I have an interesting problem that I hope someone can help me with. : I am running Informix 4.10 on a SCO unix system and am having a :problem creating an index. : Two indexes already exist on the table: : Index 1 is a unique index on fields : 1,2,3,4, and 5 : Index 2 is a non unique index on fields : 4,2,1, and 5 : When I try to create on new index on fields : 2,3, and 5 : : I receive an error - 350 : Index already exists on column. : Any helpful suggestions as to why this is happening would be :greatly appreciated. : Daniel Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org