Re: Can not alter table. Associated violation/diagnostic

The violations and diagnostic tables are created by the start violation table command. To remove association use the "stop violation table" command. Check the SQL manual for details Deepa Francisco Reyes > I was trying to change a table and got an error -898. "Can not alter > a table which has associated violation/diagnostic table". > > Tried the manual and the Informix errors explanation and could not > find anything about "violation/diagnostic tables". What are these? > > The table was just created and populated with the High Performance > Loader. I will drop the table and make a new one, but for a larger > table in the future this is not a viable option. > > Thanks. > > Remove "<No Spam>" to send me email.