Re: Indexing troubles

It is very odd and has me baffled. I'm currently running the clustered index as a clustered index without the field j_status. I was unable to create the index with j_status either as clustered or not clustered. Given that the reported problem is indeed NOT the real problem, I'm wondering if anyone has seen a similar situation, perhaps corrupted indexes with similar names, etc. The identical schema has been installed in several other sites without this problem. We will probably try and rebuild the entire database again, this weekend and possibly a reinstall of informix. -- --------------------------------------------------------------------- Scott Holmes http://www.pacificnet.net/~sholmes sholmes@pacificnet.net Independent Programmer/Analyst Passport 4GL HTML Composer Informix 4GL, SQL --------------------------------------------------------------------- There are more things in heaven and earth, Horatio, than are dreamt of in your philosophy ---------------------------------------------------------------------