Doug Carter wrote:
Hi all,
When attempting to set integrity, I occasionally get a strange error:
SQL3603N Check data processing through the SET INTEGRITY statement has found integrity violation involving a constraint with name "FOO.TABLE_X.SQL021007103120890". SQLSTATE=23514
I'm running the command:
db2 SET INTEGRITY FOR FOO.TABLE_X IMMEDIATE CHECKED
I know this is not a lot of info to go on, but is there something
easy (obvious) to correct this problem?
If you use an exception table, the rows that violate the constraints will be moved to the exception table and can be handled easily.
Good luck, - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
