1 Reply Latest reply: Apr 4, 2013 3:04 AM by Philip Stoyanov-Oracle RSS

    Delete Rules between Logical Model and Relational Model are different

    hayangae
      Relation Properties in Logical model has three Delete Rules: "RESTRICT", "NO_ACTION", "SET NULL".
      1. "RESTRICT" and "NO_ACTION" are same
      2. "CASCADE" is missing.

      However, Foreign Key Properties in Physical model has three Delete Rules: "RESTRICT", "NO_ACTION", "CASCADE".
      1. "RESTRICT" and "NO_ACTION" are same
      2. "SET NULL" is missing in this case.

      They are supposed to have "NO_ACTION or RESTRICT", "SET NULL", and "CASCADE".

      Please fix this ASAP. It is really annoying in Engineering process. Modeler creates duplicate wrong relationships while it engineers.

      Thanks.

      Edited by: hayangae on Oct 9, 2012 1:01 PM

      Edited by: hayangae on Apr 3, 2013 4:08 PM
        • 1. Re: Delete Rules between Logical Model and Relational Model are different
          Philip Stoyanov-Oracle
          Hi,

          it seems you are not using the latest version 3.3. In earlier versions - delete rule set on relationship was used only in some cases to set delete rule on related foreign key. Now delete rule is transferred to FK as it's defined on relationship.
          I assume you are using Oracle database - "Restrict" doesn't appear anymore for Oracle.
          2. "SET NULL" is missing in this case.
          Most likely the foreign key is set as mandatory thus you cannot use "set null" as option.
          Modeler creates duplicate wrong relationships while it engineers.
          Can you elaborate on that - example?

          Philip