You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Bernt M. Johnsen (JIRA)" <de...@db.apache.org> on 2006/10/09 14:11:20 UTC
[jira] Assigned: (DERBY-1770) Make "mode db2sql" an optional phrase
in the "create trigger" statement
[ http://issues.apache.org/jira/browse/DERBY-1770?page=all ]
Bernt M. Johnsen reassigned DERBY-1770:
---------------------------------------
Assignee: Bernt M. Johnsen
> 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: 10.0.2.2
> 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 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.
--
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