Re: Index creation problem

> 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. I'm swinging in the dark here, but have you tried creating your new index *before* creating Index 1? HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Junior Programmer / Director The West Solutions Group | +------------------------------------------------------------------------------+ | The Informix FAQ is at: http://www.iiug.org/techinfo/faq/faq_top.html | +------------------------------------------------------------------------------+ | .... oh, and Kerry, I see it's _still_ not at rtfm.mit.edu... :-) | +------------------------------------------------------------------------------+