How does the DEFERRABLE constraint affect the timing of constraint checking in DB2?

  • DEFERRABLE constraint enables the checking of constraint immediately after each DML statement.
  • DEFERRABLE constraint enforces the constraint during the execution of each DML statement.
  • DEFERRABLE constraint postpones the checking of constraint until the next COMMIT or ROLLBACK operation.
  • The DEFERRABLE constraint allows deferring the checking of constraint until the end of a transaction.
DEFERRABLE constraint in DB2 postpones the constraint checking until the next COMMIT or ROLLBACK operation, allowing flexibility in handling constraints within a transaction. This feature is particularly useful in scenarios where you need to temporarily violate constraints during the transaction and enforce them only at the end. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *