Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1770

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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 10.0.2.2
    • 10.3.1.4
    • SQL
    • 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.

      Attachments

        Issue Links

          is part of

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-1953 Make FOR EACH clause and MODE DB2SQL in CREATE TRIGGER statement optional

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              yipng Yip Ng
              rhillegas Richard N. Hillegas
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: