db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r432721 [2/2] - in /db/derby/docs/branches/10.2/src: adminguide/ devguide/ pt_BR/ref/ ref/ tuning/
Date Fri, 18 Aug 2006 20:49:55 GMT
Modified: db/derby/docs/branches/10.2/src/ref/rrefsqlj43125.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.2/src/ref/rrefsqlj43125.dita?rev=432721&r1=432720&r2=432721&view=diff
==============================================================================
--- db/derby/docs/branches/10.2/src/ref/rrefsqlj43125.dita (original)
+++ db/derby/docs/branches/10.2/src/ref/rrefsqlj43125.dita Fri Aug 18 13:49:52 2006
@@ -1,4 +1,5 @@
 <?xml version="1.0" encoding="utf-8"?>
+ 
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
  "../dtd/reference.dtd">
 <!-- 
@@ -35,16 +36,16 @@
 event occurs on a specified table. A <i>database event</i> is a delete, insert,
 or update operation. For example, if you define a trigger for a delete on
 a particular table, the trigger's action occurs whenever someone deletes a
-row or rows from the table.</p> <p>Along with constraints, triggers can help
+row or rows from the table.</p><p>Along with constraints, triggers can help
 enforce data integrity rules with actions such as cascading deletes or updates.
 Triggers can also perform a variety of functions such as issuing alerts, updating
-other tables, sending e-mail, and other useful actions.</p> <p>You can define
+other tables, sending e-mail, and other useful actions.</p><p>You can define
 any number of triggers for a single table, including multiple triggers on
-the same table for the same event.</p> <p>You can create a trigger in any
-schema except one that starts with <i>SYS</i>. The trigger need not reside in
the same schema as
-the table on which it is defined.</p> <p>If a qualified trigger name is specified,
-the schema name cannot begin with <i>SYS</i>.</p></section>
-<refsyn id="syn001"><title>Syntax</title> <codeblock><b>CREATE
TRIGGER <i><xref
+the same table for the same event.</p><p>You can create a trigger in any schema
+except one that starts with <i>SYS</i>. The trigger need not reside in the
+same schema as the table on which it is defined.</p><p>If a qualified trigger
+name is specified, the schema name cannot begin with <i>SYS</i>.</p></section>
+<refsyn id="syn001"><title>Syntax</title><codeblock><b>CREATE
TRIGGER <i><xref
 href="rreftriggername.dita#rreftriggername">TriggerName</xref></i>
 { AFTER | NO CASCADE BEFORE } 
 { INSERT | DELETE | UPDATE } [ OF <i>column-Name</i> [, <i><xref href="rrefcolumnname.dita#rrefcolumnname">column-Name</xref></i>]*
]
@@ -76,11 +77,11 @@
 The triggered-SQL-statement might need to refer to the new (post-change or
 "after") values. </p> <p><ph conref="refconrefs.dita#prod/productshortname"></ph>
provides
 you with a number of ways to refer to data that is currently being changed
-by the database event that caused the trigger to fire. Changed data can be referred to in
the triggered-SQL-statement using <i>transition
-variables</i> or <i>transition tables</i>. The referencing clause allows
-you to provide a correlation name or alias for these transition variables
-by specifying OLD/NEW AS <i>correlation-Name </i>.</p> <p>For example,
if
-you add the following clause to the trigger definition:   <codeblock><b>REFERENCING
OLD AS DELETEDROW</b></codeblock></p> <p>you
+by the database event that caused the trigger to fire. Changed data can be
+referred to in the triggered-SQL-statement using <i>transition variables</i>
or <i>transition
+tables</i>. The referencing clause allows you to provide a correlation name
+or alias for these transition variables by specifying OLD/NEW AS <i>correlation-Name
</i>.</p> <p>For
+example, if you add the following clause to the trigger definition:   <codeblock><b>REFERENCING
OLD AS DELETEDROW</b></codeblock></p> <p>you
 can then refer to this correlation name in the triggered-SQL-statement:   <codeblock><b>DELETE
FROM HotelAvailability WHERE hotel_id = DELETEDROW.hotel_id</b
 ></codeblock></p> <p>The OLD and NEW transition variables map to a <i>java.sql.ResultSet</i>
with
 a single row.   <note>Only row triggers (see <xref href="rrefsqlj43125.dita#rrefsqlj43125/sqlj54276"></xref>)
@@ -127,10 +128,10 @@
 the trigger is defined.</li>
 <li>It must not commit or roll back the current transaction or change the
 isolation level.</li>
-<li>It must not execute a CALL statement.</li>
 <li>Before triggers cannot have INSERT, UPDATE or DELETE statements as their
 action.</li>
-</ul></p> <p>The triggered-SQL-statement can reference database objects
other
+<li>Before triggers cannot call procedures that modify SQL data as their action.</li>
+</ul></p><p>The triggered-SQL-statement can reference database objects
other
 than the table upon which the trigger is declared. If any of these database
 objects is dropped, the trigger is invalidated. If the trigger cannot be successfully
 recompiled upon the next execution, the invocation throws an exception and

Modified: db/derby/docs/branches/10.2/src/ref/rrefsqlj55788.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.2/src/ref/rrefsqlj55788.dita?rev=432721&r1=432720&r2=432721&view=diff
==============================================================================
--- db/derby/docs/branches/10.2/src/ref/rrefsqlj55788.dita (original)
+++ db/derby/docs/branches/10.2/src/ref/rrefsqlj55788.dita Fri Aug 18 13:49:52 2006
@@ -1,4 +1,7 @@
 <?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
 <!-- 
 Licensed to the Apache Software Foundation (ASF) under one or more
 contributor license agreements.  See the NOTICE file distributed with
@@ -15,18 +18,24 @@
 See the License for the specific language governing permissions and  
 limitations under the License.
 -->
-
-<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
 <reference id="rrefsqlj55788" xml:lang="en-us">
 <title>Standard built-in functions</title>
+<prolog><metadata>
+<keywords><indexterm>functions<indexterm>standard built-in, list of</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
 <refbody>
-<section> <ul>
+<section> <p>The standard built-in functions supported in Derby are as follows:</p><ul>
 <li><xref href="rrefsqlj98067.dita#rrefsqlj98067"></xref></li>
+<li><xref href="rreffuncacos.dita#rreffuncacos">ACOS</xref></li>
+<li><xref href="rreffuncasin.dita#rreffuncasin">ASIN</xref></li>
+<li><xref href="rreffuncatan.dita#rreffuncatan">ATAN</xref></li>
 <li><xref href="rrefbuiltbigint.dita#rrefbuiltbigint"></xref></li>
 <li><xref href="rrefsqlj33562.dita#rrefsqlj33562"></xref></li>
+<li><xref href="rreffuncceil.dita#rreffuncceil">CEIL or CEILING</xref></li>
 <li><xref href="rrefbuiltchar.dita#rrefbuiltchar"></xref></li>
 <li><xref href="rrefsqlj40899.dita#rrefsqlj40899"></xref></li>
+<li><xref href="rreffunccos.dita#rreffunccos">COS</xref></li>
 <li><xref href="rrefcasenullif.dita#rrefcasenullif"></xref></li>
 <li><xref href="rrefsqlj34177.dita#rrefsqlj34177"></xref></li>
 <li><xref href="rrefcurrentisolation.dita#rrefcurrentisolation"></xref></li>
@@ -35,23 +44,32 @@
 <li><xref href="rrefsqlj42324.dita#rrefsqlj42324"></xref></li>
 <li><xref href="rrefdatefunc.dita#rrefdatefunc"></xref></li>
 <li><xref href="rrefdayfunc.dita#rrefdayfunc"></xref></li>
+<li><xref href="rreffuncdegrees.dita#rreffuncdegrees">DEGREES</xref></li>
 <li><xref href="rrefbuiltdouble.dita#rrefbuiltdouble"></xref></li>
+<li><xref href="rreffuncexp.dita#rreffuncexp">EXP</xref></li>
+<li><xref href="rreffuncfloor.dita#rreffuncfloor">FLOOR</xref></li>
 <li><xref href="rrefhourfunc.dita#rrefhourfunc"></xref></li>
 <li><xref href="rrefidentityvallocal.dita#rrefidentityvallocal"></xref></li>
 <li><xref href="rrefbuiltinteger.dita#rrefbuiltinteger"></xref></li>
 <li><xref href="rrefsqlj16762.dita#rrefsqlj16762"></xref></li>
+<li><xref href="rreffunclog.dita#rreffunclog">LN or LOG</xref></li>
+<li><xref href="rreffunclog10.dita#rreffunclog10">LOG10</xref></li>
 <li><xref href="rrefsqlj61998.dita#rrefsqlj61998"></xref></li>
 <li><xref href="rrefsqlj42049.dita#rrefsqlj42049"></xref></li>
 <li><xref href="rrefsqlj97870.dita#rrefsqlj97870"></xref></li>
 <li><xref href="rrefminutefunc.dita#rrefminutefunc"></xref></li>
 <li><xref href="rrefsqljmod.dita#rrefsqljmod"></xref></li>
 <li><xref href="rrefmonthfunc.dita#rrefmonthfunc"></xref></li>
