The SET INTEGRITY statement can be used to temporarily suspend constraint checking on a table. This statement can also be used to perform the following operations:
- Place one or more tables into the set integrity pending state
- Place one or more tables into the full access state
- Prune the contents of one of more staging tables
- Bring one or more tables out of a set integrity pending state by performing data validation via the constraint check
- Bring one or more tables out of a set integrity pending state without performing data validation
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
db2tester
5 years, 5 months agodb2tester
5 years, 5 months ago