Derby
  1. Derby
  2. DERBY-1770

Make "mode db2sql" an optional phrase in the "create trigger" statement

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 10.0.2.2
    • Fix Version/s: 10.3.1.4
    • Component/s: SQL
    • Labels:
      None

      Description

      In order to declare a trigger, you have to include the phrase "mode db2sql". This phrase in non-ANSI--it does not turn up in the CREATE TRIGGER production from the ANSI spec, volume 2, section 11.39. It does turn up in the DB2 reference manual with the following explanation: "This clause is used to specify the mode of triggers. This is the only valid mode currently supported."

      This phrase should be made optional. This will strike a happy balance between our goals of supporting the ANSI syntax while still maintaining compatibility with previous versions of Derby.

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Yip Ng
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development