+<li><xref href="rreffuncpi.dita#rreffuncpi">PI</xref></li>
+<li><xref href="rreffuncradians.dita#rreffuncradians">RADIANS</xref></li>
 <li><xref href="rrefsqlj32613.dita#rrefsqlj32613"></xref></li>
 <li><xref href="rrefsecondfunc.dita#rrefsecondfunc"></xref></li>
 <li><xref href="rrefsqlj25228.dita#rrefsqlj25228"></xref></li>
+<li><xref href="rreffuncsin.dita#rreffuncsin">SIN</xref></li>
 <li><xref href="rrefbuiltsmallint.dita#rrefbuiltsmallint"></xref></li>
 <li><xref href="rrefsqlj73147.dita#rrefsqlj73147"></xref></li>
 <li><xref href="rrefsqlj93082.dita#rrefsqlj93082"></xref></li>
+<li><xref href="rreffunctan.dita#rreffunctan">TAN</xref></li>
 <li><xref href="rreftimefunc.dita#rreftimefunc"></xref></li>
 <li><xref href="rreftimestampfunc.dita#rreftimestampfunc"></xref></li>
 <li><xref href="rrefsqlj29930.dita#rrefsqlj29930.dita"></xref></li>
@@ -61,4 +79,3 @@
 </ul></section>
 </refbody>
 </reference>
-

Modified: db/derby/docs/branches/10.2/src/tuning/ctunproper22250.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.2/src/tuning/ctunproper22250.dita?rev=432721&r1=432720&r2=432721&view=diff
==============================================================================
--- db/derby/docs/branches/10.2/src/tuning/ctunproper22250.dita (original)
+++ db/derby/docs/branches/10.2/src/tuning/ctunproper22250.dita Fri Aug 18 13:49:52 2006
@@ -1,4 +1,5 @@
 <?xml version="1.0" encoding="utf-8"?>
+ 
 <!DOCTYPE concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
  "../dtd/concept.dtd">
 <!-- 
@@ -19,17 +20,23 @@
 -->
 <concept id="ctunproper22250" xml:lang="en-us">
 <title>Derby properties</title>
-<prolog></prolog>
+<shortdesc>The <ph conref="tunconrefs.dita#prod/productshortname"></ph>
properties
+are used for configuring the system and database, as well as for diagnostics
+such as logging statements, and monitoring and tracing locks.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm><indexterm>properties</indexterm>overview, Derby</indexterm>
+</keywords>
+</metadata></prolog>
 <conbody>
-<p>This chapter includes all the core <ph conref="tunconrefs.dita#prod/productshortname"></ph>
properties.
-  <note>When setting properties that have boolean values, be sure to trim
-extra spaces around the word <i>true</i>. Extra spaces around the word <i>true</i>
cause
+<p>This section includes all of the core <ph conref="tunconrefs.dita#prod/productshortname"></ph>
properties. <note>When
+setting properties that have boolean values, be sure to trim extra spaces
+around the word <i>true</i>. Extra spaces around the word <i>true</i>
cause
 the property to be set to false.</note></p>
 <p><xref href="ctunproper22250.dita#ctunproper22250/rtunproper24108"></xref>
summarizes
 the general <ph conref="tunconrefs.dita#prod/productshortname"></ph> properties.
-In that table, S stands for system-wide, D stands for database-wide, and C
+In this table, S stands for system-wide, D stands for database-wide, and C
 indicates the value persists with newly created conglomerates. X means yes.
-  <table pgwide="0" frame="all" id="rtunproper24108"><title>Derby properties</title>
+  <table frame="all" id="rtunproper24108" pgwide="0"><title>Derby properties</title>
 <tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="50*"/>
 <colspec colname="2" colnum="2" colwidth="12*"/><colspec colname="3" colnum="3"
 colwidth="38*"/>

Modified: db/derby/docs/branches/10.2/src/tuning/tuningderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.2/src/tuning/tuningderby.ditamap?rev=432721&r1=432720&r2=432721&view=diff
==============================================================================
--- db/derby/docs/branches/10.2/src/tuning/tuningderby.ditamap (original)
+++ db/derby/docs/branches/10.2/src/tuning/tuningderby.ditamap Fri Aug 18 13:49:52 2006
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="utf-8"?>
-<!--Arbortext, Inc., 1988-2005, v.4002-->
+ 
 <!DOCTYPE map PUBLIC "-//OASIS//DTD DITA Map//EN"
  "../dtd/map.dtd">
 <!-- 



Mime
View raw message