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 ch...@apache.org on 2010/10/29 19:11:21 UTC
svn commit: r1028853 [1/2] - in /db/derby/docs/trunk/src: adminguide/ ref/
tools/
Author: chaase3
Date: Fri Oct 29 17:11:19 2010
New Revision: 1028853
URL: http://svn.apache.org/viewvc?rev=1028853&view=rev
Log:
DERBY-4840: Reference topic example elements lack titles
Added an "Example" or "Examples" title in example elements that needed one -- that is, where the example was a separate section and was not part of conceptual material. Also made some formatting fixes related to example elements where needed. Modified 4 topics in adminguide, 2 topics in tools, 74 in reference manual.
Patches: DERBY-4840-adminguide.diff, DERBY-4840-tools.diff, DERBY-4840-ref.diff
Modified:
db/derby/docs/trunk/src/adminguide/cadminssladmin.dita
db/derby/docs/trunk/src/adminguide/cadminsslclient.dita
db/derby/docs/trunk/src/adminguide/cadminsslkeys.dita
db/derby/docs/trunk/src/adminguide/cadminsslserver.dita
db/derby/docs/trunk/src/ref/rrefattrib10035.dita
db/derby/docs/trunk/src/ref/rrefattrib42686.dita
db/derby/docs/trunk/src/ref/rrefattrib72457.dita
db/derby/docs/trunk/src/ref/rrefattribupgrade.dita
db/derby/docs/trunk/src/ref/rrefblob.dita
db/derby/docs/trunk/src/ref/rrefbuiltbigint.dita
db/derby/docs/trunk/src/ref/rrefbuiltchar.dita
db/derby/docs/trunk/src/ref/rrefbuiltinteger.dita
db/derby/docs/trunk/src/ref/rrefbuiltsmallint.dita
db/derby/docs/trunk/src/ref/rrefbuiltvarchar.dita
db/derby/docs/trunk/src/ref/rrefcase.dita
db/derby/docs/trunk/src/ref/rrefcasenullif.dita
db/derby/docs/trunk/src/ref/rrefclob.dita
db/derby/docs/trunk/src/ref/rrefcreatefrom.dita
db/derby/docs/trunk/src/ref/rrefcurrentisolation.dita
db/derby/docs/trunk/src/ref/rrefdatefunc.dita
db/derby/docs/trunk/src/ref/rrefidentityvallocal.dita
db/derby/docs/trunk/src/ref/rrefjdbc28456.dita
db/derby/docs/trunk/src/ref/rrefjdbc37244.dita
db/derby/docs/trunk/src/ref/rrefjdbc41784.dita
db/derby/docs/trunk/src/ref/rrefjdbc70824.dita
db/derby/docs/trunk/src/ref/rrefminutefunc.dita
db/derby/docs/trunk/src/ref/rrefrestorefrom.dita
db/derby/docs/trunk/src/ref/rrefrollforward.dita
db/derby/docs/trunk/src/ref/rrefsqlj10696.dita
db/derby/docs/trunk/src/ref/rrefsqlj12362.dita
db/derby/docs/trunk/src/ref/rrefsqlj13083.dita
db/derby/docs/trunk/src/ref/rrefsqlj14854.dita
db/derby/docs/trunk/src/ref/rrefsqlj15260.dita
db/derby/docs/trunk/src/ref/rrefsqlj15309.dita
db/derby/docs/trunk/src/ref/rrefsqlj15866.dita
db/derby/docs/trunk/src/ref/rrefsqlj16762.dita
db/derby/docs/trunk/src/ref/rrefsqlj18922.dita
db/derby/docs/trunk/src/ref/rrefsqlj21583.dita
db/derby/docs/trunk/src/ref/rrefsqlj25228.dita
db/derby/docs/trunk/src/ref/rrefsqlj27781.dita
db/derby/docs/trunk/src/ref/rrefsqlj30435.dita
db/derby/docs/trunk/src/ref/rrefsqlj31648.dita
db/derby/docs/trunk/src/ref/rrefsqlj31783.dita
db/derby/docs/trunk/src/ref/rrefsqlj32268.dita
db/derby/docs/trunk/src/ref/rrefsqlj32613.dita
db/derby/docs/trunk/src/ref/rrefsqlj32654.dita
db/derby/docs/trunk/src/ref/rrefsqlj32714.dita
db/derby/docs/trunk/src/ref/rrefsqlj33520.dita
db/derby/docs/trunk/src/ref/rrefsqlj33562.dita
db/derby/docs/trunk/src/ref/rrefsqlj33602.dita
db/derby/docs/trunk/src/ref/rrefsqlj33772.dita
db/derby/docs/trunk/src/ref/rrefsqlj34177.dita
db/derby/docs/trunk/src/ref/rrefsqlj35034.dita
db/derby/docs/trunk/src/ref/rrefsqlj38716.dita
db/derby/docs/trunk/src/ref/rrefsqlj40899.dita
db/derby/docs/trunk/src/ref/rrefsqlj41180.dita
db/derby/docs/trunk/src/ref/rrefsqlj42049.dita
db/derby/docs/trunk/src/ref/rrefsqlj42082.dita
db/derby/docs/trunk/src/ref/rrefsqlj42324.dita
db/derby/docs/trunk/src/ref/rrefsqlj42476.dita
db/derby/docs/trunk/src/ref/rrefsqlj43125.dita
db/derby/docs/trunk/src/ref/rrefsqlj57924.dita
db/derby/docs/trunk/src/ref/rrefsqlj59893.dita
db/derby/docs/trunk/src/ref/rrefsqlj61102.dita
db/derby/docs/trunk/src/ref/rrefsqlj61998.dita
db/derby/docs/trunk/src/ref/rrefsqlj66113.dita
db/derby/docs/trunk/src/ref/rrefsqlj73147.dita
db/derby/docs/trunk/src/ref/rrefsqlj95598.dita
db/derby/docs/trunk/src/ref/rrefsqlj97870.dita
db/derby/docs/trunk/src/ref/rrefsqlj98067.dita
db/derby/docs/trunk/src/ref/rrefsqljBoolean.dita
db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita
db/derby/docs/trunk/src/ref/rrefsqljcurrentschema.dita
db/derby/docs/trunk/src/ref/rrefsqljoffsetfetch.dita
db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita
db/derby/docs/trunk/src/ref/rrefsqljtfinvoke.dita
db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita
db/derby/docs/trunk/src/ref/rreftimefunc.dita
db/derby/docs/trunk/src/tools/rtoolsijpropref10135.dita
db/derby/docs/trunk/src/tools/ttoolsij30600.dita
Modified: db/derby/docs/trunk/src/adminguide/cadminssladmin.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/adminguide/cadminssladmin.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/adminguide/cadminssladmin.dita (original)
+++ db/derby/docs/trunk/src/adminguide/cadminssladmin.dita Fri Oct 29 17:11:19 2010
@@ -38,26 +38,18 @@ command option <codeph>-ssl</codeph>.
</p>
</section>
-<example><title>Example:</title>
-<codeblock>
-java -jar derbyrun.jar server shutdown -ssl basic
-</codeblock>
-<p>will shutdown an SSL-enabled server. </p>
-</example>
-
-<example>
-<title>Example:</title>
+<example><title>Examples</title>
+<codeblock>java -jar derbyrun.jar server shutdown -ssl basic</codeblock>
+<p>will shut down an SSL-enabled server. </p>
<p>
-Similarly, if you have peerAuthentication on both sides, use the
+Similarly, if you have <codeph>peerAuthentication</codeph> on both sides, use the
following command:
</p>
-<codeblock>
-java -Djavax.net.ssl.keyStore=clientKeyStore.key \
+<codeblock>java -Djavax.net.ssl.keyStore=clientKeyStore.key \
-Djavax.net.ssl.keyStorePassword=qwerty \
-Djavax.net.ssl.trustStore=clientTrustStore.key \
-Djavax.net.ssl.trustStorePassword=qwerty \
- -jar derbyrun.jar server shutdown -ssl peerAuthentication
-</codeblock>
+ -jar derbyrun.jar server shutdown -ssl peerAuthentication</codeblock>
</example>
</conbody>
Modified: db/derby/docs/trunk/src/adminguide/cadminsslclient.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/adminguide/cadminsslclient.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/adminguide/cadminsslclient.dita (original)
+++ db/derby/docs/trunk/src/adminguide/cadminsslclient.dita Fri Oct 29 17:11:19 2010
@@ -27,12 +27,9 @@ limitations under the License.
<codeph>ssl</codeph>, the property <codeph>ssl</codeph> or the
datasource attribute <codeph>ssl</codeph> set to <codeph>basic</codeph>.</p>
-<example>
-<title>Example:</title>
-<codeblock>
-Connection c =
- getConnection("jdbc:derby://myhost:1527/db;ssl=basic");
-</codeblock>
+<example><title>Example</title>
+<codeblock>Connection c =
+ getConnection("jdbc:derby://myhost:1527/db;ssl=basic");</codeblock>
</example>
<section>
@@ -47,52 +44,43 @@ set to <codeph>peerAuthentication</codep
properties <codeph>javax.net.ssl.trustStore</codeph> and
<codeph>javax.net.ssl.trustStorePassword</codeph> need to be set.</p>
</section>
-<example>
-<title>Example:</title>
-<codeblock>
- System.setProperty("javax.net.ssl.trustStore","clientTrustStore.key");
+<example><title>Example</title>
+<codeblock> System.setProperty("javax.net.ssl.trustStore","clientTrustStore.key");
System.setProperty("javax.net.ssl.trustStorePassword","qwerty");
Connection c =
- getConnection("jdbc:derby://myhost:1527/db;ssl=peerAuthentication");
-</codeblock>
+ getConnection("jdbc:derby://myhost:1527/db;ssl=peerAuthentication");</codeblock>
</example>
<section>
<title>Running the client when the server does client authentication</title>
-If the server does client authentication, the client will need a key
+<p>If the server does client authentication, the client will need a key
pair and a client certificate which is installed in the server's
<i>trust store</i>, See <xref
-href="cadminsslkeys.dita#cadminsslkeys"></xref>.
+href="cadminsslkeys.dita#cadminsslkeys"></xref>.</p>
<p>The client needs to set <codeph>javax.net.ssl.keyStore</codeph> and
<codeph>javax.net.ssl.keyStorePassword</codeph>.</p>
</section>
-<example>
-<title>Example:</title>
-<codeblock>
- System.setProperty("javax.net.ssl.keyStore","clientKeyStore.key");
+<example><title>Example</title>
+<codeblock> System.setProperty("javax.net.ssl.keyStore","clientKeyStore.key");
System.setProperty("javax.net.ssl.keyStorePassword","qwerty");
Connection c =
- getConnection("jdbc:derby://myhost:1527/db;ssl=basic");
-</codeblock>
+ getConnection("jdbc:derby://myhost:1527/db;ssl=basic");</codeblock>
</example>
<section>
<title>Running the client when both parties do peer
authentication</title>
-This is a combination of the two last variants.
+<p>This is a combination of the two last variants.</p>
</section>
-<example>
-<title>Example:</title>
-<codeblock>
- System.setProperty("javax.net.ssl.keyStore","clientKeyStore.key");
+<example><title>Example</title>
+<codeblock> System.setProperty("javax.net.ssl.keyStore","clientKeyStore.key");
System.setProperty("javax.net.ssl.keyStorePassword","qwerty");
System.setProperty("javax.net.ssl.trustStore","clientTrustStore.key");
System.setProperty("javax.net.ssl.trustStorePassword","qwerty");
Connection c =
- getConnection("jdbc:derby://myhost:1527/db;ssl=peerAuthentication");
-</codeblock>
+ getConnection("jdbc:derby://myhost:1527/db;ssl=peerAuthentication");</codeblock>
</example>
</conbody>
Modified: db/derby/docs/trunk/src/adminguide/cadminsslkeys.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/adminguide/cadminsslkeys.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/adminguide/cadminsslkeys.dita (original)
+++ db/derby/docs/trunk/src/adminguide/cadminsslkeys.dita Fri Oct 29 17:11:19 2010
@@ -48,13 +48,11 @@ store.
<section>
<title>Key pair generation</title>
-Key pairs are generated with <codeph>keytool -genkey</codeph>. The
-simplest way to generate a key pair is to do
-<codeblock>
-keytool -genkey <alias> -keystore <keystore>
-</codeblock>
-<codeph>ketool</codeph> will prompt for needed information like
-identity details and passwords.
+<p>Key pairs are generated with <codeph>keytool -genkey</codeph>. The
+simplest way to generate a key pair is to do the following:</p>
+<codeblock>keytool -genkey <alias> -keystore <keystore></codeblock>
+<p><codeph>keytool</codeph> will prompt for needed information like
+identity details and passwords. </p>
<p>
Consult the JDK documentation for more information on
<codeph>keytool</codeph>.
@@ -63,54 +61,39 @@ Consult the JDK documentation for more i
<section>
<title>Certificate generation</title>
-Certificates are generated with <codeph>keytool -export</codeph> like this:
-<codeblock>
-keytool -export -alias <alias> -keystore <keystore> \
- -rfc -file <certificate file>
-</codeblock>
-The certificate file may then be distributed to the relevant parties.
+<p>Certificates are generated with <codeph>keytool -export</codeph>
+as follows:</p>
+<codeblock>keytool -export -alias <alias> -keystore <keystore> \
+ -rfc -file <certificate file></codeblock>
+<p>The certificate file may then be distributed to the relevant parties.</p>
</section>
<section>
<title>Certificate installation</title>
-Installation of a certificate in a trust store is done with
-<codeph>keytool -import</codeph> like this:
-<codeblock>
-keytool -import -alias <alias> -file <certificate file> \
- -keystore <trust store>
-</codeblock>
+<p>Installation of a certificate in a trust store is done with
+<codeph>keytool -import</codeph> as follows:</p>
+<codeblock>keytool -import -alias <alias> -file <certificate file> \
+ -keystore <trust store></codeblock>
</section>
<example>
<title>Examples</title>
-Generate the server key pair:
-<codeblock>
-keytool -genkey -alias myDerbyServer -keystore serverKeyStore.key
-</codeblock>
-Generate a server certificate:
-<codeblock>
-keytool -export -alias myDerbyServer -keystore serverKeyStore.key \
- -rfc -file myServer.cert
-</codeblock>
-Generate a client key pair:
-<codeblock>
-keytool -genkey -alias aDerbyClient -keystore clientKeyStore.key
-</codeblock>
-Generate a client certficate:
-<codeblock>
-keytool -export -alias aDerbyClient -keystore clientKeyStore.key \
- -rfc -file aClient.cert
-</codeblock>
-Install a client certificate in the server's trust store:
-<codeblock>
-keytool -import -alias aDerbyClient -file aClient.cert
- -keystore serverTrustStore.key
-</codeblock>
-Install the server certificate in a client's trust store:
-<codeblock>
-keytool -import -alias myDerbyServer -file myServer.cert
- -keystore clientTrustStore.key
-</codeblock>
+<p>Generate the server key pair:</p>
+<codeblock>keytool -genkey -alias myDerbyServer -keystore serverKeyStore.key</codeblock>
+<p>Generate a server certificate:</p>
+<codeblock>keytool -export -alias myDerbyServer -keystore serverKeyStore.key \
+ -rfc -file myServer.cert</codeblock>
+<p>Generate a client key pair:</p>
+<codeblock>keytool -genkey -alias aDerbyClient -keystore clientKeyStore.key</codeblock>
+<p>Generate a client certficate:</p>
+<codeblock>keytool -export -alias aDerbyClient -keystore clientKeyStore.key \
+ -rfc -file aClient.cert</codeblock>
+<p>Install a client certificate in the server's trust store:</p>
+<codeblock>keytool -import -alias aDerbyClient -file aClient.cert
+ -keystore serverTrustStore.key</codeblock>
+<p>Install the server certificate in a client's trust store:</p>
+<codeblock>keytool -import -alias myDerbyServer -file myServer.cert
+ -keystore clientTrustStore.key</codeblock>
</example>
</conbody>
Modified: db/derby/docs/trunk/src/adminguide/cadminsslserver.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/adminguide/cadminsslserver.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/adminguide/cadminsslserver.dita (original)
+++ db/derby/docs/trunk/src/adminguide/cadminsslserver.dita Fri Oct 29 17:11:19 2010
@@ -37,19 +37,17 @@ described in <xref href="cadminsslkeys.d
<section>
<title>Starting the server with basic SSL encryption</title>
-When the SSL mode is set to <codeph>basic</codeph>, the server will
-only accept SSL encrypted connections.
+<p>When the SSL mode is set to <codeph>basic</codeph>, the server will
+only accept SSL encrypted connections.</p>
<p>The properties <codeph>javax.net.ssl.keyStore</codeph> and
<codeph>javax.net.ssl.keyStorePassword</codeph> need to be set with
the proper values.</p>
</section>
-<example><title>Example:</title>
-<codeblock>
-java -Djavax.net.ssl.keyStore=serverKeyStore.key \
+<example><title>Example</title>
+<codeblock>java -Djavax.net.ssl.keyStore=serverKeyStore.key \
-Djavax.net.ssl.keyStorePassword=qwerty \
- -jar derbyrun.jar server start -ssl basic
-</codeblock>
+ -jar derbyrun.jar server start -ssl basic</codeblock>
</example>
<section>
@@ -65,17 +63,14 @@ each client which will connect.
<codeph>javax.net.ssl.trustStorePassword</codeph> need to be set in
addition to the properties above.</p>
<p>See <xref href="cadminsslclient.dita#cadminsslclient"></xref> for
-client settings when the server does client authentication</p>
+client settings when the server does client authentication.</p>
</section>
-<example>
-<title>Example:</title>
-<codeblock>
-java -Djavax.net.ssl.keyStore=serverKeyStore.key \
+<example><title>Example</title>
+<codeblock>java -Djavax.net.ssl.keyStore=serverKeyStore.key \
-Djavax.net.ssl.keyStorePassword=qwerty \
-Djavax.net.ssl.trustStore=serverTrustStore.key \
-Djavax.net.ssl.trustStorePassword=qwerty \
- -jar derbyrun.jar server start -ssl peerAuthentication
-</codeblock>
+ -jar derbyrun.jar server start -ssl peerAuthentication</codeblock>
</example>
</conbody>
Modified: db/derby/docs/trunk/src/ref/rrefattrib10035.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefattrib10035.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefattrib10035.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefattrib10035.dita Fri Oct 29 17:11:19 2010
@@ -30,7 +30,8 @@ password. A valid user name and password
is turned on.</p></section>
<section><title>Combining with other attributes</title> <p>Use
in conjunction with the <i><xref href="rrefattrib42686.dita#rrefattrib42686">password=userPassword</xref></i> attribute.</p> </section>
-<example> <p>The following database connection URL connects the user jill
+<example><title>Example</title>
+<p>The following database connection URL connects the user jill
to <i>toursDB</i>:</p> <codeblock><b>jdbc:derby:toursDB;user=jill;password=toFetchAPail</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefattrib42686.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefattrib42686.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefattrib42686.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefattrib42686.dita Fri Oct 29 17:11:19 2010
@@ -28,7 +28,7 @@ limitations under the License.
<section><title>Function</title> <p>A valid password for the given user name. </p> </section>
<section><title>Combining with other attributes</title> <p>Use
in conjunction with the <i><xref href="rrefattrib10035.dita#rrefattrib10035">user=userName</xref></i> attribute.</p> </section>
-<example> <codeblock><b>jdbc:derby:toursDB;user=jack;password=upTheHill</b></codeblock> </example>
+<example><title>Example</title>
+<codeblock><b>jdbc:derby:toursDB;user=jack;password=upTheHill</b></codeblock> </example>
</refbody>
</reference>
-
Modified: db/derby/docs/trunk/src/ref/rrefattrib72457.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefattrib72457.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefattrib72457.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefattrib72457.dita Fri Oct 29 17:11:19 2010
@@ -38,7 +38,8 @@ in conjunction with <i><xref href="rrefa
<xref href="rrefcreatefrom.dita#rrefcreatefrom">createFrom</xref>,
<xref href="rrefrestorefrom.dita#rrefrestorefrom">restoreFrom</xref>,
or <xref href="rrefrollforward.dita#rrefrollforward">rollForwardRecoveryFrom</xref></i>.</p> </section>
-<example> <codeblock><b>jdbc:derby:newDB;create=true;logDevice=d:/newDBlog</b></codeblock> </example>
+<example><title>Example</title>
+<codeblock><b>jdbc:derby:newDB;create=true;logDevice=d:/newDBlog</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefattribupgrade.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefattribupgrade.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefattribupgrade.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefattribupgrade.dita Fri Oct 29 17:11:19 2010
@@ -44,7 +44,7 @@ attribute with this attribute.</p>
or <i><xref href="rrefattrib56769.dita#rrefattrib56769">territory=ll_CC</xref></i>
attributes.</p>
</section>
-<example>
+<example><title>Example</title>
<codeblock><b>jdbc:derby:sampleDB;upgrade=true
jdbc:derby:;databaseName=sampleDB;upgrade=true;</b></codeblock>
Modified: db/derby/docs/trunk/src/ref/rrefblob.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefblob.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefblob.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefblob.dita Fri Oct 29 17:11:19 2010
@@ -39,17 +39,20 @@ to two gigabytes (2,147,483,647).</p> </
<section><title>JDBC metadata type (java.sql.Types)</title><p>BLOB</p><p>Use
the <i>getBlob</i> method on the <i>java.sql.ResultSet</i> to retrieve a BLOB
handle to the underlying data.</p> </section>
-<section><title>Related information</title><p>see <xref href="rrefjdbc96386.dita#rrefjdbc96386"></xref></p> </section>
-<example> <codeblock><ph>create table pictures(name varchar(32) not null primary key, pic blob(16M));
+<section><title>Related information</title>
+<p>See <xref href="rrefjdbc96386.dita#rrefjdbc96386"></xref>.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b><ph>create table pictures(name varchar(32) not null primary key, pic blob(16M));
</ph>
---find all logotype pictures
+-- find all logotype pictures
select length(pic), name from pictures where name like '%logo%';
---find all image doubles (blob comparsions)
+-- find all image doubles (blob comparisons)
select a.name as double_one, b.name as double_two
from pictures as a, pictures as b
where a.name < b.name
and a.pic = b.pic
-order by 1,2;</codeblock> </example>
+order by 1,2;</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefbuiltbigint.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefbuiltbigint.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefbuiltbigint.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefbuiltbigint.dita Fri Oct 29 17:11:19 2010
@@ -46,7 +46,7 @@ error occurs. The decimal part of the ar
<p>The result of the function is a big integer. If the argument can be null,
the result can be null; if the argument is null, the result is the null value.</p>
</refsyn>
-<example>
+<example><title>Example</title>
<p>Using the EMPLOYEE table, select the EMPNO column in big integer form for
further processing in the application:
<codeblock><b>SELECT BIGINT</b> (EMPNO) <b>FROM</b> EMPLOYEE</codeblock></p>
Modified: db/derby/docs/trunk/src/ref/rrefbuiltchar.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefbuiltchar.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefbuiltchar.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefbuiltchar.dita Fri Oct 29 17:11:19 2010
@@ -98,7 +98,8 @@ to make the change.</dd>
<dd>An expression that returns a value that is a floating-point data type
(DOUBLE or REAL).</dd>
</dlentry></dl> </section>
-<example> <p>Use the CHAR function to return the values for EDLEVEL (defined
+<example><title>Example</title>
+<p>Use the CHAR function to return the values for EDLEVEL (defined
as smallint) as a fixed length character string: <codeblock><b>SELECT CHAR</b>(EDLEVEL) <b>FROM</b> EMPLOYEE</codeblock>An
EDLEVEL of 18 would be returned as the CHAR(6) value '18 ' (18 followed by
four blanks).</p> </example>
Modified: db/derby/docs/trunk/src/ref/rrefbuiltinteger.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefbuiltinteger.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefbuiltinteger.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefbuiltinteger.dita Fri Oct 29 17:11:19 2010
@@ -45,7 +45,8 @@ integer column or variable.</dd>
</dlentry></dl> <p>The result of the function is a large integer. If the argument
can be null, the result can be null; if the argument is null, the result is
the null value.</p> </refsyn>
-<example> <p>Using the EMPLOYEE table, select a list containing salary (SALARY)
+<example><title>Example</title>
+<p>Using the EMPLOYEE table, select a list containing salary (SALARY)
divided by education level (EDLEVEL). Truncate any decimal in the calculation.
The list should also contain the values used in the calculation and employee
number (EMPNO). The list should be in descending order of the calculated value: <codeblock><b>SELECT INTEGER</b> (SALARY / EDLEVEL), SALARY, EDLEVEL, EMPNO
Modified: db/derby/docs/trunk/src/ref/rrefbuiltsmallint.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefbuiltsmallint.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefbuiltsmallint.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefbuiltsmallint.dita Fri Oct 29 17:11:19 2010
@@ -48,7 +48,7 @@ integer column or variable.</dd>
</dlentry></dl> <p>The result of the function is a small integer. If the argument
can be null, the result can be null. If the argument is null, the result is
the null value.</p> </refsyn>
-<example><title>Example</title><p>To determine the small integer representation
+<example><title>Examples</title><p>To determine the small integer representation
of the number 32767.99, use this clause:<codeblock>VALUES SMALLINT (32767.99)</codeblock>The
result is 32767. </p><p>To determine the small integer representation of the
number 1, use this clause: <codeblock>VALUES SMALLINT (1)</codeblock>The result
Modified: db/derby/docs/trunk/src/ref/rrefbuiltvarchar.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefbuiltvarchar.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefbuiltvarchar.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefbuiltvarchar.dita Fri Oct 29 17:11:19 2010
@@ -41,7 +41,7 @@ a maximum length of 32,672 bytes.</dd></
type.</dd></dlentry>
</dl>
</section>
-<example>
+<example><title>Example</title>
<p>Using the EMPLOYEE table, select the job description (JOB defined as CHAR(8))
for Dolores Quintana as a VARCHAR equivelant:
<codeblock><b>SELECT VARCHAR</b>(JOB)
Modified: db/derby/docs/trunk/src/ref/rrefcase.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcase.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcase.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcase.dita Fri Oct 29 17:11:19 2010
@@ -24,7 +24,7 @@ limitations under the License.
<keywords><indexterm>CASE expression</indexterm></keywords>
</metadata></prolog>
<refbody>
-<example><title>CASE expression syntax</title><p>You can place a CASE expression
+<refsyn><title>CASE expression syntax</title><p>You can place a CASE expression
anywhere an expression is allowed. It chooses an expression to evaluate based
on a boolean test.</p> <codeblock><b>CASE
WHEN <i>booleanExpression</i> THEN <i>thenExpression</i>
@@ -33,8 +33,10 @@ on a boolean test.</p> <codeblock><b>CAS
END</b></codeblock> <p><i>ThenExpression</i> and <i>elseExpression</i> are
both expressions that must be type-compatible. For built-in types, this means
that the types must be the same or a built-in broadening conversion must exist
-between the types.</p><codeblock><b>-- returns 3
-VALUES CASE WHEN 1=1 THEN 3 ELSE 4 END</b></codeblock> <codeblock><b>
+between the types.</p></refsyn>
+<example><title>Example</title><codeblock><b>-- returns 3
+VALUES CASE WHEN 1=1 THEN 3 ELSE 4 END
+
-- returns 7
VALUES
CASE
Modified: db/derby/docs/trunk/src/ref/rrefcasenullif.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcasenullif.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcasenullif.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcasenullif.dita Fri Oct 29 17:11:19 2010
@@ -24,8 +24,13 @@ limitations under the License.
<keywords><indexterm>NULLIF expression</indexterm></keywords>
</metadata></prolog>
<refbody>
-<example><title>NULLIF expression syntax</title><codeblock><b>NULLIF ( L, R )</b></codeblock>The
-NULLIF expression is very similar to the CASE expression. For example: <codeblock><b>NULLIF(V1,V2)</b></codeblock> is
-equivalent to the following CASE expression:<codeblock><b>CASE WHEN V1=V2 THEN NULL ELSE V1 END</b></codeblock></example>
+<refsyn><title>NULLIF expression syntax</title>
+<codeblock><b>NULLIF ( L, R )</b></codeblock></refsyn>
+<section><p>The
+NULLIF expression is very similar to the CASE expression. For example,</p>
+<codeblock><b>NULLIF(V1,V2)</b></codeblock>
+<p>is
+equivalent to the following CASE expression:</p>
+<codeblock><b>CASE WHEN V1=V2 THEN NULL ELSE V1 END</b></codeblock></section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefclob.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefclob.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefclob.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefclob.dita Fri Oct 29 17:11:19 2010
@@ -32,12 +32,13 @@ is specified in characters (unicode) for
<refsyn><title>Syntax</title><codeblock><b>{CLOB |CHARACTER LARGE OBJECT} [ ( length [{K |M |G}] ) ]</b></codeblock> </refsyn>
<section><title>Default</title><p>A CLOB without a specified length is defaulted
to two giga characters (2,147,483,647).</p> </section>
-<section><title>Corresponding Compile-Time Java Type</title><p><i>java.sql.Clob</i></p> </section>
-<section><title>JDBC Metadata Type (java.sql.Types)</title><p>CLOB</p><p>Use
+<section><title>Corresponding compile-time Java type</title><p><i>java.sql.Clob</i></p> </section>
+<section><title>JDBC metadata type (java.sql.Types)</title><p>CLOB</p><p>Use
the <i>getClob</i> method on the <i>java.sql.ResultSet</i> to retrieve a CLOB
handle to the underlying data.</p> </section>
-<section><title>Related Information</title><p>See <xref href="rrefjdbc96386.dita#rrefjdbc96386"></xref>. </p> </section>
-<example> <codeblock>import java.sql.*;
+<section><title>Related information</title><p>See <xref href="rrefjdbc96386.dita#rrefjdbc96386"></xref>. </p> </section>
+<example><title>Example</title>
+<codeblock>import java.sql.*;
public class clob
{
Modified: db/derby/docs/trunk/src/ref/rrefcreatefrom.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcreatefrom.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcreatefrom.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcreatefrom.dita Fri Oct 29 17:11:19 2010
@@ -41,7 +41,8 @@ from a backup copy" in the <ph conref=".
<section><title>Combining with other attributes</title> <p>Do
not combine this attribute with <i>rollForwardRecoveryFrom</i>, <i>restoreFrom</i>, or
<i>create</i>.</p> </section>
-<example> <codeblock>URL: jdbc:derby:wombat;createFrom=d:/backup/wombat</codeblock> </example>
+<example><title>Example</title>
+<codeblock>URL: jdbc:derby:wombat;createFrom=d:/backup/wombat</codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefcurrentisolation.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcurrentisolation.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcurrentisolation.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcurrentisolation.dita Fri Oct 29 17:11:19 2010
@@ -30,6 +30,6 @@ or "RR".</p></section>
<refsyn><title>Syntax</title>
<codeblock><b>CURRENT ISOLATION</b></codeblock>
</refsyn>
-<example>
+<example><title>Example</title>
<codeblock><b>VALUES CURRENT ISOLATION</b></codeblock>
</example></refbody></reference>
Modified: db/derby/docs/trunk/src/ref/rrefdatefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefdatefunc.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefdatefunc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefdatefunc.dita Fri Oct 29 17:11:19 2010
@@ -42,7 +42,8 @@ January 1, 1970, where n is the integral
represented by the string.</li>
</ul></p></section>
<refsyn><title>Syntax</title> <codeblock><b>DATE ( <i>expression</i> )</b></codeblock> </refsyn>
-<example> <p>This example results in an internal representation of '1988-12-25'.</p> <codeblock><b>VALUES DATE('1988-12-25')</b></codeblock>
+<example><title>Examples</title>
+<p>This example results in an internal representation of '1988-12-25'.</p> <codeblock><b>VALUES DATE('1988-12-25')</b></codeblock>
<p>This example results in an internal representation of '1972-02-28'.</p> <codeblock><b>VALUES DATE(789)</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefidentityvallocal.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefidentityvallocal.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefidentityvallocal.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefidentityvallocal.dita Fri Oct 29 17:11:19 2010
@@ -22,21 +22,22 @@ limitations under the License.
<refbody>
<section><p><ph conref="../conrefs.dita#prod/productshortname"></ph> supports
the IDENTITY_VAL_LOCAL function. </p></section>
-<section><p><b>Syntax:</b> <codeblock> IDENTITY_VAL_LOCAL ( )</codeblock></p></section>
-<section><p>The IDENTITY_VAL_LOCAL function is a non-deterministic function
+<refsyn><title>Syntax:</title>
+<codeblock> IDENTITY_VAL_LOCAL ( )</codeblock>
+<p>The IDENTITY_VAL_LOCAL function is a non-deterministic function
that returns the most recently assigned value of an identity column for a
connection, where the assignment occurred as a result of a single row INSERT
-statement using a VALUES clause. </p></section>
-<section><p>The IDENTITY_VAL_LOCAL function has no input parameters. The result
+statement using a VALUES clause. </p>
+<p>The IDENTITY_VAL_LOCAL function has no input parameters. The result
is a DECIMAL (31,0), regardless of the actual data type of the corresponding
-identity column.</p></section>
-<section><p>The value returned by the IDENTITY_VAL_LOCAL function, for a connection,
+identity column.</p>
+<p>The value returned by the IDENTITY_VAL_LOCAL function, for a connection,
is the value assigned to the identity column of the table identified in the
most recent single row INSERT statement. The INSERT statement must contain
a VALUES clause on a table containing an identity column.
The function returns a null value when a single row INSERT statement with
-a VALUES clause has not been issued for a table containing an identity column.</p></section>
-<section><p>The result of the function is not affected by the following:
+a VALUES clause has not been issued for a table containing an identity column.</p>
+<p>The result of the function is not affected by the following:
<ul>
<li>A single row INSERT statement with a VALUES clause for a table without
an identity column</li>
@@ -45,9 +46,9 @@ a VALUES clause has not been issued for
</ul></p>If a table with an identity column has an INSERT trigger defined
that inserts into another table with another identity column, then the IDENTITY_VAL_LOCAL()
function will return the generated value for the statement table, and not
-for the table modified by the trigger.</section>
-<section><p><b>Examples:</b></p></section>
-<example> <codeblock>ij> create table t1(c1 int generated always as identity, c2 int);
+for the table modified by the trigger.</refsyn>
+<example><title>Examples</title>
+<codeblock>ij> create table t1(c1 int generated always as identity, c2 int);
0 rows inserted/updated/deleted
ij> insert into t1(c2) values (8);
1 row inserted/updated/deleted
Modified: db/derby/docs/trunk/src/ref/rrefjdbc28456.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc28456.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc28456.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc28456.dita Fri Oct 29 17:11:19 2010
@@ -32,8 +32,8 @@ allows you to specify an escape characte
<refsyn><title>Syntax</title> <codeblock><b>WHERE <i>CharacterExpression</i> [ NOT ] LIKE
<i> CharacterExpressionWithWildCard</i>
{ ESCAPE '<i>escapeCharacter</i>' }</b></codeblock> </refsyn>
-<example> <codeblock><b>
-<ph>-- find all rows in which a begins with the character "%"</ph>
+<example><title>Examples</title>
+<codeblock><b><ph>-- find all rows in which a begins with the character "%"</ph>
SELECT a FROM tabA WHERE a LIKE '$%%' {escape '$'}
<ph>-- find all rows in which a ends with the character "_"</ph>
SELECT a FROM tabA WHERE a LIKE '%=_' {escape '='}</b></codeblock> <note>?
Modified: db/derby/docs/trunk/src/ref/rrefjdbc37244.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc37244.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc37244.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc37244.dita Fri Oct 29 17:11:19 2010
@@ -34,7 +34,8 @@ information about join operations, see <
href="rrefsqlj29840.dita#rrefsqlj29840">JOIN operations</xref></i> ]* }</b></codeblock> </refsyn>
<section><title>Equivalent to</title> <codeblock><b><b><i><xref href="rrefsqlj29840.dita#rrefsqlj29840">JOIN operations</xref></i></b> [<b><i><xref
href="rrefsqlj29840.dita#rrefsqlj29840">JOIN operations</xref></i></b> ]* </b></codeblock> </section>
-<example> <codeblock><b><ph>-- outer join</ph>
+<example><title>Examples</title>
+<codeblock><b><ph>-- outer join</ph>
SELECT *
FROM
{oj Countries LEFT OUTER JOIN Cities ON
Modified: db/derby/docs/trunk/src/ref/rrefjdbc41784.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc41784.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc41784.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc41784.dita Fri Oct 29 17:11:19 2010
@@ -34,8 +34,8 @@ points).</p></section>
<refsyn><title>Syntax</title> <codeblock><b>{ts 'yyyy-mm-dd hh:mm:ss.f...'}</b></codeblock> </refsyn>
<section><title>Equivalent to</title> <codeblock><b>TIMESTAMP 'yyyy-mm-dd hh:mm:ss.f...'</b></codeblock> <p>The
fractional portion of timestamp constants (.f...) can be omitted.</p> </section>
-<example> <codeblock id="i1020504"><b>VALUES {ts '1999-01-09 20:11:11.123455'}<i
-id="jdbc61769"></i></b></codeblock> </example>
+<example><title>Example</title>
+<codeblock id="i1020504"><b>VALUES {ts '1999-01-09 20:11:11.123455'}</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefjdbc70824.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc70824.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc70824.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc70824.dita Fri Oct 29 17:11:19 2010
@@ -28,7 +28,8 @@ limitations under the License.
<section> <p>This syntax is supported for a <i>java.sql.Statement</i> and
a <i>java.sql.PreparedStatement </i>in addition to a <i>CallableStatement</i>.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>{<i>call</i> statement }</b></codeblock> </refsyn>
-<example> <p></p> <codeblock>-- Call a Java procedure
+<example><title>Example</title>
+<codeblock>-- Call a Java procedure
<b>{ call TOURS.BOOK_TOUR(?, ?) }</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefminutefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefminutefunc.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefminutefunc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefminutefunc.dita Fri Oct 29 17:11:19 2010
@@ -36,6 +36,7 @@ the null value.
<example> <title>Example</title>
<p>Select all rows from the "flights" table where the "departure_time"
is between 6:00 and 6:30 AM: </p>
-<codeblock><b>SELECT * FROM flights WHERE HOUR(departure_time) = 6 and MINUTE(departure_time) < 31;</b></codeblock> </example>
+<codeblock><b>SELECT * FROM flights
+ WHERE HOUR(departure_time) = 6 and MINUTE(departure_time) < 31;</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefrestorefrom.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefrestorefrom.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefrestorefrom.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefrestorefrom.dita Fri Oct 29 17:11:19 2010
@@ -39,7 +39,8 @@ from a backup copy" in the <ph conref=".
<section><title>Combining with other attributes</title> <p>Do
not combine this attribute with <i>createFrom</i>,
<i>rollForwardRecoveryFrom</i>, or <i>create</i>.</p> </section>
-<example> <codeblock>URL: jdbc:derby:wombat;restoreFrom=d:/backup/wombat</codeblock> </example>
+<example><title>Example</title>
+<codeblock>URL: jdbc:derby:wombat;restoreFrom=d:/backup/wombat</codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefrollforward.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefrollforward.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefrollforward.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefrollforward.dita Fri Oct 29 17:11:19 2010
@@ -39,7 +39,8 @@ in the <ph conref="../conrefs.dita#pub/c
<section><title>Combining with other attributes</title> <p>Do
not combine this attribute with <i>createFrom</i>, <i>restoreFrom</i>, or
<i>create</i>.</p> </section>
-<example> <codeblock>URL: jdbc:derby:wombat;rollForwardRecoveryFrom=d:/backup/wombat</codeblock> </example>
+<example><title>Example</title>
+<codeblock>URL: jdbc:derby:wombat;rollForwardRecoveryFrom=d:/backup/wombat</codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj10696.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj10696.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj10696.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj10696.dita Fri Oct 29 17:11:19 2010
@@ -26,15 +26,16 @@ limitations under the License.
<refbody>
<section> <p>INTEGER provides 4 bytes of storage for integer values.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>{ INTEGER | INT }</b></codeblock> </refsyn>
-<section><title>Corresponding Compile-Time Java Type</title> <p><i>java.lang.Integer</i></p> </section>
-<section><title>JDBC Metadata Type (java.sql.Types)</title> <p>INTEGER</p> </section>
-<section><title>Minimum Value</title> <p id="sqlj88368">-2147483648
+<section><title>Corresponding compile-time Java type</title> <p><i>java.lang.Integer</i></p> </section>
+<section><title>JDBC metadata type (java.sql.Types)</title> <p>INTEGER</p> </section>
+<section><title>Minimum value</title> <p id="sqlj88368">-2147483648
(<i>java.lang.Integer.MIN_VALUE</i>)</p> </section>
-<section><title>Maximum Value</title> <p id="sqlj81992">2147483647 (<i>java.lang.Integer.MAX_VALUE</i>)</p> <p>When
+<section><title>Maximum value</title> <p id="sqlj81992">2147483647 (<i>java.lang.Integer.MAX_VALUE</i>)</p> <p>When
mixed with other data types in expressions, the resulting data type follows
the rules shown in <xref href="rrefsqlj27767.dita#rrefsqlj27767"></xref>.</p> <p>See
also <xref href="rrefsqlj20204.dita#rrefsqlj20204"></xref>.</p> </section>
-<example> <codeblock><b>3453
+<example><title>Examples</title>
+<codeblock><b>3453
425</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj12362.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj12362.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj12362.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj12362.dita Fri Oct 29 17:11:19 2010
@@ -28,8 +28,9 @@ limitations under the License.
behaves the same way. See <xref href="rrefsqlj15260.dita#rrefsqlj15260"></xref>.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>NUMERIC [(<i>precision</i> [, <i>scale</i> ])]</b></codeblock> </refsyn>
<section><title>Corresponding compile-time Java type</title> <p><i>java.math.BigDecimal</i></p> </section>
-<section><title>JDBC metadata Ttype (java.sql.Types)</title> <p>NUMERIC</p> </section>
-<example> <codeblock><b>123.456
+<section><title>JDBC metadata type (java.sql.Types)</title> <p>NUMERIC</p> </section>
+<example><title>Examples</title>
+<codeblock><b>123.456
.001</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj13083.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj13083.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj13083.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj13083.dita Fri Oct 29 17:11:19 2010
@@ -38,7 +38,8 @@ column references or expressions, but it
or subquery. It must evaluate to a built-in numeric data type. If an expression
evaluates to NULL, the aggregate skips that value.</p> <p>The resulting data
type is the same as the expression on which it operates (it might overflow).</p> </refsyn>
-<example> <codeblock><b>-- find all economy seats available:
+<example><title>Examples</title>
+<codeblock><b>-- find all economy seats available:
SELECT SUM (economy_seats) FROM Airlines;
-- use SUM on multiple column references
Modified: db/derby/docs/trunk/src/ref/rrefsqlj14854.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj14854.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj14854.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj14854.dita Fri Oct 29 17:11:19 2010
@@ -44,7 +44,7 @@ appear within an aggregate, and it is no
If the HAVING clause contains a subquery, the subquery can refer to the outer
query block if and only if it refers to a grouping column.</p>
</refsyn>
-<example>
+<example><title>Example</title>
<codeblock><b><ph>-- Find the total number of economy seats taken on a flight,
-- grouped by airline,
-- only when the group has at least 2 records. </ph>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj15260.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj15260.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj15260.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj15260.dita Fri Oct 29 17:11:19 2010
@@ -50,13 +50,15 @@ other data types in expressions, the res
shown in <xref href="rrefsqlj27767.dita#rrefsqlj27767"></xref>.</p> <p>See also <xref
href="rrefsqlj20204.dita#rrefsqlj20204"></xref>. </p> <p>When two decimal values are
mixed in an expression, the scale and precision of the resulting value follow
-the rules shown in <xref href="rrefsqlj36146.dita#rrefsqlj36146"></xref>.</p> </refsyn>
+the rules shown in <xref href="rrefsqlj36146.dita#rrefsqlj36146"></xref>.</p>
+<p>Integer constants too big for BIGINT are made
+DECIMAL constants.</p> </refsyn>
<section><title>Corresponding compile-time Java type</title> <p><i>java.math.BigDecimal</i></p> </section>
<section><title>JDBC metadata type (java.sql.Types)</title> <p>DECIMAL</p> </section>
-<example> <codeblock><b>VALUES 123.456
+<example><title>Examples</title>
+<codeblock><b>VALUES 123.456
-VALUES 0.001</b></codeblock> <p>Integer constants too big for BIGINT are made
-DECIMAL constants.</p> </example>
+VALUES 0.001</b></codeblock></example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj15309.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj15309.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj15309.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj15309.dita Fri Oct 29 17:11:19 2010
@@ -30,7 +30,7 @@ cursors. For more information about upda
<refsyn><title>Syntax</title>
<codeblock><b>WHERE CURRENT OF <i><xref href="rrefcursorname.dita#rrefcursorname">cursor-Name</xref></i></b></codeblock>
</refsyn>
-<example>
+<example><title>Example</title>
<codeblock expanse="column">Statement s = conn.createStatement();
s.setCursorName("AirlinesResults");
ResultSet rs = conn.executeQuery(
Modified: db/derby/docs/trunk/src/ref/rrefsqlj15866.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj15866.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj15866.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj15866.dita Fri Oct 29 17:11:19 2010
@@ -33,8 +33,9 @@ in a cursor.</p></section>
<p>or, alternately</p>
<codeblock><b>CURRENT TIMESTAMP</b></codeblock>
</refsyn>
-<example>
+<example><title>Examples</title>
<codeblock><b>VALUES CURRENT_TIMESTAMP
+
<ph>-- or, alternately:</ph>
VALUES CURRENT TIMESTAMP</b></codeblock>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj16762.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj16762.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj16762.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj16762.dita Fri Oct 29 17:11:19 2010
@@ -29,7 +29,8 @@ a bit string expression and returns the
all built-in data types are implicitly converted to strings, this function
can act on all built-in data types.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>LENGTH ( { <i>CharacterExpression</i> | <i>BitExpression</i> } )</b></codeblock> </refsyn>
-<example> <codeblock><b><ph>-- returns 20</ph>
+<example><title>Examples</title>
+<codeblock><b><ph>-- returns 20</ph>
VALUES LENGTH('supercalifragilistic')
<ph>-- returns 1</ph>
VALUES LENGTH(X'FF')
Modified: db/derby/docs/trunk/src/ref/rrefsqlj18922.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj18922.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj18922.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj18922.dita Fri Oct 29 17:11:19 2010
@@ -38,7 +38,8 @@ the shape of the second (right) table.</
the current tables and any tables in query blocks outer to the current SELECT.
The ON clause can reference tables not being joined and does not have to
reference either of the tables being joined (though typically it does).</p> </refsyn>
-<example><title>Example 1</title><codeblock><b>--match cities to countries in Asia</b>
+<example><title>Example 1</title>
+<codeblock><b>-- match cities to countries in Asia</b>
SELECT CITIES.COUNTRY, CITIES.CITY_NAME, REGION
FROM Countries
@@ -55,8 +56,8 @@ LEFT JOIN CITIES
ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE
WHERE REGION = 'Asia'
</codeblock></example>
-<example><title>Example 2</title><codeblock><b>
--- Join the EMPLOYEE and DEPARTMENT tables,
+<example><title>Example 2</title>
+<codeblock><b>-- Join the EMPLOYEE and DEPARTMENT tables,
-- select the employee number (EMPNO),
-- employee surname (LASTNAME),
-- department number (WORKDEPT in the EMPLOYEE table
Modified: db/derby/docs/trunk/src/ref/rrefsqlj21583.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj21583.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj21583.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj21583.dita Fri Oct 29 17:11:19 2010
@@ -28,7 +28,8 @@ limitations under the License.
specifies the tables (<i><xref href="rreftableexpression.dita#rreftableexpression">TableExpression</xref></i>)
from which the other clauses of the query can access columns for use in expressions. </p></section>
<refsyn><title>Syntax</title> <codeblock><b>FROM TableExpression [ , TableExpression ] *</b></codeblock> </refsyn>
-<example> <codeblock><b>SELECT Cities.city_id
+<example><title>Examples</title>
+<codeblock><b>SELECT Cities.city_id
FROM Cities
WHERE city_id < 5
<ph>-- other types of TableExpressions</ph>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj25228.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj25228.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj25228.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj25228.dita Fri Oct 29 17:11:19 2010
@@ -42,7 +42,8 @@ or
</p>
</section>
<refsyn><title>Syntax</title> <codeblock><b>SESSION_USER</b></codeblock> </refsyn>
-<example> <codeblock><b>VALUES SESSION_USER</b></codeblock> </example>
+<example><title>Example</title>
+<codeblock><b>VALUES SESSION_USER</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj27781.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj27781.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj27781.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj27781.dita Fri Oct 29 17:11:19 2010
@@ -46,7 +46,8 @@ For example, if the values 'z' and 'z '
control which one will be returned as the maximum, because blank spaces are
ignored for character comparisons.</p> <p>The resulting data type is the same as the expression on
which it operates (it will never overflow).</p> </refsyn>
-<example> <codeblock><b><ph>-- find the latest date in the FlightAvailability table</ph>
+<example><title>Examples</title>
+<codeblock><b><ph>-- find the latest date in the FlightAvailability table</ph>
SELECT MAX (flight_date) FROM FlightAvailability
<ph>-- find the longest flight originating from each airport,
-- but only when the longest flight is over 10 hours</ph>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj30435.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj30435.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj30435.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj30435.dita Fri Oct 29 17:11:19 2010
@@ -38,7 +38,8 @@ a smaller size fails if the value cannot
Integer types can always successfully be placed in approximate numeric values,
although with the possible loss of some precision. BIGINTs can be stored in
DECIMALs if the DECIMAL precision is large enough for the value.</p> </section>
-<example> <codeblock><b>9223372036854775807</b></codeblock> </example>
+<example><title>Example</title>
+<codeblock><b>9223372036854775807</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj31648.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj31648.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj31648.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj31648.dita Fri Oct 29 17:11:19 2010
@@ -32,7 +32,8 @@ default user schema) nor the <i>SYS</i>
>The RESTRICT keyword enforces the rule that no objects can be defined in
the specified schema for the schema to be deleted from the database. The RESTRICT
keyword is required</p> </refsyn>
-<example> <codeblock><b><ph>-- Drop the SAMP schema
+<example><title>Example</title>
+<codeblock><b><ph>-- Drop the SAMP schema
-- The SAMP schema may only be deleted from the database
-- if no objects are defined in the SAMP schema.</ph>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj31783.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj31783.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj31783.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj31783.dita Fri Oct 29 17:11:19 2010
@@ -49,11 +49,12 @@ generates the JDBC ResultSet to have con
</note></p>
<p>The optimizer is able to use an index even if the column in
the index is being updated.</p>
-</section>
-<example> <codeblock><b>SELECT RECEIVED, SOURCE, SUBJECT, NOTE_TEXT FROM SAMP.IN_TRAY FOR UPDATE
-</b></codeblock>
<p>For information about how indexes affect performance, see
<ph conref="../conrefs.dita#pub/cittuning"></ph>.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>SELECT RECEIVED, SOURCE, SUBJECT, NOTE_TEXT FROM SAMP.IN_TRAY FOR UPDATE
+</b></codeblock>
</example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj32268.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj32268.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj32268.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj32268.dita Fri Oct 29 17:11:19 2010
@@ -48,7 +48,8 @@ that can be used in prepared statements.
once and then executed with different schema values. The schema values are
treated as string constants so they are case sensitive. For example, to designate
the <i>APP</i> schema, use the string "APP" rather than "app". </p> </refsyn>
-<example> <codeblock><b><ph>-- the following are all equivalent and will work
+<example><title>Examples</title>
+<codeblock><b><ph>-- The following are all equivalent and will work
-- assuming a schema called HOTEL </ph>
SET SCHEMA HOTEL
SET SCHEMA hotel
@@ -59,15 +60,16 @@ SET CURRENT SCHEMA = hotel
SET CURRENT SQLID = hotel
SET SCHEMA "HOTEL" <ph>-- quoted identifier</ph>
SET SCHEMA 'HOTEL' <ph>-- quoted string</ph>
- <ph>--This example produces an error because
- --lower case hotel won't be found</ph>
+ <ph>-- This example produces an error because
+ -- lower case hotel won't be found</ph>
SET SCHEMA = 'hotel'
-<ph> --This example produces an error because SQLID is not
- --allowed without CURRENT</ph>
+<ph> -- This example produces an error because SQLID is not
+ -- allowed without CURRENT</ph>
SET SQLID hotel
<ph> -- This sets the schema to the current user id </ph>
SET CURRENT SCHEMA USER
-<ph>// Here's an example of using set schema in an Java program </ph>
+
+<ph>// Here's an example of using SET SCHEMA in an Java program </ph>
PreparedStatement ps = conn.PrepareStatement("set schema ?");
ps.setString(1,"HOTEL");
ps.executeUpdate();
Modified: db/derby/docs/trunk/src/ref/rrefsqlj32613.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj32613.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj32613.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj32613.dita Fri Oct 29 17:11:19 2010
@@ -29,7 +29,8 @@ limitations under the License.
CharacterExpression is a CHAR, VARCHAR, or LONG VARCHAR data type, any built-in
type that is implicitly converted to a string.</p> <p>RTRIM returns NULL if <i>CharacterExpression</i> evaluates
to null. </p> </refsyn>
-<example> <codeblock><b><ph>-- returns ' asdf'</ph>
+<example><title>Examples</title>
+<codeblock><b><ph>-- returns ' asdf'</ph>
VALUES RTRIM(' asdf ')
<ph>-- returns 'asdf'</ph>
VALUES RTRIM('asdf ')</b></codeblock> </example>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj32654.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj32654.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj32654.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj32654.dita Fri Oct 29 17:11:19 2010
@@ -46,7 +46,8 @@ outside the current scope. For example,
it cannot refer to columns in the outer query.</p> <p><i>SelectItems</i> in
the <i><xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpression</xref></i> with
a GROUP BY clause must contain only aggregates or grouping columns.</p> </refsyn>
-<example> <codeblock><b><ph>-- find the average flying_times of flights grouped by
+<example><title>Examples</title>
+<codeblock><b><ph>-- find the average flying_times of flights grouped by
-- airport</ph>
SELECT AVG (flying_time), orig_airport
FROM Flights
Modified: db/derby/docs/trunk/src/ref/rrefsqlj32714.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj32714.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj32714.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj32714.dita Fri Oct 29 17:11:19 2010
@@ -37,9 +37,9 @@ strings<indexterm>variable-length</index
stores variable-length byte strings. Unlike CHAR FOR BIT DATA values, VARCHAR
FOR BIT DATA values are not padded out to the target length.</p> <p>An operation
on a VARCHAR FOR BIT DATA and a CHAR FOR BIT DATA value (e.g., a concatenation)
-yields a VARCHAR FOR BIT DATA value.</p> </section>
-<example> <p>The type of a byte literal is always a
-VARCHAR FOR BIT DATA, not a CHAR FOR BIT DATA.</p> </example>
+yields a VARCHAR FOR BIT DATA value.</p>
+<p>The type of a byte literal is always a
+VARCHAR FOR BIT DATA, not a CHAR FOR BIT DATA.</p> </section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj33520.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj33520.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj33520.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj33520.dita Fri Oct 29 17:11:19 2010
@@ -46,7 +46,8 @@ control which one will be returned as th
ignored for character comparisons.</p> <p>The
resulting data type is the same as the expression on which it operates (it
will never overflow).</p> </refsyn>
-<example> <codeblock><b><ph>-- NOT valid:</ph>
+<example><title>Examples</title>
+<codeblock><b><ph>-- NOT valid:</ph>
SELECT DISTINCT flying_time, MIN(DISTINCT miles) from Flights
<ph>-- valid:</ph>
SELECT COUNT(DISTINCT flying_time), MIN(DISTINCT miles) from Flights
Modified: db/derby/docs/trunk/src/ref/rrefsqlj33562.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj33562.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj33562.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj33562.dita Fri Oct 29 17:11:19 2010
@@ -762,7 +762,12 @@ DATE component is set to the value of CU
executed. If a TIMESTAMP is converted to a DATE, the TIME component is silently
truncated. If a TIMESTAMP is converted to a TIME, the DATE component is silently
truncated.</p> </section>
-<example> <codeblock><b>SELECT CAST (miles AS INT)
+<section><title>Conversions of XML values</title><p>An XML value cannot be
+converted to any non-XML type using an explicit or implicit CAST. Use the <xref
+href="rreffuncxmlserialize.dita#rreffuncxmlserialize"></xref> to convert an
+XML type to a character type.</p> </section>
+<example><title>Examples</title>
+<codeblock><b>SELECT CAST (miles AS INT)
FROM Flights
-- convert timestamps to text
INSERT INTO mytable (text_column)
@@ -777,9 +782,5 @@ SELECT CAST (FLYING_TIME AS DECIMAL(5,2)
FROM FLIGHTS
-- cast a SMALLINT to a BIGINT
VALUES CAST (CAST (12 as SMALLINT) as BIGINT)</b></codeblock> </example>
-<section><title>Conversions of XML values</title><p>An XML value cannot be
-converted to any non-XML type using an explicit or implicit CAST. Use the <xref
-href="rreffuncxmlserialize.dita#rreffuncxmlserialize"></xref> to convert an
-XML type to a character type.</p> </section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj33602.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj33602.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj33602.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj33602.dita Fri Oct 29 17:11:19 2010
@@ -37,8 +37,8 @@ href="rrefsqlj19433.dita#rrefsqlj19433/s
boolean value. </p> <p>In addition, there are the more common boolean expressions.
Specific boolean operators listed in Table 10, take one or more operands;
the expressions return a boolean value.</p> </refsyn>
-<example><title>Example</title><codeblock><b>
-<ph>-- find the flights where no business-class seats have
+<example><title>Example</title>
+<codeblock><b><ph>-- find the flights where no business-class seats have
-- been booked</ph>
SELECT *
FROM FlightAvailability
Modified: db/derby/docs/trunk/src/ref/rrefsqlj33772.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj33772.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj33772.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj33772.dita Fri Oct 29 17:11:19 2010
@@ -30,7 +30,9 @@ the value is fixed even if there is a lo
a cursor.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>CURRENT_TIME</b></codeblock> <p>or,
alternately</p> <codeblock><b>CURRENT TIME</b></codeblock> </refsyn>
-<example> <codeblock><b>VALUES CURRENT_TIME
+<example><title>Examples</title>
+<codeblock><b>VALUES CURRENT_TIME
+
<ph>-- or, alternately:</ph>
VALUES CURRENT TIME</b></codeblock> </example>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj34177.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj34177.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj34177.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj34177.dita Fri Oct 29 17:11:19 2010
@@ -30,7 +30,8 @@ the value is fixed even if there is a lo
a cursor.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>CURRENT_DATE</b></codeblock> <p>or,
alternately</p> <codeblock><b>CURRENT DATE</b></codeblock> </refsyn>
-<example> <codeblock><b><ph>-- find available future flights:</ph>
+<example><title>Example</title>
+<codeblock><b><ph>-- find available future flights:</ph>
SELECT * FROM Flightavailability where flight_date > CURRENT_DATE;</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj35034.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj35034.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj35034.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj35034.dita Fri Oct 29 17:11:19 2010
@@ -45,7 +45,8 @@ ON EMPLOYEE.SALARY < STAFF.SALARY
</b></codeblock></p> <p>The ON clause can reference tables not being joined
and does not have to reference either of the tables being joined (though typically
it does). </p> </refsyn>
-<example> <codeblock><b><ph>-- Join the EMP_ACT and EMPLOYEE tables</ph>
+<example><title>Examples</title>
+<codeblock><b><ph>-- Join the EMP_ACT and EMPLOYEE tables</ph>
-- select all the columns from the EMP_ACT table and
-- add the employee's surname (LASTNAME) from the EMPLOYEE table
-- to each row of the result
Modified: db/derby/docs/trunk/src/ref/rrefsqlj38716.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj38716.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj38716.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj38716.dita Fri Oct 29 17:11:19 2010
@@ -39,7 +39,8 @@ FROM Flights</b></codeblock><p>An <i>Exp
references or expressions, but it cannot contain another aggregate or subquery.
If an <i>Expression</i> evaluates to NULL, the aggregate is not processed
for that value.</p><p>The resulting data type of COUNT is <xref href="rrefsqlj10696.dita#rrefsqlj10696">INTEGER</xref>.</p> </refsyn>
-<example> <codeblock><b><ph>-- Count the number of countries in each region,
+<example><title>Example</title>
+<codeblock><b><ph>-- Count the number of countries in each region,
-- show only regions that have at least 2</ph>
SELECT COUNT (country), region
FROM Countries
Modified: db/derby/docs/trunk/src/ref/rrefsqlj40899.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj40899.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj40899.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj40899.dita Fri Oct 29 17:11:19 2010
@@ -38,7 +38,8 @@ of this operator.</p> <p>The length of t
the lengths of both operands. </p> <p>For bit strings, if both the left and
the right operands are of type CHAR FOR BIT DATA, the resulting type is CHAR
FOR BIT DATA; otherwise, it is VARCHAR FOR BIT DATA.</p> </refsyn>
-<example> <codeblock><b><ph>--returns 'supercalifragilisticexbealidocious(sp?)'</ph>
+<example><title>Examples</title>
+<codeblock><b><ph>-- returns 'supercalifragilisticexbealidocious(sp?)'</ph>
VALUES 'supercalifragilistic' || 'exbealidocious' || '(sp?)'
<ph>-- returns NULL</ph>
VALUES CAST (null AS VARCHAR(7))|| 'AString'
Modified: db/derby/docs/trunk/src/ref/rrefsqlj41180.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj41180.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj41180.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj41180.dita Fri Oct 29 17:11:19 2010
@@ -48,7 +48,8 @@ RR | REPEATABLE READ | SERIALIZABLE
RESET
}
</b></codeblock> </refsyn>
-<example> <codeblock><b>set isolation serializable;</b></codeblock> </example>
+<example><title>Example</title>
+<codeblock><b>set isolation serializable;</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj42049.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj42049.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj42049.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj42049.dita Fri Oct 29 17:11:19 2010
@@ -34,7 +34,8 @@ the return type is VARCHAR.</p> <p>The l
value are the same as the length and maximum length of the parameter. </p> <p>If
the <i>CharacterExpression</i> evaluates to null, this function returns null.
</p> </refsyn>
-<example> <codeblock><b><ph>-- returns 'asd1#w'</ph>
+<example><title>Examples</title>
+<codeblock><b><ph>-- returns 'asd1#w'</ph>
VALUES LOWER('aSD1#w')
SELECT LOWER(flight_id) FROM Flights</b></codeblock> </example>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj42082.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj42082.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj42082.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj42082.dita Fri Oct 29 17:11:19 2010
@@ -27,7 +27,8 @@ limitations under the License.
<refbody>
<section> <p>DROP TRIGGER removes the specified trigger.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>DROP TRIGGER <i><xref href="rreftriggername.dita#rreftriggername">TriggerName</xref></i></b></codeblock> </refsyn>
-<example> <codeblock><b>DROP TRIGGER TRIG1</b></codeblock> </example>
+<example><title>Example</title>
+<codeblock><b>DROP TRIGGER TRIG1</b></codeblock> </example>
<section><title>Statement dependency system</title> <p>When a
table is dropped, all triggers on that table are automatically dropped. (You
don't have to drop a table's triggers before dropping the table.)</p> </section>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj42324.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj42324.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj42324.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj42324.dita Fri Oct 29 17:11:19 2010
@@ -42,7 +42,8 @@ or
</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>
+<example><title>Example</title>
+<codeblock><b>VALUES CURRENT_USER</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj42476.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj42476.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj42476.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj42476.dita Fri Oct 29 17:11:19 2010
@@ -42,7 +42,8 @@ or
</p>
</section>
<refsyn><title>Syntax</title><codeblock><b>USER</b></codeblock> </refsyn>
-<example> <codeblock><b>VALUES USER</b></codeblock> </example>
+<example><title>Example</title>
+<codeblock><b>VALUES USER</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj43125.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj43125.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj43125.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj43125.dita Fri Oct 29 17:11:19 2010
@@ -160,7 +160,8 @@ check).</li>
</ul></p> <p>When multiple triggers are defined for the same database event
for the same table for the same trigger time (before or after), triggers are
fired in the order in which they were created.</p> </section>
-<example> <codeblock><b><ph>-- Statements and triggers:
+<example><title>Examples</title>
+<codeblock><b><ph>-- Statements and triggers:
</ph>
CREATE TRIGGER t1 NO CASCADE BEFORE UPDATE ON x
FOR EACH ROW MODE DB2SQL
Modified: db/derby/docs/trunk/src/ref/rrefsqlj57924.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj57924.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj57924.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj57924.dita Fri Oct 29 17:11:19 2010
@@ -40,14 +40,15 @@ same length. (This differs from the way
but works as specified in SQL-92.)</p> <p>An operation on a VARCHAR FOR BIT
DATA and a CHAR FOR BIT DATA value (e.g., a concatenation) yields a VARCHAR
FOR BIT DATA value.</p> </section>
-<example> <p> <codeblock><b>CREATE TABLE t (b CHAR(2) FOR BIT DATA);
+<example><title>Example</title>
+<codeblock><b>CREATE TABLE t (b CHAR(2) FOR BIT DATA);
INSERT INTO t VALUES (X'DE');
SELECT *
FROM t;
<ph>-- yields the following output</ph>
B
-----
-de20</b></codeblock></p> </example>
+de20</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj59893.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj59893.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj59893.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj59893.dita Fri Oct 29 17:11:19 2010
@@ -26,7 +26,8 @@ limitations under the License.
<refbody>
<section> <p>DROP INDEX removes the specified index.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>DROP INDEX <i><xref href="rrefindexname.dita#rrefindexname">index-Name</xref></i></b></codeblock> </refsyn>
-<example> <codeblock><b>DROP INDEX OrigIndex
+<example><title>Examples</title>
+<codeblock><b>DROP INDEX OrigIndex
DROP INDEX DestIndex</b></codeblock> </example>
<section><title>Statement dependency system</title> <p>If there
Modified: db/derby/docs/trunk/src/ref/rrefsqlj61102.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj61102.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj61102.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj61102.dita Fri Oct 29 17:11:19 2010
@@ -27,7 +27,8 @@ limitations under the License.
<refbody>
<section> <p>Drops the specified view.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>DROP VIEW <xref href="rrefviewname.dita#rrefviewname">view-Name</xref></b></codeblock> </refsyn>
-<example> <codeblock><b>DROP VIEW AnIdentifier</b></codeblock> </example>
+<example><title>Example</title>
+<codeblock><b>DROP VIEW AnIdentifier</b></codeblock> </example>
<section><title>Statement dependency system</title> <p>Any statements
referencing the view are invalidated on a DROP VIEW statement. DROP VIEW is
disallowed if there are any views or open cursors dependent on the view. The
Modified: db/derby/docs/trunk/src/ref/rrefsqlj61998.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj61998.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj61998.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj61998.dita Fri Oct 29 17:11:19 2010
@@ -55,19 +55,19 @@ If the desired string is not found, LOCA
value is passed for either of the CharacterExpression arguments,
NULL is returned.</p>
</refsyn>
-<example>
- <codeblock><b><ph>-- returns 2, since 'love' is found at index position 2:</ph>
- VALUES LOCATE('love', 'clover')</b></codeblock>
- <codeblock><b><ph>-- returns 0, since 'stove' is not found in 'clover':</ph>
- VALUES LOCATE('stove', 'clover')</b></codeblock>
- <codeblock><b><ph>-- returns 5 (note the start position is 4):</ph>
- VALUES LOCATE('iss', 'Mississippi', 4)</b></codeblock>
- <codeblock><b><ph>-- returns 1, because the empty string is a special case:</ph>
- VALUES LOCATE('', 'ABC')</b></codeblock>
- <codeblock><b><ph>-- returns 0, because 'AAA' is not found in '':</ph>
- VALUES LOCATE('AAA', '')</b></codeblock>
- <codeblock><b><ph>-- returns 3</ph>
- VALUES LOCATE('', '', 3)</b></codeblock>
+<example><title>Examples</title>
+<codeblock><b><ph>-- returns 2, since 'love' is found at index position 2:</ph>
+VALUES LOCATE('love', 'clover')</b></codeblock>
+<codeblock><b><ph>-- returns 0, since 'stove' is not found in 'clover':</ph>
+VALUES LOCATE('stove', 'clover')</b></codeblock>
+<codeblock><b><ph>-- returns 5 (note the start position is 4):</ph>
+VALUES LOCATE('iss', 'Mississippi', 4)</b></codeblock>
+<codeblock><b><ph>-- returns 1, because the empty string is a special case:</ph>
+VALUES LOCATE('', 'ABC')</b></codeblock>
+<codeblock><b><ph>-- returns 0, because 'AAA' is not found in '':</ph>
+VALUES LOCATE('AAA', '')</b></codeblock>
+<codeblock><b><ph>-- returns 3</ph>
+VALUES LOCATE('', '', 3)</b></codeblock>
</example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj66113.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj66113.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj66113.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj66113.dita Fri Oct 29 17:11:19 2010
@@ -28,7 +28,8 @@ accessed. No NULLs or duplicates are eli
on an expression.</p></section>
<refsyn><title>Syntax</title><codeblock><b>COUNT(*)</b></codeblock><p>The
resulting data type is <xref href="rrefsqlj10696.dita#rrefsqlj10696">INTEGER</xref>.</p> </refsyn>
-<example> <codeblock><b><ph>-- Count the number of rows in the Flights table</ph>
+<example><title>Example</title>
+<codeblock><b><ph>-- Count the number of rows in the Flights table</ph>
SELECT COUNT(*)
FROM Flights</b></codeblock> </example>
</refbody>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj73147.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj73147.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj73147.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj73147.dita Fri Oct 29 17:11:19 2010
@@ -31,7 +31,8 @@ PRECISION</xref> are supported. The retu
parameter.</p> <note>To execute SQRT on other data types, you must cast them
to floating point types. </note></section>
<refsyn><title>Syntax</title> <codeblock id="i1195048"><b>SQRT(<i>FloatingPointExpression</i>)</b></codeblock> </refsyn>
-<example> <codeblock><b>-- throws an exception if any row stores a negative number:
+<example><title>Examples</title>
+<codeblock><b>-- throws an exception if any row stores a negative number:
VALUES SQRT(3421E+09)
-- returns the square root of an INTEGER after casting it as a
Modified: db/derby/docs/trunk/src/ref/rrefsqlj95598.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj95598.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj95598.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj95598.dita Fri Oct 29 17:11:19 2010
@@ -27,7 +27,8 @@ limitations under the License.
<section> <p>This statement allows you to rename an index in the current schema.
Users cannot rename indexes in the <i>SYS</i> schema.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>RENAME INDEX <i>index-Name</i> TO <i>new-index-Name</i></b></codeblock> </refsyn>
-<example> <codeblock><b>RENAME INDEX DESTINDEX TO ARRIVALINDEX</b></codeblock> </example>
+<example><title>Example</title>
+<codeblock><b>RENAME INDEX DESTINDEX TO ARRIVALINDEX</b></codeblock> </example>
<section><title>Statement dependency system</title> <p>RENAME
INDEX is not allowed if there are any open cursors that reference the index
being renamed.</p> </section>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj97870.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj97870.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj97870.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj97870.dita Fri Oct 29 17:11:19 2010
@@ -30,7 +30,8 @@ expression.</p></section>
a CHAR, VARCHAR, or LONG VARCHAR data type, any built-in type that is implicitly
converted to a string.</p> <p>LTRIM returns NULL if <i>CharacterExpression</i> evaluates
to null. </p> </refsyn>
-<example> <codeblock><b><ph>-- returns 'asdf '</ph>
+<example><title>Example</title>
+<codeblock><b><ph>-- returns 'asdf '</ph>
VALUES LTRIM(' asdf ')</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj98067.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj98067.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj98067.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj98067.dita Fri Oct 29 17:11:19 2010
@@ -31,7 +31,8 @@ href="rrefsqlj10696.dita#rrefsqlj10696">
href="rrefsqlj12362.dita#rrefsqlj12362">NUMERIC</xref>, <xref href="rrefsqlj14122.dita#rrefsqlj14122">REAL</xref>,
and <xref href="rrefsqlj16221.dita#rrefsqlj16221">SMALLINT</xref>).</p></section>
<refsyn><title>Syntax</title> <codeblock id="i1195049"><b>ABS(<i>NumericExpression</i>)</b></codeblock> </refsyn>
-<example> <codeblock><b><ph>-- returns 3</ph>
+<example><title>Example</title>
+<codeblock><b><ph>-- returns 3</ph>
VALUES ABS(-3)</b></codeblock> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqljBoolean.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljBoolean.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljBoolean.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljBoolean.dita Fri Oct 29 17:11:19 2010
@@ -41,10 +41,8 @@ For comparisons and ordering operations,
</p>
</section>
-<example>
-<title>Examples</title>
-<codeblock><b>
-values true
+<example><title>Examples</title>
+<codeblock><b>values true
values false
values cast (null as boolean)
</b></codeblock>
Modified: db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita Fri Oct 29 17:11:19 2010
@@ -47,6 +47,8 @@ href="rrefsynonymname.dita#rrefsynonymna
the synonym name you are giving the target table or view, while the <xref
href="rrefviewname.dita#rrefviewname">view-Name</xref> or <xref href="rreftablename.dita#rreftablename">table-Name</xref> represents
the original name of the target table or view.</section>
-<example><title>Example</title>CREATE SYNONYM SAMP.T1 FOR SAMP.TABLEWITHLONGNAME</example>
+<example><title>Example</title>
+<codeblock><b>CREATE SYNONYM SAMP.T1 FOR SAMP.TABLEWITHLONGNAME</b></codeblock>
+</example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsqljcurrentschema.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljcurrentschema.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljcurrentschema.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljcurrentschema.dita Fri Oct 29 17:11:19 2010
@@ -32,7 +32,8 @@ synonyms.</note> <p>These functions retu
<b>-- or, alternately:</b>
CURRENT SQLID</b></codeblock> </refsyn>
-<example> <codeblock><b><ph>-- Set the name column default to the current schema:</ph>
+<example><title>Example</title>
+<codeblock><b><ph>-- Set the name column default to the current schema:</ph>
CREATE TABLE mytable (id int, name VARCHAR(128) DEFAULT CURRENT SQLID)
<ph>-- Inserts default value of current schema value into the table:</ph>
INSERT INTO mytable(id) VALUES (1)