Author: fuzzylogic
Date: Thu Apr 7 16:08:41 2005
New Revision: 160492
URL: http://svn.apache.org/viewcvs?view=rev&rev=160492
Log:
DERBY-200: changes to docs to support DITA toolkit 1.0.1
Committed for Jeff Levitt <derby@mylevita.com> and
Scott Hutinger <s-hutinger@wiu.edu>
Modified:
incubator/derby/docs/trunk/docs.properties
incubator/derby/docs/trunk/src/adminguide/radminconsist24642.dita
incubator/derby/docs/trunk/src/devguide/cdevconcepts15366.dita
incubator/derby/docs/trunk/src/devguide/cdevdvlp40724.dita
incubator/derby/docs/trunk/src/devguide/rdevconcepts2462.dita
incubator/derby/docs/trunk/src/devguide/rdevconcepts713.dita
incubator/derby/docs/trunk/src/devguide/rdevcsecure190.dita
incubator/derby/docs/trunk/src/devguide/rdevcsecure557.dita
incubator/derby/docs/trunk/src/ref/rrefdeclaretemptable.dita
incubator/derby/docs/trunk/src/ref/rrefjavsqlprst.dita
incubator/derby/docs/trunk/src/ref/rrefjdbc20377.dita
incubator/derby/docs/trunk/src/ref/rrefjdbc29973.dita
incubator/derby/docs/trunk/src/ref/rrefsql9241891.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj1083019.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj19433.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj21571.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj23075.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj24513.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj25228.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj29840.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj33923.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj42324.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj42476.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj43125.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita
incubator/derby/docs/trunk/src/tools/ctools1004764.dita
incubator/derby/docs/trunk/src/tools/ctoolsijtools16011.dita
incubator/derby/docs/trunk/src/tools/rtoolsdrvrnmeurl.dita
incubator/derby/docs/trunk/src/tools/rtoolsijcomref17631.dita
incubator/derby/docs/trunk/src/tools/rtoolsijcomref20382.dita
incubator/derby/docs/trunk/src/tools/rtoolsijcomref30679.dita
incubator/derby/docs/trunk/src/tools/rtoolsijcomref33358.dita
incubator/derby/docs/trunk/src/tools/rtoolsijcomref37862.dita
incubator/derby/docs/trunk/src/tools/rtoolsijcomref39042.dita
incubator/derby/docs/trunk/src/tools/rtoolsijpropref97949.dita
incubator/derby/docs/trunk/src/tools/ttoolsij11815.dita
incubator/derby/docs/trunk/src/tuning/ctundepth32379.dita
incubator/derby/docs/trunk/src/tuning/ctunperf98197.dita
incubator/derby/docs/trunk/src/tuning/ctunproper22250.dita
incubator/derby/docs/trunk/src/tuning/ctunstats52657.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform13966.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform16279.dita
incubator/derby/docs/trunk/src/tuning/ctuntransform867201.dita
incubator/derby/docs/trunk/src/tuning/rtunproper81359.dita
Modified: incubator/derby/docs/trunk/docs.properties
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/docs.properties?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/docs.properties (original)
+++ incubator/derby/docs/trunk/docs.properties Thu Apr 7 16:08:41 2005
@@ -1,4 +1,4 @@
-dita.dir=${basedir}/DITA-OT1.0
+dita.dir=${basedir}/DITA-OT1.0.1
dita.script.dir=${dita.dir}/xsl
dita.dtd.dir=${dita.dir}/dtd
dita.css.dir=${dita.dir}/css
Modified: incubator/derby/docs/trunk/src/adminguide/radminconsist24642.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/adminguide/radminconsist24642.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/adminguide/radminconsist24642.dita (original)
+++ incubator/derby/docs/trunk/src/adminguide/radminconsist24642.dita Thu Apr 7 16:08:41 2005
@@ -27,16 +27,16 @@
<section><p>This section provides examples that illustrate how to use <i>SYSCS_UTIL.SYSCS_CHECK_TABLE() </i> in
queries.</p></section>
<section><p>Check the consistency of a single table:</p></section>
-<example> <codeblock><b>VALUES SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'FLIGHTS')</b></codeblock></example>
+<example><codeblock><b>VALUES SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'FLIGHTS')</b></codeblock></example>
<section><p>Check the consistency of all of the tables in a schema, stopping
at the first failure: </p></section>
-<example> <codeblock><b>SELECT tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(
+<example><codeblock><b>SELECT tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(
'SAMP', tablename)
FROM sys.sysschemas s, sys.systables t
WHERE s.schemaname = 'SAMP' AND s.schemaid = t.schemaid</b></codeblock></example>
<section><p>Check the consistency of an entire database, stopping at the first
failure:</p></section>
-<example> <codeblock><b>SELECT schemaname, tablename,
+<example><codeblock><b>SELECT schemaname, tablename,
SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname, tablename)
FROM sys.sysschemas s, sys.systables t
WHERE s.schemaid = t.schemaid</b></codeblock></example>
Modified: incubator/derby/docs/trunk/src/devguide/cdevconcepts15366.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/devguide/cdevconcepts15366.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/devguide/cdevconcepts15366.dita (original)
+++ incubator/derby/docs/trunk/src/devguide/cdevconcepts15366.dita Thu Apr 7 16:08:41 2005
@@ -87,7 +87,7 @@
</tgroup>
</table>
<p>These levels allow you to avoid particular kinds of transaction anomalies,
-which are described in <xref href="#cdevconcepts15366/cdevconcepts17741"></xref>.</p>
+which are described in <xref href="cdevconcepts15366.dita#cdevconcepts15366/cdevconcepts17741"></xref>.</p>
<table frame="all" id="cdevconcepts17741"><title>Transaction Anomalies</title>
<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="48*"/>
<colspec colname="2" colnum="2" colwidth="51*"/>
@@ -138,7 +138,7 @@
schema might also affect whether these anomalies are allowed. A DBMS can lock
either the entire table or only specific rows in order to prevent transaction
anomalies.</p>
-<p><xref href="#cdevconcepts15366/cdevconcepts28076"></xref> shows which anomalies
+<p><xref href="cdevconcepts15366.dita#cdevconcepts15366/cdevconcepts28076"></xref> shows which anomalies
are possible under the various locking schemas and isolation levels.</p>
<table frame="all" id="cdevconcepts28076"><title>When Transaction Anomalies
Are Possible</title>
@@ -183,7 +183,7 @@
that <ph conref="devconrefs.dita#prod/productshortname"></ph> treats the transactions
as if they occurred serially (one after the other) instead of concurrently. <ph
conref="devconrefs.dita#prod/productshortname"></ph> issues locks to prevent
-all the transaction anomalies listed in <xref href="#cdevconcepts15366/cdevconcepts17741"></xref> from
+all the transaction anomalies listed in <xref href="cdevconcepts15366.dita#cdevconcepts15366/cdevconcepts17741"></xref> from
occurring. The type of lock it issues is sometimes called a <i>range lock</i>.
For more information about range locks, see <xref href="rdevconcepts8424.dita#rdevconcepts8424"></xref>.</p></li>
<li><codeph>TRANSACTION_REPEATABLE_READ</codeph> <p><codeph>RS</codeph> from
Modified: incubator/derby/docs/trunk/src/devguide/cdevdvlp40724.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/devguide/cdevdvlp40724.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/devguide/cdevdvlp40724.dita (original)
+++ incubator/derby/docs/trunk/src/devguide/cdevdvlp40724.dita Thu Apr 7 16:08:41 2005
@@ -34,7 +34,7 @@
<p>A <ph conref="devconrefs.dita#prod/productshortname"></ph> database is
stored in files that live in a directory of the same name as the database.
Database directories typically live in <i>system</i> directories.</p>
-<p>A database directory contains the following, as shown in <xref href="#cdevdvlp40724/rdevdvlp31476"></xref>:</p>
+<p>A database directory contains the following, as shown in <xref href="cdevdvlp40724.dita#cdevdvlp40724/rdevdvlp31476"></xref>:</p>
<ul>
<li><i>log</i> directory <p>Contains files that make up the database transaction
log, used internally for data recovery (not the same thing as the error log).</p></li>
Modified: incubator/derby/docs/trunk/src/devguide/rdevconcepts2462.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/devguide/rdevconcepts2462.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/devguide/rdevconcepts2462.dita (original)
+++ incubator/derby/docs/trunk/src/devguide/rdevconcepts2462.dita Thu Apr 7 16:08:41 2005
@@ -20,7 +20,7 @@
<prolog>
</prolog>
<refbody>
-<section><p><xref href="#rdevconcepts2462/cdevconceptslock_mtrx"/> lists compatibility between lock types. <cite>+</cite> means compatible, <cite>-</cite> means incompatible.</p></section>
+<section><p><xref href="rdevconcepts2462.dita#rdevconcepts2462/cdevconceptslock_mtrx"/> lists compatibility between lock types. <cite>+</cite> means compatible, <cite>-</cite> means incompatible.</p></section>
<table id="cdevconceptslock_mtrx" frame="all">
<title>Lock Compatibility Matrix</title>
<tgroup cols="4" colsep="1" rowsep="1">
Modified: incubator/derby/docs/trunk/src/devguide/rdevconcepts713.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/devguide/rdevconcepts713.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/devguide/rdevconcepts713.dita (original)
+++ incubator/derby/docs/trunk/src/devguide/rdevconcepts713.dita Thu Apr 7 16:08:41 2005
@@ -36,7 +36,7 @@
<li>A single application has more than one <i>Connection</i> to
the same database.
<p>The way you deploy <ph conref="devconrefs.dita#prod/productshortname"></ph> affects the ways applications
-can use multi-threading and connections, as shown in <xref href="#rdevconcepts713/cdevconcepts40343"/>.</p>
+can use multi-threading and connections, as shown in <xref href="rdevconcepts713.dita#rdevconcepts713/cdevconcepts40343"/>.</p>
<table id="cdevconcepts40343" frame="all">
<title>Threading and
Connection Modes</title>
Modified: incubator/derby/docs/trunk/src/devguide/rdevcsecure190.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/devguide/rdevcsecure190.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/devguide/rdevcsecure190.dita (original)
+++ incubator/derby/docs/trunk/src/devguide/rdevcsecure190.dita Thu Apr 7 16:08:41 2005
@@ -26,7 +26,7 @@
</metadata>
</prolog>
<refbody>
-<section><p><xref href="#rdevcsecure190/cdevcsecure20486"/> shows which actions read-only
+<section><p><xref href="rdevcsecure190.dita#rdevcsecure190/cdevcsecure20486"/> shows which actions read-only
and full-access users are permitted to perform on regular or source databases
and on target databases.</p></section>
<table id="cdevcsecure20486" frame="all">
Modified: incubator/derby/docs/trunk/src/devguide/rdevcsecure557.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/devguide/rdevcsecure557.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/devguide/rdevcsecure557.dita (original)
+++ incubator/derby/docs/trunk/src/devguide/rdevcsecure557.dita Thu Apr 7 16:08:41 2005
@@ -20,7 +20,7 @@
<reference id="rdevcsecure557" xml:lang="en-us">
<title>List of user-authentication properties</title>
<refbody>
-<section><p><xref href="#rdevcsecure557/cdevcsecure27690"></xref> summarizes
+<section><p><xref href="rdevcsecure557.dita#rdevcsecure557/cdevcsecure27690"></xref> summarizes
the various properties related to user authentication.</p></section>
<table frame="all" id="cdevcsecure27690"><title>User Authentication Properties</title>
<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="53*"/>
Modified: incubator/derby/docs/trunk/src/ref/rrefdeclaretemptable.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefdeclaretemptable.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefdeclaretemptable.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefdeclaretemptable.dita Thu Apr 7 16:08:41 2005
@@ -40,7 +40,7 @@
system catalog.</li>
</ul></p></section>
<section><title>Syntax</title>
-<codeblock><b>DECLARE GLOBAL TEMPORARY TABLE <i><xref href="#rrefdeclaretemptable/tempcoltablename">table-Name</xref></i>
+<codeblock><b>DECLARE GLOBAL TEMPORARY TABLE <i><xref href="rrefdeclaretemptable.dita#rrefdeclaretemptable/tempcoltablename">table-Name</xref></i>
{ column-definition [ , column-definition ] * }
[ ON COMMIT {DELETE | PRESERVE} ROWS ]
NOT LOGGED [ON ROLLBACK DELETE ROWS]
Modified: incubator/derby/docs/trunk/src/ref/rrefjavsqlprst.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefjavsqlprst.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefjavsqlprst.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefjavsqlprst.dita Thu Apr 7 16:08:41 2005
@@ -46,7 +46,7 @@
be either a standard Java stream object or the user's own subclass that implements
the standard <i>java.io.InputStream</i> interface.</p></section>
<section><p>According to the JDBC standard, streams can be stored only in
-columns of the data types shown in <xref href="#rrefjavsqlprst/jdbc25312"></xref>.
+columns of the data types shown in <xref href="rrefjavsqlprst.dita#rrefjavsqlprst/jdbc25312"></xref>.
Streams cannot be stored in columns of the other built-in data types or of
user-defined data types. <table colsep="0" frame="none" id="jdbc25312" rowsep="0">
<title>Streamable JDBC Data Types</title>
Modified: incubator/derby/docs/trunk/src/ref/rrefjdbc20377.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefjdbc20377.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefjdbc20377.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefjdbc20377.dita Thu Apr 7 16:08:41 2005
@@ -26,7 +26,7 @@
</keywords>
</metadata></prolog>
<refbody>
-<section><p><xref href="#rrefjdbc20377/jdbc31241"></xref> shows the mapping of <i>java.sql.Types</i> to
+<section><p><xref href="rrefjdbc20377.dita#rrefjdbc20377/jdbc31241"></xref> shows the mapping of <i>java.sql.Types</i> to
SQL types. <table frame="all" id="jdbc31241"><title>Mapping of java.sql.Types
to SQL Types</title>
<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="30*"/>
@@ -47,7 +47,7 @@
<entry colname="2">CHAR FOR BIT DATA</entry>
</row>
<row>
-<entry colname="1">BIT<sup><xref href="#rrefjdbc20377/chdhcccj">1</xref></sup></entry>
+<entry colname="1">BIT<sup><xref href="rrefjdbc20377.dita#rrefjdbc20377/chdhcccj">1</xref></sup></entry>
<entry colname="2">CHAR FOR BIT DATA</entry>
</row>
<row>
@@ -77,7 +77,7 @@
<row>
<entry colname="1">FLOAT<indexterm>FLOAT data type<indexterm>java.sql type
converted to DOUBLE PRECISION when retrieved</indexterm></indexterm></entry>
-<entry colname="2">DOUBLE PRECISION<sup><xref href="#rrefjdbc20377/chdbdbhh">2</xref></sup></entry>
+<entry colname="2">DOUBLE PRECISION<sup><xref href="rrefjdbc20377.dita#rrefjdbc20377/chdbdbhh">2</xref></sup></entry>
</row>
<row>
<entry colname="1">INTEGER</entry>
Modified: incubator/derby/docs/trunk/src/ref/rrefjdbc29973.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefjdbc29973.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefjdbc29973.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefjdbc29973.dita Thu Apr 7 16:08:41 2005
@@ -32,7 +32,7 @@
href="#rrefjdbc29973/jdbc10841">Class.forName("org.apache.derby.jdbc.EmbeddedDriver")</xref>,</i> except
that it requires the class to be found when the code is compiled.</p></li>
<li><i>Class c = org.apache.derby.jdbc.EmbeddedDriver.class</i> <p>This
-is also the same as <i><xref href="#rrefjdbc29973/jdbc10841">Class.forName("org.apache.derby.jdbc.EmbeddedDriver")</xref>,</i> except
+is also the same as <i><xref href="rrefjdbc29973.dita#rrefjdbc29973/jdbc10841">Class.forName("org.apache.derby.jdbc.EmbeddedDriver")</xref>,</i> except
that it requires the class to be found when the code is compiled. The pseudo-static
field <i>class</i> evaluates to the class that is named.</p></li>
<li><i>Setting the System property jdbc.drivers<ph><indexterm>JDBC driver<indexterm>loading</indexterm></indexterm></ph><ph><indexterm>jdbc.drivers
Modified: incubator/derby/docs/trunk/src/ref/rrefsql9241891.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsql9241891.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsql9241891.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsql9241891.dita Thu Apr 7 16:08:41 2005
@@ -25,7 +25,7 @@
not supported by Derby</indexterm></indexterm></keywords>
</metadata></prolog>
<refbody>
-<section><p><xref href="#rrefsql9241891/sql921038347"></xref> shows the SQL-92
+<section><p><xref href="rrefsql9241891.dita#rrefsql9241891/sql921038347"></xref> shows the SQL-92
features that <ph conref="refconrefs.dita#prod/productshortname"></ph> supports.
There are four levels of SQL-92 support: <ul>
<li>SQL92E <p>Entry</p></li>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj1083019.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj1083019.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj1083019.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj1083019.dita Thu Apr 7 16:08:41 2005
@@ -36,7 +36,7 @@
parameters in the list. <codeblock><b>WHERE ? NOT IN (?, ?, 'Santiago')
<ph>-- types assumed to be CHAR</ph></b></codeblock></li>
<li>Use in the values list in an IN predicate is allowed if the first operand
-is not a dynamic parameter or its type was determined in rule <xref href="#rrefsqlj1083019/sqlj30695"></xref>.
+is not a dynamic parameter or its type was determined in rule <xref href="rrefsqlj1083019.dita#rrefsqlj1083019/sqlj30695"></xref>.
Type of the dynamic parameters appearing in the values list is assumed to
be the type of the left operand. <codeblock><b>WHERE <b><i>FloatColumn</i></b> IN (?, ?, ?)
<ph>-- types assumed to be FLOAT</ph></b></codeblock></li>
@@ -79,7 +79,7 @@
list of an INSERT statement. The type of the dynamic parameter is assumed
to be the type of the target column. A ? parameter is not allowed by itself
in any select list, including the select list of a subquery, unless there
-is a corresponding column in a UNION (see no. <xref href="#rrefsqlj1083019/sqlj20756"></xref>,
+is a corresponding column in a UNION (see no. <xref href="rrefsqlj1083019.dita#rrefsqlj1083019/sqlj20756"></xref>,
below) that is not dynamic. <codeblock><b>INSERT INTO t VALUES (?)
<ph>-- dynamic parameter assumed to be the type
-- of the only column in table t</ph>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj19433.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj19433.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj19433.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj19433.dita Thu Apr 7 16:08:41 2005
@@ -24,7 +24,7 @@
or a term for a specific kind of expression such as <i>TableSubquery</i>.
Expressions are allowed in these specified places within statements. Some
locations allow only a specific type of expression or one with a specific
-property. <xref href="#rrefsqlj19433/sqlj18370"></xref>, lists all the possible
+property. <xref href="rrefsqlj19433.dita#rrefsqlj19433/sqlj18370"></xref>, lists all the possible
SQL expressions and indicates where they are allowed.</p></section>
<section><p>If not otherwise specified, an expression is permitted anywhere
the word <i>Expression</i> appears in the syntax. This includes: <ul>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj21571.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj21571.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj21571.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj21571.dita Thu Apr 7 16:08:41 2005
@@ -23,8 +23,8 @@
<section> <p>A query creates a virtual table based on existing tables or constants
built into tables.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>{
- ( <i><xref href="#rrefsqlj21571"></xref></i> ) |
-<i> <xref href="#rrefsqlj21571"></xref></i> UNION [ALL] <i><xref href="#rrefsqlj21571"></xref></i> |
+ ( <i>Query</i> ) |
+<i> Query</i> UNION [ALL] <i>Query</i> |
<i> <xref href="rrefselectexpression.dita#rrefselectexpression"></xref></i>
<i> </i><xref href="rrefsqlj11277.dita#rrefsqlj11277"></xref>
}</b></codeblock> <p><indexterm>UNION</indexterm><indexterm>UNION ALL</indexterm>You
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj23075.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj23075.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj23075.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj23075.dita Thu Apr 7 16:08:41 2005
@@ -29,7 +29,7 @@
Boolean expressions in a WHERE clause have a highly liberal syntax; see <xref
href="rrefsqlj33602.dita#rrefsqlj33602"></xref>, for example.</p></section>
<section><p>A boolean expression can include a boolean operator or operators.
-These are listed in <xref href="#rrefsqlj23075/sqlj34517"></xref>. <table expanse="page"
+These are listed in <xref href="rrefsqlj23075.dita#rrefsqlj23075/sqlj34517"></xref>. <table expanse="page"
frame="all" id="sqlj34517"><title><ph><indexterm>Boolean operators<indexterm>part
of WHERE clause</indexterm></indexterm></ph>SQL Boolean Operators</title>
<tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="24*"/>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj24513.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj24513.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj24513.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj24513.dita Thu Apr 7 16:08:41 2005
@@ -30,7 +30,7 @@
see <xref href="rrefsqlj13590.dita#rrefsqlj13590"></xref>.</p> <p>You can
specify a default value for a column. A default value is the value to be inserted
into a column if no other value is specified. If not explicitly specified,
-the default value of a column is NULL. See <xref href="#rrefsqlj24513/sqlj64478"></xref>.</p> <p>You
+the default value of a column is NULL. See <xref href="rrefsqlj24513.dita#rrefsqlj24513/sqlj64478"></xref>.</p> <p>You
can specify storage properties such as page size for a table by calling the <codeph>SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY</codeph> system
procedure.</p> <p>If a qualified table name is specified, the schema name
cannot begin with <i>SYS</i>.</p></section>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj25228.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj25228.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj25228.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj25228.dita Thu Apr 7 16:08:41 2005
@@ -26,7 +26,7 @@
<section> <p>SESSION_USER returns the authorization identifier or name of
the current user. If there is no current user, it returns <i>APP.</i></p> <p><xref
href="rrefsqlj42476.dita#rrefsqlj42476"></xref>, <xref href="rrefsqlj42324.dita#rrefsqlj42324"></xref>,
-and <xref href="#rrefsqlj25228"></xref> are synonyms.</p></section>
+and SESSION_USER are synonyms.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>SESSION_USER</b></codeblock> </refsyn>
<example> <codeblock><b>VALUES SESSION_USER</b></codeblock> </example>
</refbody>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj29840.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj29840.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj29840.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj29840.dita Thu Apr 7 16:08:41 2005
@@ -29,7 +29,7 @@
joins between two tables. (You can also perform a join between two tables
using an explicit equality test in a WHERE clause, such as "WHERE t1.col1
= t2.col2".)</p></section>
-<refsyn><title>Syntax</title> <codeblock><b><i><xref href="#rrefsqlj29840"></xref></i></b></codeblock> <p>The
+<refsyn><title>Syntax</title> <codeblock><b><i>JOIN Operation</i></b></codeblock> <p>The
JOIN operations are: <ul>
<li><xref href="rrefsqlj35034.dita#rrefsqlj35034"></xref> <p>Specifies a join between
two tables with an explicit join clause. See <xref href="rrefsqlj35034.dita#rrefsqlj35034"></xref>.</p></li>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj33923.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj33923.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj33923.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj33923.dita Thu Apr 7 16:08:41 2005
@@ -29,7 +29,7 @@
over a set of values as well as count rows. You can also create your own aggregates
to perform other set functions such as calculating the standard deviation.</p></section>
<section><p><indexterm>Aggregates<indexterm>and data types</indexterm></indexterm>The
-built-in aggregates can operate on the data types shown in <xref href="#rrefsqlj33923/sqlj92398"></xref>.
+built-in aggregates can operate on the data types shown in <xref href="rrefsqlj33923.dita#rrefsqlj33923/sqlj92398"></xref>.
<table frame="all" id="sqlj92398"><title>Permitted Data Types for Built-in
Aggregates</title>
<tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="20*"/>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj42324.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj42324.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj42324.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj42324.dita Thu Apr 7 16:08:41 2005
@@ -25,8 +25,7 @@
<refbody>
<section> <p>CURRENT_USER returns the authorization identifier of the current
user (the name of the user passed in when the user connected to the database).
-If there is no current user, it returns <i>APP.</i></p> <p><xref href="rrefsqlj42476.dita#rrefsqlj42476"></xref>, <xref
-href="#rrefsqlj42324"></xref>, and <xref href="rrefsqlj25228.dita#rrefsqlj25228"></xref> are
+If there is no current user, it returns <i>APP.</i></p> <p><xref href="rrefsqlj42476.dita#rrefsqlj42476"></xref> and <xref href="rrefsqlj25228.dita#rrefsqlj25228"></xref> are
synonyms.</p> <p>These functions return a string of up to 128 characters.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>CURRENT_USER</b></codeblock> </refsyn>
<example> <codeblock><b>VALUES CURRENT_USER</b></codeblock> </example>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj42476.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj42476.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj42476.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj42476.dita Thu Apr 7 16:08:41 2005
@@ -24,8 +24,7 @@
</metadata></prolog>
<refbody>
<section> <p>USER returns the authorization identifier or name of the current
-user. If there is no current user, it returns <i>APP.</i></p><p><xref
-href="#rrefsqlj42476"></xref>, <xref href="rrefsqlj42324.dita#rrefsqlj42324"></xref>,
+user. If there is no current user, it returns <i>APP.</i></p><p>USER, <xref href="rrefsqlj42324.dita#rrefsqlj42324"></xref>,
and <xref href="rrefsqlj25228.dita#rrefsqlj25228"></xref> are synonyms.</p></section>
<refsyn><title>Syntax</title><codeblock><b>USER</b></codeblock> </refsyn>
<example> <codeblock><b>VALUES USER</b></codeblock> </example>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj43125.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj43125.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj43125.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj43125.dita Thu Apr 7 16:08:41 2005
@@ -44,15 +44,15 @@
ON <i><xref href="rreftablename.dita#rreftablename"></xref></i>
[ <i><xref href="rrefsqlj89752.dita#rrefsqlj89752"></xref></i> ]
FOR EACH { ROW | STATEMENT } MODE DB2SQL
-<i><xref href="#rrefsqlj43125/i1149821">Triggered-SQL-statement</xref></i></b></codeblock> </refsyn>
+<i><xref href="rrefsqlj43125.dita#rrefsqlj43125/i1149821">Triggered-SQL-statement</xref></i></b></codeblock> </refsyn>
<section><title>Before or after: when triggers fire</title> <p><indexterm>Triggers<indexterm>defining
when they fire</indexterm></indexterm>Triggers fire after all constraints
have been satisfied and after the changes have been applied to the target
table. Also called <i>After</i> triggers, they can be either row or statement
-triggers (see <xref href="#rrefsqlj43125/sqlj54276"></xref>).</p> </section>
+triggers (see <xref href="rrefsqlj43125.dita#rrefsqlj43125/sqlj54276"></xref>).</p> </section>
<section><title>Insert, delete, or update: what causes the trigger to fire</title> <p><indexterm>Triggers<indexterm>and
database events</indexterm></indexterm>A trigger is fired by one of the following
-database events, depending on how you define it (in <xref href="#rrefsqlj43125/syn001"></xref> above,
+database events, depending on how you define it (in <xref href="rrefsqlj43125.dita#rrefsqlj43125/syn001"></xref> above,
see the third line): <ul>
<li>INSERT</li>
<li>UPDATE</li>
@@ -74,7 +74,7 @@
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/sqlj54276"></xref>)
+a single row. <note>Only row triggers (see <xref href="rrefsqlj43125.dita#rrefsqlj43125/sqlj54276"></xref>)
can use the transition variables. INSERT row triggers cannot reference an
OLD row. DELETE row triggers cannot reference a NEW row.</note></p> <p>For
statement triggers, transition <i>tables</i> serve as a table identifier for
@@ -87,7 +87,7 @@
(SELECT hotel_id FROM DeletedHotels)</b></codeblock></p> <p>The old and
new transition tables map to a <i>java.sql.ResultSet</i> with cardinality
equivalent to the number of rows affected by the triggering event. <note>Only
-statement triggers (see <xref href="#rrefsqlj43125/sqlj54276"></xref>) can use
+statement triggers (see <xref href="rrefsqlj43125.dita#rrefsqlj43125/sqlj54276"></xref>) can use
the transition tables. INSERT statement triggers cannot reference an OLD table.
DELETE statement triggers cannot reference a NEW table.</note></p> <p>The
referencing clause can designate only one new correlation or identifier and
@@ -108,7 +108,7 @@
event.</note></p> </section>
<section id="i1149821"><title>Triggered-SQL-statement</title> <p><indexterm>Triggers<indexterm>the
triggered-SQL-statement</indexterm></indexterm>The action defined by the trigger
-is called the triggered-SQL-statement (in <xref href="#rrefsqlj43125/syn001"></xref> above,
+is called the triggered-SQL-statement (in <xref href="rrefsqlj43125.dita#rrefsqlj43125/syn001"></xref> above,
see the last line). It has the following limitations: <ul>
<li>It must not contain any dynamic parameters (?).</li>
<li>It must not create, alter, or drop the table upon which the trigger is
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita Thu Apr 7 16:08:41 2005
@@ -18,7 +18,7 @@
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<reference id="rrefsqlj81859" xml:lang="en-us">
-<title>ALTER TABLE statement </title>
+<title>ALTER TABLE statement</title>
<prolog><metadata>
<keywords><indexterm>ALTER TABLE statement</indexterm><indexterm>Compressing
tables</indexterm><indexterm>Tables<indexterm>altering</indexterm><indexterm>compressing</indexterm></indexterm>
@@ -121,7 +121,7 @@
LOCKSIZE clause in such a situation without throwing an exception.) To override
row-level locking for the specific table, set locking for the table to TABLE.
If you created the table with table-level locking granularity, you can change
-locking back to ROW with the LOCKSIZE clause in the <xref href="#rrefsqlj81859"></xref>.
+locking back to ROW with the LOCKSIZE clause in the ALTER TABLE STATEMENT.
For information about why this is sometimes useful, see <cite><ph conref="refconrefs.dita#pub/cittuning"></ph></cite>.</p></section>
<section><title>Examples</title> <codeblock><b><ph>-- Add a new column with a column-level constraint
-- to an existing table
Modified: incubator/derby/docs/trunk/src/tools/ctools1004764.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/ctools1004764.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tools/ctools1004764.dita (original)
+++ incubator/derby/docs/trunk/src/tools/ctools1004764.dita Thu Apr 7 16:08:41 2005
@@ -31,7 +31,7 @@
locale determines the default locale.</p></li>
<li><i>Database territory</i>
<p>This is the territory associated
-with your database when it is created. By default, this is the same as the <xref href="#ctools1004764/rtoolsijtools91283">java system locale</xref>. The database territory determines
+with your database when it is created. By default, this is the same as the <xref href="ctools1004764.dita#ctools1004764/rtoolsijtools91283">java system locale</xref>. The database territory determines
the language of database errors.</p></li>
<li><i id="rtoolsijtools74061"><codeph>ij</codeph> or <codeph>dblook</codeph> Session locale</i>
<p>This locale is associated
Modified: incubator/derby/docs/trunk/src/tools/ctoolsijtools16011.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/ctoolsijtools16011.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tools/ctoolsijtools16011.dita (original)
+++ incubator/derby/docs/trunk/src/tools/ctoolsijtools16011.dita Thu Apr 7 16:08:41 2005
@@ -35,17 +35,17 @@
<p>For the <ph conref="toolsconrefs.dita#prod/productshortname"></ph>-provided embedded driver listed above, here is the
format for the database connection URL for connecting to an existing database:
<ul>
-<li>jdbc:derby:<i><xref href="#ctoolsijtools16011/rtoolsijtools16246">databaseName</xref></i>;<i><xref href="#ctoolsijtools16011/rtoolsijtools12861">URLAttributes</xref></i></li>
+<li>jdbc:derby:<i><xref href="ctoolsijtools16011.dita#ctoolsijtools16011/rtoolsijtools16246">databaseName</xref></i>;<i><xref href="ctoolsijtools16011.dita#ctoolsijtools16011/rtoolsijtools12861">URLAttributes</xref></i></li>
</ul></p>
<p>For the JCC driver listed above, here is the format for the database connection URL for connecting
to an existing database:
<ul>
-<li>jdbc:db2://<i>host:port</i>/<i><xref href="#ctoolsijtools16011/rtoolsijtools16246">databaseName</xref></i></li>
+<li>jdbc:db2://<i>host:port</i>/<i><xref href="ctoolsijtools16011.dita#ctoolsijtools16011/rtoolsijtools16246">databaseName</xref></i></li>
</ul></p>
<p>URL attributes can be passed to the JCC driver by using double quotes (")
around the database name portion of the URL, as follows:
<ul>
-<li>jdbc:db2://<i>host:port</i>/<i>"<xref href="#ctoolsijtools16011/rtoolsijtools16246">databaseName</xref>;URLAttributes";</i></li>
+<li>jdbc:db2://<i>host:port</i>/<i>"<xref href="ctoolsijtools16011.dita#ctoolsijtools16011/rtoolsijtools16246">databaseName</xref>;URLAttributes";</i></li>
</ul></p>
<p>The italicized items stand for something the user fills in:
<ul>
Modified: incubator/derby/docs/trunk/src/tools/rtoolsdrvrnmeurl.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/rtoolsdrvrnmeurl.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tools/rtoolsdrvrnmeurl.dita (original)
+++ incubator/derby/docs/trunk/src/tools/rtoolsdrvrnmeurl.dita Thu Apr 7 16:08:41 2005
@@ -20,7 +20,7 @@
<prolog>
</prolog>
<refbody>
-<section><p><xref href="#rtoolsdrvrnmeurl/rtoolsij16268"/>, summarizes
+<section><p><xref href="rtoolsdrvrnmeurl.dita#rtoolsdrvrnmeurl/rtoolsij16268"/>, summarizes
the different ways to specify the driver name and database connection URL.
<table id="rtoolsij16268" expanse="page" frame="all">
<title>Specifying the Driver Name and database connection URL</title>
Modified: incubator/derby/docs/trunk/src/tools/rtoolsijcomref17631.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/rtoolsijcomref17631.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tools/rtoolsijcomref17631.dita (original)
+++ incubator/derby/docs/trunk/src/tools/rtoolsijcomref17631.dita Thu Apr 7 16:08:41 2005
@@ -27,9 +27,9 @@
</refsyn>
<section><title>Description</title>
<p>Displays the results of a previously started asynchronous command.</p>
-<p>The identifier for the asynchronous command must have been used in a previous <xref href="rtoolsijcomref37862.dita#rtoolsijcomref37862"/> command on this connection. The <xref href="#rtoolsijcomref17631"/> command waits for the SQL statement
+<p>The identifier for the asynchronous command must have been used in a previous <xref href="rtoolsijcomref37862.dita#rtoolsijcomref37862"/> command on this connection. The <xref href="rtoolsijcomref17631.dita#rtoolsijcomref17631"/> command waits for the SQL statement
to complete execution, if it has not already, and then displays the results.
-If the statement returns a result set, the <xref href="#rtoolsijcomref17631"/> command steps through the rows, not the <xref href="rtoolsijcomref37862.dita#rtoolsijcomref37862"/> command. This might result in further execution time passing
+If the statement returns a result set, the <xref href="rtoolsijcomref17631.dita#rtoolsijcomref17631"/> command steps through the rows, not the <xref href="rtoolsijcomref37862.dita#rtoolsijcomref37862"/> command. This might result in further execution time passing
during the result display. </p>
</section>
<example><title>Example</title>
Modified: incubator/derby/docs/trunk/src/tools/rtoolsijcomref20382.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/rtoolsijcomref20382.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tools/rtoolsijcomref20382.dita (original)
+++ incubator/derby/docs/trunk/src/tools/rtoolsijcomref20382.dita Thu Apr 7 16:08:41 2005
@@ -40,7 +40,7 @@
used, you can supply the name the system generated for the connection. If
the current connection is the named connection, when the command completes,
there will be no current connection and you must issue a <xref href="rtoolsijcomref39198.dita#rtoolsijcomref39198"/> or <xref href="rtoolsijcomref22318.dita#rtoolsijcomref22318"/> command.</p>
-<p>A <xref href="#rtoolsijcomref20382"/> command issued against
+<p>A <xref href="rtoolsijcomref20382.dita#rtoolsijcomref20382"/> command issued against
a <ph conref="toolsconrefs.dita#prod/productshortname"></ph> connection does not shut down the database or <ph conref="toolsconrefs.dita#prod/productshortname"></ph> (but
the <xref href="rtoolsijcomref33358.dita#rtoolsijcomref33358">Exit</xref> command does).</p>
</section>
Modified: incubator/derby/docs/trunk/src/tools/rtoolsijcomref30679.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/rtoolsijcomref30679.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tools/rtoolsijcomref30679.dita (original)
+++ incubator/derby/docs/trunk/src/tools/rtoolsijcomref30679.dita Thu Apr 7 16:08:41 2005
@@ -30,20 +30,20 @@
<p>Has several uses:
<ul>
<li>To execute an SQL command that has the same name as an <codeph>ij</codeph> command,
-using the <xref href="#rtoolsijcomref30679"/> <i>String</i> style. The String is passed to the connection without further
+using the <xref href="rtoolsijcomref30679.dita#rtoolsijcomref30679"/> <i>String</i> style. The String is passed to the connection without further
examination or processing by <codeph>ij</codeph>. <i>Normally, you
-execute SQL commands directly, not with the <xref href="#rtoolsijcomref30679"/> command</i>.</li>
-<li>To execute a named command previously prepared with the <codeph>ij</codeph> <xref href="rtoolsijcomref12333.dita#rtoolsijcomref12333">Prepare</xref> command, using the <xref href="#rtoolsijcomref30679"/> <i>Identifier</i> style.</li>
+execute SQL commands directly, not with the <xref href="rtoolsijcomref30679.dita#rtoolsijcomref30679"/> command</i>.</li>
+<li>To execute a named command previously prepared with the <codeph>ij</codeph> <xref href="rtoolsijcomref12333.dita#rtoolsijcomref12333">Prepare</xref> command, using the <xref href="rtoolsijcomref30679.dita#rtoolsijcomref30679"/> <i>Identifier</i> style.</li>
<li>To execute either flavor of command when that command contains dynamic
parameters, taking values from the Using portion of the command. In this style,
the Using portion's <i>String</i> or previously prepared <i>Identifier</i> is executed, and it must have a result set
as its result. Each row of the result set is applied to the input parameters
of the command to be executed, so the number of columns in the Using's
-result set must match the number of input parameters in the <xref href="#rtoolsijcomref30679"/>'s statement. The results of each execution of the <xref href="#rtoolsijcomref30679"/> statement are displayed as they are made. If the Using's
-result set contains no rows, the <xref href="#rtoolsijcomref30679"/>'s
+result set must match the number of input parameters in the <xref href="rtoolsijcomref30679.dita#rtoolsijcomref30679"/>'s statement. The results of each execution of the <xref href="rtoolsijcomref30679.dita#rtoolsijcomref30679"/> statement are displayed as they are made. If the Using's
+result set contains no rows, the <xref href="rtoolsijcomref30679.dita#rtoolsijcomref30679"/>'s
statement is not executed.
<p>When auto-commit mode is on, the Using's
-result set is closed upon the first execution of the <xref href="#rtoolsijcomref30679"/> statement. To ensure multiple-row execution of the <xref href="#rtoolsijcomref30679"/> command, use the <xref href="rtoolsijcomref25753.dita#rtoolsijcomref25753"/> command
+result set is closed upon the first execution of the <xref href="rtoolsijcomref30679.dita#rtoolsijcomref30679"/> statement. To ensure multiple-row execution of the <xref href="rtoolsijcomref30679.dita#rtoolsijcomref30679"/> command, use the <xref href="rtoolsijcomref25753.dita#rtoolsijcomref25753"/> command
to turn auto-commit off.</p></li>
</ul></p>
</section>
Modified: incubator/derby/docs/trunk/src/tools/rtoolsijcomref33358.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/rtoolsijcomref33358.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tools/rtoolsijcomref33358.dita (original)
+++ incubator/derby/docs/trunk/src/tools/rtoolsijcomref33358.dita Thu Apr 7 16:08:41 2005
@@ -32,7 +32,7 @@
to halt.</p>
<p><codeph>ij</codeph> automatically shuts down a <ph conref="toolsconrefs.dita#prod/productshortname"></ph> database running in
an embedded environment (issues a <i>Connect 'jdbc:derby:;shutdown=true</i>' request) on exit.</p>
-<p><codeph>ij</codeph> exits when the <xref href="#rtoolsijcomref33358">Exit</xref> command
+<p><codeph>ij</codeph> exits when the <xref href="rtoolsijcomref33358.dita#rtoolsijcomref33358">Exit</xref> command
is entered or if given a command file on the Java invocation line, when the
end of the command file is reached.</p>
</section>
Modified: incubator/derby/docs/trunk/src/tools/rtoolsijcomref37862.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/rtoolsijcomref37862.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tools/rtoolsijcomref37862.dita (original)
+++ incubator/derby/docs/trunk/src/tools/rtoolsijcomref37862.dita Thu Apr 7 16:08:41 2005
@@ -26,7 +26,7 @@
<codeblock><b>ASYNC <b><i><xref href="rtoolsijcomref40155.dita#rtoolsijcomref40155"/> <xref href="rtoolsijcomref34110.dita#rtoolsijcomref34110"/></i></b></b></codeblock>
</refsyn>
<section><title>Description</title>
-<p>The <xref href="#rtoolsijcomref37862"/> command lets you execute
+<p>The <xref href="rtoolsijcomref37862.dita#rtoolsijcomref37862"/> command lets you execute
an SQL statement in a separate thread. It is used in conjunction with the <xref href="rtoolsijcomref17631.dita#rtoolsijcomref17631"/> command to get the results.</p>
<p>You supply the SQL statement, which is any valid SQL statement, as a <i>String</i>. The <i>Identifier</i> you must
supply for the async SQL statement is used in the <xref href="rtoolsijcomref17631.dita#rtoolsijcomref17631"/> command and is a case-insensitive <codeph>ij</codeph> identifier; it
Modified: incubator/derby/docs/trunk/src/tools/rtoolsijcomref39042.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/rtoolsijcomref39042.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tools/rtoolsijcomref39042.dita (original)
+++ incubator/derby/docs/trunk/src/tools/rtoolsijcomref39042.dita Thu Apr 7 16:08:41 2005
@@ -28,7 +28,7 @@
<section><title>Description</title>
<p>Takes the value of the string and issues a <i>Class.forName </i>request to load the named class. The class is expected to be a JDBC driver
that registers itself with <i>java.sql.DriverManager</i>.</p>
-<p>If the <xref href="#rtoolsijcomref39042"/> command succeeds,
+<p>If the <xref href="rtoolsijcomref39042.dita#rtoolsijcomref39042"/> command succeeds,
a new <codeph>ij</codeph> prompt appears for the next command. </p>
</section>
<example><title>Example</title>
Modified: incubator/derby/docs/trunk/src/tools/rtoolsijpropref97949.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/rtoolsijpropref97949.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tools/rtoolsijpropref97949.dita (original)
+++ incubator/derby/docs/trunk/src/tools/rtoolsijpropref97949.dita Thu Apr 7 16:08:41 2005
@@ -29,7 +29,7 @@
<refsyn><title>Syntax</title>
<codeblock><b>derby.ui.codeset=<b><i>derbyval</i></b></b></codeblock>
<p>where <i>derbyval</i> is a supported character encoding
-value, for example, UTF8 (see <xref href="#rtoolsijpropref97949/rtoolsijpropref62163"/>).</p>
+value, for example, UTF8 (see <xref href="rtoolsijpropref97949.dita#rtoolsijpropref97949/rtoolsijpropref62163"/>).</p>
</refsyn>
<example><title>Example</title>
<p>The following command line specifies to run <codeph>ij</codeph> using the Japanese
Modified: incubator/derby/docs/trunk/src/tools/ttoolsij11815.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/ttoolsij11815.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tools/ttoolsij11815.dita (original)
+++ incubator/derby/docs/trunk/src/tools/ttoolsij11815.dita Thu Apr 7 16:08:41 2005
@@ -34,8 +34,8 @@
You can start ij by running the ij scripts in the /frameworks/embedded/bin/
directory or in the /frameworks/NetworkServer/bin/ directory.</p> </context>
<example>To start ij, run the script provided or use this command: <codeblock><xref
-href="#ttoolsij11815/rtoolsij42358">java</xref> [<<i><xref href="#ttoolsij11815/rtoolsij26546">options</xref></i>><?Pub Caret?>] org.apache.derby.tools.ij [-p <<i
-><xref href="#ttoolsij11815/rtoolsij40855">propertyFile</xref></i>>] [<<i><xref
+href="#ttoolsij11815/rtoolsij42358">java</xref> [<<i><xref href="ttoolsij11815.dita#ttoolsij11815/rtoolsij26546">options</xref></i>><?Pub Caret?>] org.apache.derby.tools.ij [-p <<i
+><xref href="ttoolsij11815.dita#ttoolsij11815/rtoolsij40855">propertyFile</xref></i>>] [<<i><xref
href="#ttoolsij11815/rtoolsij39639">inputFile</xref></i>>]</codeblock>The
command line items are: <ul>
<li id="rtoolsij42358">java <p>The JVM you want to run (java is the name
Modified: incubator/derby/docs/trunk/src/tuning/ctundepth32379.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctundepth32379.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctundepth32379.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctundepth32379.dita Thu Apr 7 16:08:41 2005
@@ -54,7 +54,7 @@
any connection can share the same statement execution plan, avoiding compilation,
by using the single-statement cache. The statement cache maintains statement
plans across connections. It does not, however, maintain them across reboots.
-(See <xref href="#ctundepth32379/ctundepth12523"></xref>.) <p>When, in the
+(See <xref href="ctundepth32379.dita#ctundepth32379/ctundepth12523"></xref>.) <p>When, in the
same database, an application submits an SQL <i>Statement</i> that exactly
matches one already in the cache, <ph conref="tunconrefs.dita#prod/productshortname"></ph> grabs
the statement from the cache, even if the <i>Statement</i> has already been
Modified: incubator/derby/docs/trunk/src/tuning/ctunperf98197.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunperf98197.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunperf98197.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunperf98197.dita Thu Apr 7 16:08:41 2005
@@ -26,7 +26,7 @@
<p>JDBC is permissive. It lets you use <i>java.sql.ResultSet.getFloat</i> to retrieve an int, <i>java.sql.ResultSet.getObject</i> to retrieve any type, and so on. (<i>java.sql.ResultSet </i>and <i>java.sql.CallableStatement</i> provide <i>getXXX</i> methods, and <i>java .sql.PreparedStatement</i> and <i>java.sql.CallableStatement</i> provide <i>setXXX</i> methods.) This permissiveness is convenient but expensive in terms
of performance.</p>
<p>For performance reasons, use the recommended <i>getXXX</i> method when retrieving values, and use the recommended <i>setXXX</i> method when setting values for parameters.</p>
-<p><xref href="#ctunperf98197/ctunperf31241"/> shows the recommended <i>getXXX</i> methods for given <i>java.sql</i> (JDBC) types,
+<p><xref href="ctunperf98197.dita#ctunperf98197/ctunperf31241"/> shows the recommended <i>getXXX</i> methods for given <i>java.sql</i> (JDBC) types,
and their corresponding SQL types.
<table id="ctunperf31241" frame="all">
<title>Mapping of java.sql.Types to SQL types</title>
Modified: incubator/derby/docs/trunk/src/tuning/ctunproper22250.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunproper22250.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunproper22250.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunproper22250.dita Thu Apr 7 16:08:41 2005
@@ -23,7 +23,7 @@
<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 the property to be set to false.</note></p>
-<p><xref href="#ctunproper22250/rtunproper24108"/> summarizes the general <ph conref="tunconrefs.dita#prod/productshortname"></ph> properties.
+<p><xref href="ctunproper22250.dita#ctunproper22250/rtunproper24108"/> 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
indicates the value persists with newly created conglomerates. X means yes.
@@ -71,7 +71,7 @@
<row>
<entry colname="1"><i><xref href="rtunproper24846.dita#rtunproper24846"/></i></entry>
<entry colname="2">S, D</entry>
-<entry colname="3">X<xref href="#ctunproper22250/rtunproper97948">*</xref></entry></row>
+<entry colname="3">X<xref href="ctunproper22250.dita#ctunproper22250/rtunproper97948">*</xref></entry></row>
<row>
<entry colname="1"><i><xref href="rtunproper81405.dita#rtunproper81405"/></i></entry>
<entry colname="2">S</entry>
@@ -79,7 +79,7 @@
<row>
<entry colname="1"><i><xref href="rtunproper25025.dita#rtunproper25025"/></i></entry>
<entry colname="2">S, D</entry>
-<entry colname="3">X<xref href="#ctunproper22250/rtunproper97948">*</xref></entry></row>
+<entry colname="3">X<xref href="ctunproper22250.dita#ctunproper22250/rtunproper97948">*</xref></entry></row>
<row>
<entry colname="1"><i><xref href="rtunproper24390.dita#rtunproper24390"/></i></entry>
<entry colname="2">D</entry>
@@ -87,7 +87,7 @@
<row>
<entry colname="1"><i><xref href="rtunproper39325.dita#rtunproper39325"/></i></entry>
<entry colname="2">S, D</entry>
-<entry colname="3">X<xref href="#ctunproper22250/rtunproper97948">*</xref></entry></row>
+<entry colname="3">X<xref href="ctunproper22250.dita#ctunproper22250/rtunproper97948">*</xref></entry></row>
<row>
<entry colname="1"><i><xref href="rtunproper13217.dita#rtunproper13217"/></i></entry>
<entry colname="2">S</entry>
Modified: incubator/derby/docs/trunk/src/tuning/ctunstats52657.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctunstats52657.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctunstats52657.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctunstats52657.dita Thu Apr 7 16:08:41 2005
@@ -27,7 +27,7 @@
<p>In all other cases, <ph conref="tunconrefs.dita#prod/productshortname"></ph> uses a fixed number that attempts to describe
the percentage of rows that will probably be returned; it might not correspond
to the actual selectivity of the operation in every case. It is an assumption
-hard-wired into the <ph conref="tunconrefs.dita#prod/productshortname"></ph> system. These assumptions are shown in <xref href="#ctunstats52657/rtunstats405"/>.</p>
+hard-wired into the <ph conref="tunconrefs.dita#prod/productshortname"></ph> system. These assumptions are shown in <xref href="ctunstats52657.dita#ctunstats52657/rtunstats405"/>.</p>
<table id="rtunstats405" frame="all">
<title>Selectivity for various operations for index scans
when search values are unknown in advance and statistics are not used</title>
Modified: incubator/derby/docs/trunk/src/tuning/ctuntransform13966.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctuntransform13966.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctuntransform13966.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctuntransform13966.dita Thu Apr 7 16:08:41 2005
@@ -55,7 +55,7 @@
For example:<i> SELECT derivedtable.c1 FROM (VALUES ('a','b'))
AS derivedtable(c1,c2)</i>.</dd></dlentry>
<dlentry><dt id="rtuntransform24389">equality predicate</dt>
-<dd>A <xref href="#ctuntransform13966/rtuntransform25022">predicate</xref> in which one value is
+<dd>A <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform25022">predicate</xref> in which one value is
compared to another value using the = operator.</dd></dlentry>
<dlentry><dt id="rtuntransform36163">equijoin predicate</dt>
<dd>A predicate in which one column is compared to a column in another table
@@ -63,7 +63,7 @@
<dlentry><dt id="rtuntransform19435">optimizable</dt>
<dd>A predicate is <i>optimizable</i> if it provides a
starting or stopping point and allows use of an index. Optimizable predicates
-use only <xref href="#ctuntransform13966/rtuntransform13785">simple column reference</xref>s and =, <, >, +, >=,
+use only <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform13785">simple column reference</xref>s and =, <, >, +, >=,
and IS NULL operators. For complete details, see <xref href="ctunoptimz39106.dita#ctunoptimz39106"/>. A synonym for <i>optimizable</i> is <i>indexable</i>.</dd></dlentry>
<dlentry><dt id="rtuntransform25022">predicate</dt>
<dd>A WHERE clause contains boolean expressions that can be linked together
Modified: incubator/derby/docs/trunk/src/tuning/ctuntransform16279.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctuntransform16279.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctuntransform16279.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctuntransform16279.dita Thu Apr 7 16:08:41 2005
@@ -72,21 +72,21 @@
(2, 2),
(2, 3)
<b>-- all the columns in the index on the only table appear
--- in the way required for the <xref href="#ctuntransform16279/rtuntransform29680">Primary table</xref></b>
+-- in the way required for the <xref href="ctuntransform16279.dita#ctuntransform16279/rtuntransform29680">Primary table</xref></b>
SELECT DISTINCT c1, c2, c3, c4
FROM tab1
<b>-- all the columns in the index on the only table appear
--- in the way required for the <xref href="#ctuntransform16279/rtuntransform29680">Primary table</xref></b>
+-- in the way required for the <xref href="ctuntransform16279.dita#ctuntransform16279/rtuntransform29680">Primary table</xref></b>
SELECT DISTINCT c3, c4
FROM tab1
WHERE c1 = 1
AND c2 = 2
AND c4 = 'WA'
<b>-- all the columns in the index on tab1 appear
--- in the way required for the <xref href="#ctuntransform16279/rtuntransform29680">Primary table</xref>,
+-- in the way required for the <xref href="ctuntransform16279.dita#ctuntransform16279/rtuntransform29680">Primary table</xref>,
-- and all the columns in the
-- other tables appear in the way required
--- for a <xref href="#ctuntransform16279/rtuntransform16930">Secondary table</xref></b>
+-- for a <xref href="ctuntransform16279.dita#ctuntransform16279/rtuntransform16930">Secondary table</xref></b>
SELECT DISTINCT tab1.c1, tab1.c3, tab1.c4
FROM tab1, tab2
WHERE tab1.c2 = 2
Modified: incubator/derby/docs/trunk/src/tuning/ctuntransform867201.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ctuntransform867201.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ctuntransform867201.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ctuntransform867201.dita Thu Apr 7 16:08:41 2005
@@ -40,7 +40,7 @@
transformation is performed, the subquery becomes materializable. In the example,
if the IN subquery were not transformed, it would be evaluated anew for each
row.</p>
-<p>The subquery type transformation is shown in <xref href="#ctuntransform867201/rtuntransform52953"/>:
+<p>The subquery type transformation is shown in <xref href="ctuntransform867201.dita#ctuntransform867201/rtuntransform52953"/>:
<table id="rtuntransform52953" frame="all">
<title>IN or ANY Subquery Transformations for Subqueries
Returning a Single Row</title>
Modified: incubator/derby/docs/trunk/src/tuning/rtunproper81359.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtunproper81359.dita?view=diff&r1=160491&r2=160492
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtunproper81359.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtunproper81359.dita Thu Apr 7 16:08:41 2005
@@ -28,7 +28,7 @@
<p>The actual amount of memory the page cache will use depends on the following:
<ul>
-<li>the size of the cache (configured with this property, <i><xref href="#rtunproper81359"/></i>)</li>
+<li>the size of the cache (configured with this property, <i><xref href="rtunproper81359.dita#rtunproper81359"/></i>)</li>
<li>the size of the pages (configured with the <i><xref href="rtunproper40688.dita#rtunproper40688"/></i> property)</li>
<li>overhead (varies with JVMs)</li>
</ul></p>
|