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.
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.>
Reinhard Habichtsberg 19 June 2006 12:53:47 [ permanent link ]
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.> >
If you would like to report an abuse of our service, such as a spam message, please . Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .
