The SET INTEGRITY statement

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

The basic syntax for the SET INTEGRITY statement is:

SET INTEGRITY FOR [TableName] [OFF | FULL ACCESS | PRUNE] | [IMMEDIATE CHECKED | IMMEDIATE UNCHECKED] <AccessMode>

In the preceding ...

Get IBM Db2 11.1 Certification Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.