You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by rh...@apache.org on 2006/08/18 22:49:55 UTC
svn commit: r432721 [2/2] - in /db/derby/docs/branches/10.2/src: adminguide/
devguide/ pt_BR/ref/ ref/ tuning/
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">
<!--