db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1541105 - /db/derby/docs/branches/10.10/src/devguide/cdevspecial13670.dita
Date Tue, 12 Nov 2013 15:28:20 GMT
Author: chaase3
Date: Tue Nov 12 15:28:20 2013
New Revision: 1541105

URL: http://svn.apache.org/r1541105
Log:
DERBY-6379  Manuals are inconsistent in their use of the <shortdesc> element

Modified 1 Developer's Guide topic in 10.10 branch.

Patch: DERBY-6379-devguide-branch.diff

Modified:
    db/derby/docs/branches/10.10/src/devguide/cdevspecial13670.dita

Modified: db/derby/docs/branches/10.10/src/devguide/cdevspecial13670.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.10/src/devguide/cdevspecial13670.dita?rev=1541105&r1=1541104&r2=1541105&view=diff
==============================================================================
--- db/derby/docs/branches/10.10/src/devguide/cdevspecial13670.dita (original)
+++ db/derby/docs/branches/10.10/src/devguide/cdevspecial13670.dita Tue Nov 12 15:28:20 2013
@@ -20,24 +20,27 @@ limitations under the License.
 -->
 <reference id="cdevspecial13670" xml:lang="en-us">
 <title>Examples of trigger actions</title>
+<shortdesc>This section provides an example of a trigger.</shortdesc>
 <prolog><metadata>
 <keywords><indexterm>Triggers<indexterm>example of trigger actions</indexterm></indexterm>
 </keywords>
 </metadata></prolog>
 <refbody>
-<section><p>The following trigger action copies a row from the <i>flights</i>
table
-into the <i>flight_history</i> table whenever any row gets inserted into <i>flights</i>
and
-adds the comment "inserted from trig1" in the <i>status</i> column of
-the <i>flight_history</i> table.</p></section>
+<section><p>The following trigger action copies a row from the
+<codeph>flights</codeph> table into the <codeph>flight_history</codeph>
table
+whenever any row gets inserted into <codeph>flights</codeph> and adds the
+comment "inserted from trig1" in the <codeph>status</codeph> column of the
+<codeph>flight_history</codeph> table.</p></section>
 <example> <codeblock><b>CREATE TRIGGER trig1 
-AFTER UPDATE ON flights 
-REFERENCING OLD AS UPDATEDROW 
-FOR EACH ROW MODE DB2SQL 
-INSERT INTO flights_history 
-VALUES (UPDATEDROW.FLIGHT_ID, UPDATEDROW.SEGMENT_NUMBER,
-UPDATEDROW.ORIG_AIRPORT, UPDATEDROW.DEPART_TIME,
-UPDATED ROW.DEST_AIRPORT, UPDATEDROW.ARRIVE_TIME,
-UPDATEDROW.MEAL, UPDATEDROW.FLYING_TIME, UPDATEDROW.MILES,
-UPDATEDROW.AIRCRAFT,'INSERTED FROM trig1');</b></codeblock></example>
+  AFTER UPDATE ON flights 
+  REFERENCING OLD AS UPDATEDROW 
+  FOR EACH ROW
+  INSERT INTO flights_history 
+    VALUES (UPDATEDROW.FLIGHT_ID, UPDATEDROW.SEGMENT_NUMBER,
+            UPDATEDROW.ORIG_AIRPORT, UPDATEDROW.DEPART_TIME,
+            UPDATED ROW.DEST_AIRPORT, UPDATEDROW.ARRIVE_TIME,
+            UPDATEDROW.MEAL, UPDATEDROW.FLYING_TIME, UPDATEDROW.MILES,
+            UPDATEDROW.AIRCRAFT,'inserted from trig1');</b></codeblock>
+</example>
 </refbody>
 </reference>



Mime
View raw message