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 [2/2] - in /db/derby/docs/trunk/src: adminguide/ ref/
tools/
Modified: db/derby/docs/trunk/src/ref/rrefsqljoffsetfetch.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljoffsetfetch.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljoffsetfetch.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljoffsetfetch.dita Fri Oct 29 17:11:19 2010
@@ -71,10 +71,8 @@ the clause is omitted entirely, all rows
a <i>result offset clause</i> is also given) will be returned.
</p>
</refsyn>
-<example>
- <title>Examples</title>
- <codeblock><b>
--- Fetch the first row of T
+<example><title>Examples</title>
+ <codeblock><b>-- Fetch the first row of T
SELECT * FROM T FETCH FIRST ROW ONLY
-- Sort T using column I, then fetch rows 11 through 20 of the sorted
Modified: db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita Fri Oct 29 17:11:19 2010
@@ -35,8 +35,9 @@ href="rrefnewtablename.dita#rrefnewtable
there is a view or foreign key that references the table, attempts to rename
it will generate an error. In addition, if there are any check constraints
or triggers on the table, attempts to rename it will also generate an error.</p> </refsyn>
-<example> <codeblock><b>RENAME TABLE SAMP.EMP_ACT TO EMPLOYEE_ACT</b></codeblock> <p>Also
-see <xref href="rrefsqlj81859.dita#rrefsqlj81859"></xref> for more information.</p> </example>
+<example><title>Example</title>
+<codeblock><b>RENAME TABLE SAMP.EMP_ACT TO EMPLOYEE_ACT</b></codeblock>
+<p>See <xref href="rrefsqlj81859.dita#rrefsqlj81859"></xref> for more information.</p> </example>
<section><title>Statement dependency system</title>
<p>The RENAME TABLE statement
is not allowed if there are any open cursors that reference the table that
Modified: db/derby/docs/trunk/src/ref/rrefsqljtfinvoke.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljtfinvoke.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljtfinvoke.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljtfinvoke.dita Fri Oct 29 17:11:19 2010
@@ -24,19 +24,12 @@ limitations under the License.
<example>
<codeblock>
<b>TABLE <i>function-name</i>( [ [ function-arg ] [, function-arg ]* ] )
-</b></codeblock></example>
-
-<section>
+</b></codeblock>
<p>
Note that when you invoke a table function, you must bind it to a
correlation name. For example:
</p>
-</section>
-
-<example>
-<codeblock>
-<b>
-SELECT s.*
+<codeblock><b>SELECT s.*
FROM TABLE( externalEmployees( 42 ) ) s
</b></codeblock></example>
Modified: db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita Fri Oct 29 17:11:19 2010
@@ -25,19 +25,19 @@ limitations under the License.
checks the specified table, ensuring that all of its indexes are consistent
with the base table. If the table and indexes are consistent, the method returns a SMALLINT
with value 1. If the table and indexes are inconsistent, the function will throw an exception.</p></section>
-<section><title>Syntax</title> <codeblock>SMALLINT SYSCS_UTIL.SYSCS_CHECK_TABLE(IN SCHEMANAME VARCHAR(128),
+<refsyn><title>Syntax</title> <codeblock>SMALLINT SYSCS_UTIL.SYSCS_CHECK_TABLE(IN SCHEMANAME VARCHAR(128),
IN TABLENAME VARCHAR(128)) </codeblock> <p>An error will occur if either SCHEMANAME
-or TABLENAME are null.</p></section>
-<section><title>Examples</title>
-Check a single table:
+or TABLENAME are null.</p></refsyn>
+<example><title>Examples</title>
+<p>Check a single table:</p>
<codeblock>VALUES SYSCS_UTIL.SYSCS_CHECK_TABLE('SALES', 'ORDERS');</codeblock>
-Check all tables:
-<codeblock>SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
-tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
-t.schemaid;
-</codeblock>
+<p>Check all tables:</p>
+<codeblock>SELECT schemaname, tablename,
+ SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname, tablename)
+ FROM sys.sysschemas s, sys.systables t
+ WHERE s.schemaid = t.schemaid;</codeblock>
-</section>
+</example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rreftimefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreftimefunc.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rreftimefunc.dita (original)
+++ db/derby/docs/trunk/src/ref/rreftimefunc.dita Fri Oct 29 17:11:19 2010
@@ -36,7 +36,8 @@ other rules depend on the data type of t
string.</li>
</ul></p></section>
<refsyn><title>Syntax</title> <codeblock><b>TIME ( <i>expression</i> )</b></codeblock> </refsyn>
-<example> <codeblock><b>values time(current_timestamp)</b></codeblock> <p>If
+<example><title>Example</title>
+<codeblock><b>values time(current_timestamp)</b></codeblock> <p>If
the current time is 5:03 PM, the value returned is <codeph>17:03:00</codeph>.</p> </example>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/tools/rtoolsijpropref10135.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijpropref10135.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijpropref10135.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijpropref10135.dita Fri Oct 29 17:11:19 2010
@@ -35,8 +35,10 @@ current connection, if there is more tha
specified on the command line the <i>databaseConnectionURL</i> should not
be enclosed in single quotations, however, if the database path contains special
characters (e.g. a space) it must be enclosed in double quotes.</p> </refsyn>
-<example><title>Example</title>This example connects to the existing database <i>sample</i> and
-creates then connects to the database <i>anohterDB</i>.<codeblock>D:> <b>java -Dij.connection.sample1=jdbc:derby:sample
+<example><title>Example</title>
+<p>This example connects to the existing database <i>sample</i> and
+creates, then connects to, the database <i>anotherDB</i>.</p>
+<codeblock>D:> <b>java -Dij.connection.sample1=jdbc:derby:sample
-Dij.connection.anotherConn=jdbc:derby:anotherDB;create=true
org.apache.derby.tools.ij</b>
ij version <ph conref="../conrefs.dita#vers/shortversionnumber"></ph>
Modified: db/derby/docs/trunk/src/tools/ttoolsij30600.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/ttoolsij30600.dita?rev=1028853&r1=1028852&r2=1028853&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/ttoolsij30600.dita (original)
+++ db/derby/docs/trunk/src/tools/ttoolsij30600.dita Fri Oct 29 17:11:19 2010
@@ -25,9 +25,10 @@ limitations under the License.
<li>by specifying a properties file using the <codeph>-p propertyfile</codeph> option
on the command line</li>
</ol><p><note type="remember">ij property names are case-sensitive, while
-commands are case-insensitive.</note></p><p>The following examples illustrate
-how to use ij properties:</p> </context>
-<example><p>To start ij by using a properties file called <codeph>ij.properties</codeph>,
+commands are case-insensitive.</note></p></context>
+<example><title>Examples</title>
+<p>The following examples illustrate how to use ij properties.</p>
+<p>To start ij by using a properties file called <codeph>ij.properties</codeph>,
use a command like the following (with the addition of the file paths):
<codeblock><b><userinput>java -jar derbyrun.jar -p ij.properties</userinput></b></codeblock></p><p>To
start ij with a maximumDisplayWidth of 1000: