Re: Drop diagnostic/violation table
Sorry, found the solution short before you answerd by searching this list:
stop violations table for foo;
thx, Reinhard.
> -----Ursprüngliche Nachricht-----
> Von: informix-list-bounces@iiug.org
> [mailto:informix-list-bounces@iiug.org]Im Auftrag von Superboer
> Gesendet am: Montag, 19. Juni 2006 10:42
> An: informix-list@iiug.org
> Betreff: Re: Drop diagnostic/violation table
>
> what does dbschema -d <db> -t yourtable -ss
> tells you; i guess you have to enable constraints/indexes etc
> and
> stop violations for that table.
> this is/should be doc'd in the manual.
>
>
> Superboer.
>
>
> Habichtsberg, Reinhard schreef:
>
> > IDS 9.40FC4W2
> >
> > Trying to alter a table IDS generates the error:
> > -898 Cannot alter a table which has associated
> violations/diagnostics
> > tables.
> >
> > The user has tried to add, drop, or modify a column in a
> table that has
> > a violations and diagnostics table associated with it.
> >
> > Trying to drop the dia and vio tables with drop table
> foo.dia/foo.vio a new
> > error message appears:
> > -897 Cannot modify/drop a violations/diagnostics table.
> >
> > The user has tried to alter or drop a table that is serving as a
> > violations table or a diagnostics table for another table.
> >
> > I'm working as user informix and table owner is informix.
> >
> > Reading manuals didn't help so I have no clue what to do.
> >
> > Any help would be appreciated.
> > Reinhard.
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>