db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yip Ng (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1770) Make "mode db2sql" an optional phrase in the "create trigger" statement
Date Tue, 10 Oct 2006 18:43:20 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1770?page=comments#action_12441246 ] 
Yip Ng commented on DERBY-1770:

DERBY-1953 also addresses this jira case.

> 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
>         Assigned To: Bernt M. Johnsen
> 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 Derby.

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