db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: for each row mode db2sql
Date Mon, 28 Aug 2006 17:48:32 GMT
Rick Hillegas wrote:
> In order to declare a Derby trigger, you need to include the phrase
> "mode db2sql". I can't find this phrase in the ANSI SQL spec--trigger
> declaration is described in volume 2, section 11.39. The phrase does
> turn up in the DB2 reference manual, where it has this explanation:
> "This clause is used to specify the mode of triggers. This is the only
> valid mode currently supported.".
> 
> I would like to strike some happy balance between our goals of
> supporting ANSI syntax and maintaining compatibility with previous
> releases of Derby. Is there any reason that this phrase should not be
> made optional?

+1

Since Derby triggers are (or strive to be...) standard compliant, the
"mode db2sql" should be optional. I was thinking of creating a Jira
issue of this one myself.


-- 
Bernt Marius Johnsen, Database Technology Group,
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

Mime
View raw message