Re: 511 error

On 19 Jun 1997, ic wrote: > I am trying to do an "alter index objdesc to cluster" in order to fix > sysobjstate in my database which is upto 200+ extents... > > How can I fix this? $finderr -511 You are not allowed to update, insert, or delete rows in this table. If you are absolutely sure that you must do so, you will have to sign on as user informix. That user account can modify most system catalog tables; however, this is a very risky practice that is not recommended unless specifically instructed by the Informix Technical Support Department. Have you tried this as Informix? Generally, we just modify the NEXT EXTENT of a system table right after database creation, rather than messing with them like this. If you do want to alter the indexes, you will have to be informix though. HTH.. -Richard