db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From be...@apache.org
Subject svn commit: r597605 - /db/derby/docs/trunk/src/ref/rrefsqlj89752.dita
Date Fri, 23 Nov 2007 09:01:29 GMT
Author: bernt
Date: Fri Nov 23 01:01:28 2007
New Revision: 597605

URL: http://svn.apache.org/viewvc?rev=597605&view=rev
Log:
DERBY-3220 <transition table or variable list> (ReferencingClause) in CREATE TRIGGER
statement not SQL compliant

Modified:
    db/derby/docs/trunk/src/ref/rrefsqlj89752.dita

Modified: db/derby/docs/trunk/src/ref/rrefsqlj89752.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj89752.dita?rev=597605&r1=597604&r2=597605&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj89752.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj89752.dita Fri Nov 23 01:01:28 2007
@@ -23,10 +23,15 @@
 <refbody>
 <example> <codeblock><b>REFERENCING
 {
-{ OLD | NEW } [ AS ] correlation-Name [ { OLD | NEW } [ AS ] correlation-Name ] | 
-{ OLD_TABLE | NEW_TABLE } [ AS ] Identifier [ { OLD_TABLE | NEW_TABLE }
-[AS] Identifier ] 
-}</b></codeblock></example>
+{ OLD | NEW } [ ROW ] [ AS ] correlation-Name [ { OLD | NEW } [ ROW ] [ AS ] correlation-Name
] | 
+{ OLD TABLE | NEW TABLE } [ AS ] Identifier [ { OLD TABLE | NEW TABLE } [AS] Identifier ]
 |
+{ OLD_TABLE | NEW_TABLE } [ AS ] Identifier [ { OLD_TABLE | NEW_TABLE } [AS] Identifier ]

+}</b></codeblock>
+<note>
+The <codeph><b>OLD_TABLE | NEW_TABLE</b></codeph> syntax is deprecated
since it 
+is not SQL compliant and is intended for backward compatibility and DB2 compatibility. 
+</note>
+</example>
 </refbody>
 </reference>
 



Mime
View raw message