db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1770) Make "mode db2sql" an optional phrase in the "create trigger" statement
Date Mon, 28 Aug 2006 17:56:22 GMT
Make "mode db2sql" an optional phrase in the "create trigger" statement

                 Key: DERBY-1770
                 URL: http://issues.apache.org/jira/browse/DERBY-1770
             Project: Derby
          Issue Type: Improvement
          Components: SQL
    Affects Versions:
            Reporter: Rick Hillegas

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

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

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message