Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: Deferred Constraint Checking

    Hello,

    I'm working with DB2 version 8.1 and I'm wondering if DB2 has deferred constraint checking. Deferred constraint checking is delaying checks on things such as not null columns, foreign keys, etc. until transaction commit time.

    The equivalent in Oracle would be:

    CREATE TABLE orders
    (ord_num NUMBER CONSTRAINT unq_num UNIQUE (ord_num)
    INITIALLY DEFERRED DEFERRABLE);

    Please let me know if DB2 has an equivalent.

    TIA
    Steve

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    No, DB2 does not defer constraint checking until commit time. DB2 has some deferred constraint checking using the load utility, but not what you are talking about.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •