db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1607450 [2/2] - /db/derby/docs/trunk/src/tools/
Date Wed, 02 Jul 2014 19:12:16 GMT
Modified: db/derby/docs/trunk/src/tools/rtoolsijcomref40155.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomref40155.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomref40155.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomref40155.dita Wed Jul  2 19:12:15 2014
@@ -18,36 +18,40 @@ limitations under the License.
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
 <reference xml:lang="en-us" id="rtoolsijcomref40155">
 <title>Syntax for identifiers in ij commands</title>
+<shortdesc>Some <codeph>ij</codeph> commands require identifier
+arguments.</shortdesc>
 <prolog>
 </prolog><refbody>
+<section>
+<p>These identifiers exist within the scope of <codeph>ij</codeph> only and are
+distinct from any identifiers used in SQL commands, except in the case of the
+<codeph><xref href="rtoolsijcomref36618.dita">Get Cursor</xref></codeph>
+command. The <codeph>Get Cursor</codeph> command specifies a cursor name to use
+in creating a result set.</p>
+<p><codeph>ij</codeph> does not recognize or permit delimited identifiers in
+<codeph>ij</codeph> commands. They can be used in SQL commands.</p>
+</section>
 <refsyn><title>Syntax</title>
 <codeblock><b><i>Identifier</i> [ @ <i>connectionName</i> ]</b></codeblock>
-</refsyn>
-<section><title>Description</title>
-<p>Some <codeph>ij</codeph> commands require identifiers. These <codeph>ij</codeph> identifiers
-are case-insensitive. They must begin with a letter in the range A-Z, and
-can consist of any number of letters in the range A-Z, digits in the range
-0-9, and underscore (_) characters. </p>
+<p>These <codeph>ij</codeph> identifiers are case-insensitive. They must begin
+with a letter in the range A-Z, and they can consist of any number of letters in
+the range A-Z, digits in the range 0-9, and underscore (<codeph>_</codeph>)
+characters.</p>
 <p>An identifier can optionally use an at sign (<codeph>@</codeph>) followed
 by a <i>connectionName</i>. Spaces on either side of the <codeph>@</codeph> sign
 are optional. If you specify a <i>connectionName</i>, you can refer to databases
 on different connections. This capability enables you to perform tasks such as
 copying data from one database to another. For an example of copying data
-between databases, see 
-<xref href="rtoolsijcomref30679.dita#rtoolsijcomref30679"></xref>. For other
-examples, see <xref href="rtoolsijcomref37862.dita#rtoolsijcomref37862"></xref>,
-<xref href="rtoolsijcomref36618.dita#rtoolsijcomref36618"></xref>, and
-<xref href="rtoolsijcomref62772.dita#rtoolsijcomref62772"></xref>.</p>
-<p>These identifiers exist within the scope of <codeph>ij</codeph> only and are
-distinct from any identifiers used in SQL commands, except in the case of
-the <xref href="rtoolsijcomref36618.dita#rtoolsijcomref36618">Get Cursor</xref> command. The <xref href="rtoolsijcomref36618.dita#rtoolsijcomref36618">Get Cursor</xref> command specifies a cursor name to use in creating a result set. </p>
-<p><codeph>ij</codeph> does not recognize or permit delimited identifiers in <codeph>ij</codeph> commands. They can be used in SQL commands.</p>
-</section>
-<example><title>Example</title>
-<codeblock><b>These are valid ij identifiers:
-foo1
+between databases, see <xref href="rtoolsijcomref30679.dita"/>. For other
+examples, see <xref href="rtoolsijcomref37862.dita"/>,
+<xref href="rtoolsijcomref36618.dita"/>, and
+<xref href="rtoolsijcomref62772.dita"/>.</p>
+</refsyn>
+<example><title>Examples</title>
+<p>These are valid <codeph>ij</codeph> identifiers:</p>
+<codeblock>foo1
 exampleIdentifier12345
 another_one
 myId@connection0
-id2 @ connection1</b></codeblock>
+id2 @ connection1</codeblock>
 </example></refbody></reference>

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomref44032.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomref44032.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomref44032.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomref44032.dita Wed Jul  2 19:12:15 2014
@@ -18,19 +18,22 @@ limitations under the License.
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
 <reference xml:lang="en-us" id="rtoolsijcomref44032">
 <title>Previous command</title>
+<shortdesc>The <codeph>Previous</codeph> command moves the cursor to the row
+previous to the current one, then fetches the row.</shortdesc>
 <prolog><metadata>
-<keywords><indexterm>Previous command</indexterm><indexterm>Cursors<indexterm>fetching next row</indexterm></indexterm>
+<keywords><indexterm>Previous command</indexterm>
+<indexterm>Cursors<indexterm>fetching next row</indexterm></indexterm>
 </keywords>
 </metadata>
 </prolog><refbody>
+<section>
+<p>The command displays a banner and the values of the row. The cursor must have
+been created with the <xref href="rtoolsijcomref62772.dita">Get Scroll
+Insensitive Cursor</xref> command.</p>
+</section>
 <refsyn><title>Syntax</title>
-<codeblock><b>PREVIOUS <b><i><xref href="rtoolsijcomref40155.dita#rtoolsijcomref40155">Identifier</xref></i></b></b></codeblock>
+<codeblock><b>PREVIOUS <i><xref href="rtoolsijcomref40155.dita">Identifier</xref></i></b></codeblock>
 </refsyn>
-<section><title>Description</title>
-<p>Moves the cursor to the row previous to the current one, then fetches the
-row. The cursor must have been created with the <xref href="rtoolsijcomref62772.dita#rtoolsijcomref62772">Get Scroll Insensitive Cursor</xref> command. It displays a banner and the values of the row.  
-</p>
-</section>
 <example><title>Example</title>
 <codeblock>ij&gt; <b>get scroll insensitive cursor scrollCursor as 
 'SELECT * FROM menu FOR UPDATE OF price';</b>

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomref53869.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomref53869.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomref53869.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomref53869.dita Wed Jul  2 19:12:15 2014
@@ -18,19 +18,22 @@ limitations under the License.
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
 <reference xml:lang="en-us" id="rtoolsijcomref53869">
 <title>Last command</title>
+<shortdesc>The <codeph>Last</codeph> command moves the cursor to the last row in
+the <i>ResultSet</i>, then fetches the row.</shortdesc>
 <prolog><metadata>
-<keywords><indexterm>Last command</indexterm><indexterm>Cursors<indexterm>fetching next row</indexterm></indexterm>
+<keywords><indexterm>Last command</indexterm>
+<indexterm>Cursors<indexterm>fetching next row</indexterm></indexterm>
 </keywords>
 </metadata>
 </prolog><refbody>
+<section>
+<p>The command displays a banner and the values of the row. The cursor must have
+been created with the <codeph><xref href="rtoolsijcomref62772.dita">Get Scroll
+Insensitive Cursor</xref></codeph> command.</p>
+</section>
 <refsyn><title>Syntax</title>
-<codeblock><b>LAST <b><i><xref href="rtoolsijcomref40155.dita#rtoolsijcomref40155">Identifier</xref></i></b></b></codeblock>
+<codeblock><b>LAST <i><xref href="rtoolsijcomref40155.dita">Identifier</xref></i></b></codeblock>
 </refsyn>
-<section><title>Description</title>
-<p>Moves the cursor to the last row in the <i>ResultSet</i>,
-then fetches the row. The cursor must have been created with the <xref href="rtoolsijcomref62772.dita#rtoolsijcomref62772">Get Scroll Insensitive Cursor</xref> command. It displays a banner and the values of the row.  
-</p>
-</section>
 <example><title>Example</title>
 <codeblock>ij&gt; <b>get scroll insensitive cursor scrollCursor as 
 'SELECT * FROM menu FOR UPDATE OF price';</b>

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomref61092.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomref61092.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomref61092.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomref61092.dita Wed Jul  2 19:12:15 2014
@@ -18,20 +18,21 @@ limitations under the License.
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
 <reference xml:lang="en-us" id="rtoolsijcomref61092">
 <title>Readonly command</title>
+<shortdesc>The <codeph>Readonly</codeph> command sets the current connection to
+a "read-only" connection, as if the current user were defined as a
+<codeph>readOnlyAccess</codeph> user.</shortdesc>
 <prolog><metadata>
 <keywords><indexterm>Readonly command</indexterm>
 </keywords>
 </metadata>
 </prolog><refbody>
+<section>
+<p>For more information about database authorization, see "Configuring user
+authorization" in the <ph conref="../conrefs.dita#pub/citsec"></ph>.</p>
+</section>
 <refsyn><title>Syntax</title>
 <codeblock><b>READONLY { ON | OFF }</b></codeblock>
 </refsyn>
-<section><title>Description</title>
-<p>Sets the current connection to a "read-only" connection, as if
-the current user were defined as a <i>readOnlyAccess</i> user.
-(For more information about database authorization, see "Configuring user
-authorization" in the <ph conref="../conrefs.dita#pub/citsec"></ph>.)</p>
-</section>
 <example><title>Example</title>
 <codeblock>ij&gt; <b>connect 'jdbc:derby:menuDB';</b>
 ij&gt; <b>readonly on;</b>

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomref61708.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomref61708.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomref61708.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomref61708.dita Wed Jul  2 19:12:15 2014
@@ -18,19 +18,22 @@ limitations under the License.
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
 <reference xml:lang="en-us" id="rtoolsijcomref61708">
 <title>First command</title>
+<shortdesc>The <codeph>First</codeph> command moves the cursor to the first row
+in the <i>ResultSet</i>, then fetches the row.</shortdesc>
 <prolog><metadata>
-<keywords><indexterm>First command</indexterm><indexterm>Cursors<indexterm>fetching next row</indexterm></indexterm>
+<keywords><indexterm>First command</indexterm>
+<indexterm>Cursors<indexterm>fetching next row</indexterm></indexterm>
 </keywords>
 </metadata>
 </prolog><refbody>
+<section>
+<p>The command displays a banner and the values of the row. The cursor must have
+been created with the <codeph><xref href="rtoolsijcomref62772.dita">Get Scroll
+Insensitive Cursor</xref></codeph> command.</p>
+</section>
 <refsyn><title>Syntax</title>
-<codeblock><b>FIRST <b><i><xref href="rtoolsijcomref40155.dita#rtoolsijcomref40155">Identifier</xref></i></b></b></codeblock>
+<codeblock><b>FIRST <i><xref href="rtoolsijcomref40155.dita">Identifier</xref></i></b></codeblock>
 </refsyn>
-<section><title>Description</title>
-<p>Moves the cursor to the first row in the <i>ResultSet</i>,
-then fetches the row. The cursor must have been created with the <xref href="rtoolsijcomref62772.dita#rtoolsijcomref62772">Get Scroll Insensitive Cursor</xref> command. It displays a banner and the values of the row.  
-</p>
-</section>
 <example><title>Example</title>
 <codeblock>ij&gt; <b>get scroll insensitive cursor scrollCursor as
 'SELECT * FROM menu FOR UPDATE OF price';</b>

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomref62772.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomref62772.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomref62772.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomref62772.dita Wed Jul  2 19:12:15 2014
@@ -18,44 +18,50 @@ limitations under the License.
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
 <reference xml:lang="en-us" id="rtoolsijcomref62772">
 <title>Get Scroll Insensitive Cursor command</title>
+<shortdesc>The <codeph>Get Scroll Insensitive Cursor</codeph> command creates a
+scrollable insensitive cursor with the name of the specified
+<i>Identifier</i>.</shortdesc>
 <prolog><metadata>
-<keywords><indexterm>Get Scroll Insensitive Cursor command</indexterm><indexterm>Cursors<indexterm>working with</indexterm></indexterm>
+<keywords><indexterm>Get Scroll Insensitive Cursor command</indexterm>
+<indexterm>Cursors<indexterm>working with</indexterm></indexterm>
 </keywords>
 </metadata>
 </prolog><refbody>
-<refsyn><title>Syntax</title>
-<codeblock><b>GET SCROLL INSENSITIVE [WITH {HOLD|NOHOLD}]
-   CURSOR <b><i><xref href="rtoolsijcomref40155.dita#rtoolsijcomref40155">Identifier</xref></i></b> AS
-   <b><i><xref href="rtoolsijcomref34110.dita#rtoolsijcomref34110">String</xref></i></b></b></codeblock>
-<p>WITH HOLD is the default attribute of the cursor. For a non-holdable cursor,
-use the WITH NOHOLD option.</p>
-</refsyn>
-<section><title>Description</title>
-<p>Creates a scrollable insensitive cursor with the name of the <i>Identifier</i>. It does this by issuing a <i>createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
-ResultSet.CONCUR_READ_ONLY</i>) call and then executing the statement with a <i>java.sql.StatementExecuteQuery</i> request on the value of
-the String.
-</p>
-<p>If the <i>String</i> is a statement that does not generate
-a result set, the behavior of the underlying database determines whether an
-empty result set or an error is issued. If there is an error in executing
-the statement, no cursor is created.</p>
-<p><codeph>ij</codeph> sets the cursor name using a <i>java.sql.Statement.setCursorName </i>request. Behavior with respect to duplicate cursor names is controlled
-by the underlying database. <ph conref="../conrefs.dita#prod/productshortname"></ph> does not allow multiple open cursors
-with the same name.</p>
+<section>
+<p>It does this by issuing a call to
+<i>createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
+ResultSet.CONCUR_READ_ONLY</i>) and then executing the statement with a
+<i>java.sql.StatementExecuteQuery</i> request on the value of the
+specified <i>String</i>.</p>
+<p>If the <i>String</i> is a statement that does not generate a result set, the
+behavior of the underlying database determines whether an empty result set or an
+error is issued. If there is an error in executing the statement, no cursor is
+created.</p>
+<p><codeph>ij</codeph> sets the cursor name using a
+<i>java.sql.Statement.setCursorName</i> request. Behavior with respect to
+duplicate cursor names is controlled by the underlying database.
+<ph conref="../conrefs.dita#prod/productshortname"></ph> does not allow multiple
+open cursors with the same name.</p>
 <p>Once a scrollable cursor has been created, you can use the following commands
 to work with the result set:  
 <ul>
-<li><xref href="rtoolsijcomref94092.dita#rtoolsijcomref94092"/></li>
-<li><xref href="rtoolsijcomref11943.dita#rtoolsijcomref11943"/></li>
-<li><xref href="rtoolsijcomref79286.dita#rtoolsijcomref79286"/></li>
-<li><xref href="rtoolsijcomref24423.dita#rtoolsijcomref24423"/></li>
-<li><xref href="rtoolsijcomref61708.dita#rtoolsijcomref61708"/></li>
-<li><xref href="rtoolsijcomref53869.dita#rtoolsijcomref53869"/></li>
-<li><xref href="rtoolsijcomref11128.dita#rtoolsijcomref11128"/></li>
-<li><xref href="rtoolsijcomref44032.dita#rtoolsijcomref44032"/></li>
-<li><xref href="rtoolsijcomref97975.dita#rtoolsijcomref97975"/></li>
+<li><xref href="rtoolsijcomref94092.dita"/></li>
+<li><xref href="rtoolsijcomref11943.dita"/></li>
+<li><xref href="rtoolsijcomref79286.dita"/></li>
+<li><xref href="rtoolsijcomref24423.dita"/></li>
+<li><xref href="rtoolsijcomref61708.dita"/></li>
+<li><xref href="rtoolsijcomref53869.dita"/></li>
+<li><xref href="rtoolsijcomref11128.dita"/></li>
+<li><xref href="rtoolsijcomref44032.dita"/></li>
+<li><xref href="rtoolsijcomref97975.dita"/></li>
 </ul></p>
 </section>
+<refsyn><title>Syntax</title>
+<codeblock><b>GET SCROLL INSENSITIVE [ WITH { HOLD | NOHOLD } ]
+   CURSOR <i><xref href="rtoolsijcomref40155.dita">Identifier</xref></i> AS <i><xref href="rtoolsijcomref34110.dita">String</xref></i></b></codeblock>
+<p><codeph>WITH HOLD</codeph> is the default attribute of the cursor. For a
+non-holdable cursor, use the <codeph>WITH NOHOLD</codeph> option.</p>
+</refsyn>
 <example><title>Examples</title>
 <codeblock>ij&gt; <b>autocommit off;</b>
 ij&gt; <b>get scroll insensitive cursor scrollCursor as

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomref79286.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomref79286.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomref79286.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomref79286.dita Wed Jul  2 19:12:15 2014
@@ -18,20 +18,24 @@ limitations under the License.
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
 <reference xml:lang="en-us" id="rtoolsijcomref79286">
 <title>Before First command</title>
+<shortdesc>The <codeph>Before First</codeph> command moves the cursor to before
+the first row, then fetches the row.</shortdesc>
 <prolog><metadata>
-<keywords><indexterm>Before First command</indexterm><indexterm>Cursors<indexterm>fetching next row</indexterm></indexterm>
+<keywords><indexterm>Before First command</indexterm>
+<indexterm>Cursors<indexterm>fetching next row</indexterm></indexterm>
 </keywords>
 </metadata>
 </prolog><refbody>
+<section>
+<p>Since there is no current row, it returns the message <codeph>No current
+row</codeph>.</p>
+<p>The cursor must have been created with the
+<codeph><xref href="rtoolsijcomref62772.dita">Get Scroll Insensitive Cursor</xref></codeph>
+command.</p>
+</section>
 <refsyn><title>Syntax</title>
-<codeblock><b>BEFORE FIRST <b><i>int <xref href="rtoolsijcomref40155.dita#rtoolsijcomref40155">Identifier</xref></i></b></b></codeblock>
+<codeblock><b>BEFORE FIRST <i>int <xref href="rtoolsijcomref40155.dita">Identifier</xref></i></b></codeblock>
 </refsyn>
-<section><title>Description</title>
-<p>Moves the cursor to before the first row, then fetches the row. (Since
-there is no current row, it returns the message <codeph>No current row</codeph>.)</p>
-<p>The cursor must have been created with the <xref href="rtoolsijcomref62772.dita#rtoolsijcomref62772">Get Scroll Insensitive Cursor</xref> command.   
-</p>
-</section>
 <example><title>Example</title>
 <codeblock>ij&gt; <b>get scroll insensitive cursor scrollCursor as
 'SELECT * FROM menu FOR UPDATE OF price';</b>

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomref88554.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomref88554.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomref88554.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomref88554.dita Wed Jul  2 19:12:15 2014
@@ -19,28 +19,36 @@ limitations under the License.
 -->
 <reference id="rtoolsijcomref88554" xml:lang="en-us">
 <title>LocalizedDisplay command</title>
+<shortdesc>The <codeph>LocalizedDisplay</codeph> command specifies that
+<codeph>ij</codeph> should display locale-sensitive data (such as dates) in the
+native format for the <codeph>ij</codeph> locale.</shortdesc>
 <prolog><metadata>
-<keywords><indexterm>LocalizedDisplay command</indexterm><indexterm>Display<indexterm>localizing</indexterm></indexterm>
+<keywords><indexterm>LocalizedDisplay command</indexterm>
+<indexterm>Display<indexterm>localizing</indexterm></indexterm>
 </keywords>
 </metadata></prolog>
 <refbody>
-<refsyn><title>Syntax</title><codeblock><b>LOCALIZEDDISPLAY { on | off }</b></codeblock> </refsyn>
-<section><title>Description</title><p>Specifies to display locale-sensitive
-data (such as dates) in the native format for the <codeph>ij</codeph> locale.
-The <codeph>ij</codeph> locale is the same as the Java system locale.</p><note>NUMERIC
-and DECIMAL values are not localized when using the J2ME/CDC/Foundation Profile
-because of platform limitations.</note> </section>
-<example><title>Example</title><p>The following demonstrates <i>LocalizedDisplay</i> in
-an English locale:</p><codeblock><b>ij&gt; VALUES CURRENT_DATE;
+<section>
+<p>The <codeph>ij</codeph> locale is the same as the Java system locale.</p>
+</section>
+<refsyn><title>Syntax</title>
+<codeblock><b>LOCALIZEDDISPLAY { on | off }</b></codeblock>
+</refsyn>
+<example><title>Example</title>
+<p>The following demonstrates <codeph>LocalizedDisplay</codeph> in an English
+locale:</p>
+<codeblock><b>ij&gt; VALUES CURRENT_DATE;
 1
 ----------
-2000-05-01
+2014-07-01
+
 1 row selected
 ij&gt; localizeddisplay on;
 ij&gt; VALUES CURRENT_DATE;
 1
 ------------------
-May 1, 2000
+July 1, 2014
+
 1 row selected</b></codeblock> </example>
 </refbody>
 </reference>

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomref94092.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomref94092.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomref94092.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomref94092.dita Wed Jul  2 19:12:15 2014
@@ -18,19 +18,22 @@ limitations under the License.
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
 <reference xml:lang="en-us" id="rtoolsijcomref94092">
 <title>Absolute command</title>
+<shortdesc>The <codeph>Absolute</codeph> command moves the cursor to the row
+specified by the <i>int</i> argument, then fetches the row.</shortdesc>
 <prolog><metadata>
-<keywords><indexterm>Absolute command</indexterm><indexterm>Cursors<indexterm>fetching next row</indexterm></indexterm>
+<keywords><indexterm>Absolute command</indexterm>
+<indexterm>Cursors<indexterm>fetching next row</indexterm></indexterm>
 </keywords>
 </metadata>
 </prolog><refbody>
+<section>
+<p>The command displays a banner and the values of the row. The cursor must have
+been created with the <codeph><xref href="rtoolsijcomref62772.dita">Get Scroll
+Insensitive Cursor</xref></codeph> command.</p>
+</section>
 <refsyn><title>Syntax</title>
-<codeblock><b>ABSOLUTE <b><i>int <xref href="rtoolsijcomref40155.dita#rtoolsijcomref40155">Identifier</xref></i></b></b></codeblock>
+<codeblock><b>ABSOLUTE <i>int <xref href="rtoolsijcomref40155.dita">Identifier</xref></i></b></codeblock>
 </refsyn>
-<section><title>Description</title>
-<p>Moves the cursor to the row specified by the <i>int</i>,
-then fetches the row. The cursor must have been created with the <xref href="rtoolsijcomref62772.dita#rtoolsijcomref62772">Get Scroll Insensitive Cursor</xref> command. It displays a banner and the values of the row.  
-</p>
-</section>
 <example><title>Example</title>
 <codeblock>ij&gt; <b>autocommit off;</b>
 ij&gt; <b>get scroll insensitive cursor scrollCursor as

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomref97975.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomref97975.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomref97975.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomref97975.dita Wed Jul  2 19:12:15 2014
@@ -18,21 +18,23 @@ limitations under the License.
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
 <reference xml:lang="en-us" id="rtoolsijcomref97975">
 <title>Relative command</title>
+<shortdesc>The <codeph>Relative</codeph> command moves the cursor to the row
+that is the specified number of rows relative to the current row, then fetches
+the row.</shortdesc>
 <prolog><metadata>
-<keywords><indexterm>Relative command</indexterm><indexterm>Cursors<indexterm>fetching next row</indexterm></indexterm>
+<keywords><indexterm>Relative command</indexterm>
+<indexterm>Cursors<indexterm>fetching next row</indexterm></indexterm>
 </keywords>
 </metadata>
 </prolog><refbody>
+<section>
+<p>The command displays a banner and the values of the row. The cursor must have
+been created with the <codeph><xref href="rtoolsijcomref62772.dita">Get Scroll
+Insensitive Cursor</xref></codeph> command.</p>
+</section>
 <refsyn><title>Syntax</title>
-<codeblock><b>RELATIVE <b><i>int <xref href="rtoolsijcomref40155.dita#rtoolsijcomref40155">Identifier</xref></i></b></b></codeblock>
+<codeblock><b>RELATIVE <i>int <xref href="rtoolsijcomref40155.dita">Identifier</xref></i></b></codeblock>
 </refsyn>
-<section><title>Description</title>
-<p>Moves the cursor to the row that is <i>int</i> number
-of rows relative to the current row, then fetches the row. The cursor must
-have been created with the <xref href="rtoolsijcomref62772.dita#rtoolsijcomref62772">Get Scroll Insensitive Cursor</xref> command.
-It displays a banner and the values of the row.  
-</p>
-</section>
 <example><title>Example</title>
 <codeblock>ij&gt; -- autocommit needs to be off so that the positioned update
 ij&gt; -- can see the cursor it operates against. 

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomrefdescribe.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomrefdescribe.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomrefdescribe.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomrefdescribe.dita Wed Jul  2 19:12:15 2014
@@ -18,18 +18,30 @@ limitations under the License.
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
 <reference xml:lang="en-us" id="rtoolsijcomrefdescribe">
 <title>Describe command</title>
+<shortdesc>The <codeph>Describe</codeph> command provides a decription of the
+specified table or view.</shortdesc>
 <prolog><metadata>
 <keywords><indexterm>Describe command</indexterm></keywords>
 </metadata></prolog>
 <refbody>
+<section>
+<p>For a list of tables in the current schema, use the
+<codeph><xref href="rtoolsijcomrefshow.dita#rtoolsijcomrefshow/showtables">Show
+Tables</xref></codeph> command. For a list of views in the current schema, use
+the <codeph><xref href="rtoolsijcomrefshow.dita#rtoolsijcomrefshow/showviews">Show
+Views</xref></codeph> command. For a list of available schemas, use the
+<codeph><xref href="rtoolsijcomrefshow.dita#rtoolsijcomrefshow/showschemas">Show
+Schemas</xref></codeph> command.</p>
+<p>If the table or view is in a particular schema, qualify it with the schema
+name. If the table or view name is case-sensitive, enclose it in single quotes.
+You can display all the columns from all the tables and views in a single schema
+in a single display by using the wildcard character '<codeph>*</codeph>'. See
+the examples below.</p>
+</section>
 <refsyn>
 <title>Syntax</title>
 <codeblock><b>DESCRIBE { <i>table-Name</i> | <i>view-Name</i> }</b></codeblock> 
 </refsyn>
-<section><title>Description</title>
-<p>Provides a decription of the specified table or view. For a list of tables in the current schema, use the <xref href="rtoolsijcomrefshow.dita#rtoolsijcomrefshow/showtables">Show Tables</xref> command. For a list of views in the current schema, use the <xref href="rtoolsijcomrefshow.dita#rtoolsijcomrefshow/showviews">Show Views</xref> command. For a list of available schemas, use the <xref href="rtoolsijcomrefshow.dita#rtoolsijcomrefshow/showschemas">Show Schemas</xref> command.</p>
-<p>If the table or view is in a particular schema, qualify it with the schema name. If the table or view name is case-sensitive, enclose it in single quotes. You can display all the columns from all the tables and views in a single schema in a single display by using the wildcard character '*'. See the examples below.</p>
-</section>
 <example><title>Examples</title>
 <codeblock>ij&gt; <b>describe airlines;</b>
 COLUMN_NAME         |TYPE_NAME|DEC&amp;|NUM&amp;|COLUM&amp;|COLUMN_DEF|CHAR_OCTE&amp;|IS_NULL&amp;
@@ -43,17 +55,16 @@ FIRSTCLASS_LEVEL_FA&amp;|DOUBLE   |NULL|
 ECONOMY_SEATS       |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
 BUSINESS_SEATS      |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
 FIRSTCLASS_SEATS    |INTEGER  |0   |10  |10    |NULL      |NULL      |YES</codeblock>
-<codeblock>
-    -- describe a table in another schema:
-    <b>describe user2.flights;</b>
-    -- describe a table whose name is in mixed-case:
-    <b>describe 'EmployeeTable';</b>
-    -- describe a table in a different schema, with a case-sensitive name:
-    <b>describe 'MyUser.Orders';</b>
-    -- describe all the columns from all the tables and views in APP schema:
-    <b>describe 'APP.*';</b>
-    -- describe all the columns in the current schema:
-    <b>describe '*';</b>
+<codeblock>-- describe a table in another schema:
+ij&gt; <b>describe user2.flights;</b>
+-- describe a table whose name is in mixed-case:
+ij&gt; <b>describe 'EmployeeTable';</b>
+-- describe a table in a different schema, with a case-sensitive name:
+ij&gt; <b>describe 'MyUser.Orders';</b>
+-- describe all columns from all tables and views in the APP schema:
+ij&gt; <b>describe 'APP.*';</b>
+-- describe all columns in the current schema:
+ij&gt; <b>describe '*';</b>
 </codeblock>
 
 </example>

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomrefhold.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomrefhold.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomrefhold.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomrefhold.dita Wed Jul  2 19:12:15 2014
@@ -19,12 +19,18 @@ limitations under the License.
 -->
 <reference id="rtoolsijcomrefhold" xml:lang="en-us">
 <title>HoldForConnection command</title>
+<shortdesc>The <codeph>HoldForConnection</codeph> command sets the default
+holdability for a connection to the default
+<i>ResultSet.HOLD_CURSORS_OVER_COMMIT</i>.</shortdesc>
 <prolog><metadata>
 <keywords><indexterm>HoldForConnection command</indexterm><indexterm>holdability</indexterm></keywords>
 </metadata></prolog>
 <refbody>
-<refsyn><title>Syntax</title><codeblock><b>HOLDFORCONNECTION</b></codeblock> </refsyn>
-<section><title>Description</title><p>Sets the default holdability for a connection to the default <i>ResultSet.HOLD_CURSORS_OVER_COMMIT</i>.</p></section>
-<example><title>Example</title><codeblock><b>ij&gt; HOLDFORCONNECTION;</b></codeblock> </example>
+<refsyn><title>Syntax</title>
+<codeblock><b>HOLDFORCONNECTION</b></codeblock>
+</refsyn>
+<example><title>Example</title>
+<codeblock><b>ij&gt; HOLDFORCONNECTION;</b></codeblock>
+</example>
 </refbody>
 </reference>

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomrefnohold.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomrefnohold.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomrefnohold.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomrefnohold.dita Wed Jul  2 19:12:15 2014
@@ -19,12 +19,19 @@ limitations under the License.
 -->
 <reference id="rtoolsijcomrefnohold" xml:lang="en-us">
 <title>NoHoldForConnection command</title>
+<shortdesc>The <codeph>NoHoldForConnection</codeph> command changes the default
+holdability for a connection from <i>ResultSet.HOLD_CURSORS_OVER_COMMIT</i> to
+<i>ResultSet.CLOSE_CURSORS_AT_COMMIT</i>.</shortdesc>
 <prolog><metadata>
-<keywords><indexterm>NoHoldForConnection command</indexterm><indexterm>holdability</indexterm></keywords>
+<keywords><indexterm>NoHoldForConnection command</indexterm>
+<indexterm>holdability</indexterm></keywords>
 </metadata></prolog>
 <refbody>
-<refsyn><title>Syntax</title><codeblock><b>NOHOLDFORCONNECTION</b></codeblock> </refsyn>
-<section><title>Description</title><p>Changes the default holdability for a connection from <i>ResultSet.HOLD_CURSORS_OVER_COMMIT</i> to <i>ResultSet.CLOSE_CURSORS_AT_COMMIT</i>.</p></section>
-<example><title>Example</title><codeblock><b>ij&gt; NOHOLDFORCONNECTION;</b></codeblock> </example>
+<refsyn><title>Syntax</title>
+<codeblock><b>NOHOLDFORCONNECTION</b></codeblock>
+</refsyn>
+<example><title>Example</title>
+<codeblock><b>ij&gt; NOHOLDFORCONNECTION;</b></codeblock>
+</example>
 </refbody>
 </reference>

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita?rev=1607450&r1=1607449&r2=1607450&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita Wed Jul  2 19:12:15 2014
@@ -20,13 +20,19 @@ limitations under the License.
 -->
 <reference id="rtoolsijcomrefshow" xml:lang="en-us">
 <title>Show command</title>
+<shortdesc>The <codeph>Show</codeph> command displays information about active
+connections and database objects.</shortdesc>
 <prolog><metadata>
 <keywords><indexterm>Show command</indexterm>
-<indexterm>Show Tables command</indexterm><indexterm>Show Connections command</indexterm>
+<indexterm>Show Tables command</indexterm>
+<indexterm>Show Connections command</indexterm>
 <indexterm>Multiple connections<indexterm>displaying</indexterm></indexterm>
-<indexterm>Show Schemas command</indexterm><indexterm>Show Views command</indexterm><indexterm>Show
-Procedures command</indexterm><indexterm>Show Synonyms command</indexterm><indexterm>Show
-Indexes in Schema command</indexterm><indexterm>Show Indexes from Table command</indexterm>
+<indexterm>Show Schemas command</indexterm>
+<indexterm>Show Views command</indexterm>
+<indexterm>Show Procedures command</indexterm>
+<indexterm>Show Synonyms command</indexterm>
+<indexterm>Show Indexes in Schema command</indexterm>
+<indexterm>Show Indexes from Table command</indexterm>
 <indexterm>Roles<indexterm>displaying</indexterm></indexterm>
 <indexterm>SHOW ROLES command</indexterm>
 <indexterm>SHOW ENABLED_ROLES command</indexterm>
@@ -35,11 +41,12 @@ Indexes in Schema command</indexterm><in
 </keywords>
 </metadata></prolog>
 <refbody>
-<refsyn> <title>Syntax</title> <codeblock><b>SHOW
+<refsyn><title>Syntax</title>
+<codeblock><b>SHOW
 {
    CONNECTIONS |
    FUNCTIONS [ IN <i>schemaName</i> ] |
-   INDEXES [ IN <i>schemaName</i> | FROM <i>table-Name</i> ] |
+   INDEXES [ IN <i>schemaName</i> | FROM <i>tableName</i> ] |
    PROCEDURES [ IN <i>schemaName</i> ] |
    ROLES |
    ENABLED_ROLES |
@@ -49,32 +56,37 @@ Indexes in Schema command</indexterm><in
    TABLES [ IN <i>schemaName</i> ] |
    VIEWS [ IN <i>schemaName</i> ] |
 
-}</b></codeblock>  </refsyn>
-<section><title>Description</title> <p>The SHOW command can be used to display
-information about active connections and database objects.</p> <p id="rtoolsijcomref17529"><b>SHOW
-CONNECTIONS</b></p> <p>If there are no connections, the SHOW CONNECTIONS command
-returns "No connections available".</p> <p>Otherwise, the command displays
-a list of connection names and the URLs used to connect to them. The currently
-active connection, if there is one, is marked with an * after its name.</p> <p><b>Example</b></p> <codeblock>ij&gt; <b>connect 'sample' as sample1;</b
->
+}</b></codeblock>
+</refsyn>
+<section id="rtoolsijcomref17529"><title>SHOW CONNECTIONS</title>
+<p>If there are no connections, the <codeph>SHOW CONNECTIONS</codeph> command
+returns "No connections available".</p>
+<p>Otherwise, the command displays a list of connection names and the URLs used
+to connect to them. The currently active connection, if there is one, is marked
+with an asterisk (<codeph>*</codeph>) after its name.</p>
+</section>
+<example><title>SHOW CONNECTIONS Example</title>
+<codeblock>ij&gt; <b>connect 'sample' as sample1;</b>
 ij&gt; <b>connect 'newDB;create=true' as newDB;</b>
 ij(NEWDB)&gt; <b>show connections;</b>
 SAMPLE1 -        jdbc:derby:sample
 NEWDB* -        jdbc:derby:newDB;create=true
 * = current connection
-ij(NEWDB)&gt;</codeblock> 
-<p id="showfunctions"><b>SHOW FUNCTIONS</b></p> <p>SHOW FUNCTIONS displays all
-functions in the database. By default, both system functions and user-defined
-functions appear in the output.</p>
-<p>If <codeph><b>IN <i>schemaName</i></b></codeph> is specified, then only the
-functions in the specified schema are displayed.</p>
-<p><b>Example</b></p>
-<p>If you created the TO_DEGREES function described in "CREATE FUNCTION
-statement" in the <ph conref="../conrefs.dita#pub/citref"></ph>, the output of
-the CREATE FUNCTION and SHOW FUNCTIONS commands would look something like the
-following:</p>
+ij(NEWDB)&gt;</codeblock>
+</example>
+<section id="showfunctions"><title>SHOW FUNCTIONS</title>
+<p>The <codeph>SHOW FUNCTIONS</codeph> command displays all functions in the
+database. By default, both system functions and user-defined functions appear in
+the output.</p>
+<p>If <codeph>IN <i>schemaName</i></codeph> is specified, only the functions in
+the specified schema are displayed.</p>
+</section>
+<example><title>SHOW FUNCTIONS Example</title>
+<p>If you created the <codeph>TO_DEGREES</codeph> function described in "CREATE
+FUNCTION statement" in the <ph conref="../conrefs.dita#pub/citref"></ph>, the
+output of the CREATE FUNCTION statement and the <codeph>SHOW FUNCTIONS</codeph>
+command would look something like the following:</p>
 <codeblock>ij&gt; <b>connect 'jdbc:derby:firstdb';</b>
-
 ij&gt; <b>CREATE FUNCTION TO_DEGREES ( RADIANS DOUBLE )</b>
 &gt; <b>RETURNS DOUBLE</b>
 &gt; <b>PARAMETER STYLE JAVA</b>
@@ -88,10 +100,17 @@ APP           |TO_DEGREES               
 
 1 row selected
 </codeblock>
-<p id="showindexes"><b>SHOW INDEXES</b></p> <p>SHOW
-INDEXES displays all the indexes in the database.</p> <p>If <codeph><b>IN <i>schemaName</i></b></codeph> is
-specified, then only the indexes in the specified schema are displayed.</p> <p>If <codeph><b>FROM <i>table-Name</i></b></codeph> is
-specified, then only the indexes on the specified table are displayed.</p> <p><b>Example</b></p> <codeblock>ij&gt; <b>show indexes in app</b>;
+</example>
+<section id="showindexes"><title>SHOW INDEXES</title>
+<p>The <codeph>SHOW INDEXES</codeph> command displays all the indexes in the
+database.</p>
+<p>If <codeph>IN <i>schemaName</i></codeph> is specified, only the indexes in
+the specified schema are displayed.</p>
+<p>If <codeph>FROM <i>tableName</i></codeph> is specified, only the indexes on
+the specified table are displayed.</p>
+</section>
+<example><title>SHOW INDEXES Examples</title>
+<codeblock>ij&gt; <b>show indexes in app;</b>
 TABLE_NAME          |COLUMN_NAME         |NON_U&amp;|TYPE|ASC&amp;|CARDINA&amp;|PAGES
 ----------------------------------------------------------------------------
 AIRLINES            |AIRLINE             |false |3   |A   |NULL    |NULL
@@ -112,7 +131,7 @@ FLIGHTAVAILABILITY  |FLIGHT_ID          
 FLIGHTAVAILABILITY  |SEGMENT_NUMBER      |true  |3   |A   |NULL    |NULL
 
 16 rows selected
-ij&gt; <b>show indexes from flights</b>;
+ij&gt; <b>show indexes from flights;</b>
 TABLE_NAME          |COLUMN_NAME         |NON_U&amp;|TYPE|ASC&amp;|CARDINA&amp;|PAGES
 ----------------------------------------------------------------------------
 FLIGHTS             |FLIGHT_ID           |false |3   |A   |NULL    |NULL
@@ -120,11 +139,17 @@ FLIGHTS             |SEGMENT_NUMBER     
 FLIGHTS             |DEST_AIRPORT        |true  |3   |A   |NULL    |NULL
 FLIGHTS             |ORIG_AIRPORT        |true  |3   |A   |NULL    |NULL
 
-4 rows selected</codeblock>  <p id="showprocedures"><b>SHOW PROCEDURES</b></p> <p>SHOW
-PROCEDURES displays all the procedures in the database that have been created
-with the CREATE PROCEDURE statement, as well as system procedures.</p> <p>If <codeph><b>IN <i>schemaName</i></b></codeph> is
-specified, only procedures in the specified schema are displayed.</p> <p><b>Example</b></p> <codeblock>ij&gt; <b>show procedures in syscs_util;</b
->
+4 rows selected</codeblock>
+</example>
+<section id="showprocedures"><title>SHOW PROCEDURES</title>
+<p>The <codeph>SHOW PROCEDURES</codeph> command displays all the procedures in
+the database that have been created with the CREATE PROCEDURE statement, as well
+as system procedures.</p>
+<p>If <codeph>IN <i>schemaName</i></codeph> is specified, only procedures in the
+specified schema are displayed.</p>
+</section>
+<example><title>SHOW PROCEDURES Example</title>
+<codeblock>ij&gt; <b>show procedures in syscs_util;</b>
 PROCEDURE_SCHEM     |PROCEDURE_NAME                |REMARKS
 ------------------------------------------------------------------------
 SYSCS_UTIL          |SYSCS_BACKUP_DATABASE         |org.apache.derby.ca&amp;
@@ -147,18 +172,25 @@ SYSCS_UTIL          |SYSCS_SET_STATISTIC
 SYSCS_UTIL          |SYSCS_UNFREEZE_DATABASE       |org.apache.derby.ca&amp;
 
 18 rows selected</codeblock>  
-
-<p id="showroles"><b>SHOW ROLES, SHOW ENABLED_ROLES, SHOW SETTABLE_ROLES</b></p>
-<p>SHOW ROLES displays the names of all roles created, whether settable for the
-current session or not.</p>
-<p>SHOW ENABLED_ROLES displays the names of all the roles whose privileges are
-available for the current session. That is, it shows the current role and any
-role contained in the current role. (For a definition of role containment, see
-"Using SQL roles" in the <ph conref="../conrefs.dita#pub/citsec"></ph>.)</p>
-<p>SHOW SETTABLE_ROLES displays all the roles that the current session can set,
-that is, all roles that have been granted to the current user or to PUBLIC.</p>
+</example>
+<section id="showroles"><title>SHOW ROLES, SHOW ENABLED_ROLES, and
+SHOW SETTABLE_ROLES</title>
+<p>The <codeph>SHOW ROLES</codeph> command displays the names of all roles
+created, whether settable for the current session or not.</p>
+<p>The <codeph>SHOW ENABLED_ROLES</codeph> command displays the names of all the
+roles whose privileges are available for the current session. That is, it shows
+the current role and any role contained in the current role. (For a definition
+of role containment, see "Using SQL roles" in the
+<ph conref="../conrefs.dita#pub/citsec"></ph>.)</p>
+<p>The <codeph>SHOW SETTABLE_ROLES</codeph> command displays all the roles that
+the current session can set, that is, all roles that have been granted to the
+current user or to PUBLIC.</p>
 <p>The roles shown by these commands are sorted in ascending order.</p>
-<p><b>Example</b></p>
+</section>
+<example><title>SHOW ROLES, SHOW ENABLED_ROLES, and SHOW SETTABLE_ROLES
+Examples</title>
+<p>In the following examples, both CASUALUSER and POWERUSER contain ANYUSER, but
+ANYUSER is not settable directly.</p>
 <codeblock>ij&gt; <b>show roles;</b>
 ROLEID                        
 ------------------------------
@@ -181,10 +213,14 @@ CASUALUSER                             
 POWERUSER
 
 2 rows selected
-</codeblock><p>In the examples above, both CASUALUSER and POWERUSER contain
-ANYUSER, but ANYUSER is not settable directly.</p>
-<p id="showschemas"><b>SHOW SCHEMAS</b></p> <p>SHOW
-SCHEMAS displays all of the schemas in the current connection.</p> <p><b>Example</b></p> <codeblock>ij&gt; <b>show schemas;</b>
+</codeblock>
+</example>
+<section id="showschemas"><title>SHOW SCHEMAS</title>
+<p>The <codeph>SHOW SCHEMAS</codeph> command displays all of the schemas in the
+current connection.</p>
+</section>
+<example><title>SHOW SCHEMAS Example</title>
+<codeblock>ij&gt; <b>show schemas;</b>
 TABLE_SCHEM
 ------------------------------
 APP
@@ -199,15 +235,28 @@ SYSIBM
 SYSPROC
 SYSSTAT
 
-11 rows selected</codeblock>   <p id="showsynonyms"><b>SHOW SYNONYMS</b></p> <p>SHOW
-SYNONYMS displays all the synonyms in the database that have been created
-with the CREATE SYNONYMS statement.</p> <p>If <codeph><b>IN <i>schemaName</i></b></codeph> is
-specified, only synonyms in the specified schema are displayed.</p> <p><b>Example</b></p> <codeblock>ij&gt; <b>show synonyms;</b>
+11 rows selected</codeblock>
+</example>
+<section id="showsynonyms"><title>SHOW SYNONYMS</title>
+<p>The <codeph>SHOW SYNONYMS</codeph> command displays all the synonyms in the
+database that have been created with the CREATE SYNONYMS statement.</p>
+<p>If <codeph>IN <i>schemaName</i></codeph> is specified, only synonyms in the
+specified schema are displayed.</p>
+</section>
+<example><title>SHOW SYNONYMS Example</title>
+<codeblock>ij&gt; <b>show synonyms;</b>
 TABLE_SCHEM         |TABLE_NAME                    |REMARKS
 ------------------------------------------------------------------------
-APP                 |MYAIRLINES                    |</codeblock>  <p id="showtables"><b>SHOW
-TABLES</b></p> <p>SHOW TABLES displays all of the tables in the current schema.</p> <p>If <codeph><b>IN <i>schemaName</i></b></codeph> is
-specified, the tables in the given schema are displayed.</p> <p><b>Example</b></p> <codeblock>ij&gt; <b>show tables;</b>
+APP                 |MYAIRLINES                    |</codeblock>
+</example>
+<section id="showtables"><title>SHOW TABLES</title>
+<p>The <codeph>SHOW TABLES</codeph> command displays all of the tables in the
+current schema.</p>
+<p>If <codeph>IN <i>schemaName</i></codeph> is specified, the tables in the
+given schema are displayed.</p>
+</section>
+<example><title>SHOW TABLES Example</title>
+<codeblock>ij&gt; <b>show tables;</b>
 TABLE_SCHEM         |TABLE_NAME                    |REMARKS
 ------------------------------------------------------------------------
 APP                 |AIRLINES                      |
@@ -218,13 +267,21 @@ APP                 |FLIGHTS            
 APP                 |FLIGHTS_HISTORY               |
 APP                 |MAPS                          |
 
-7 rows selected</codeblock> <p id="showviews"><b>SHOW VIEWS</b></p> <p>SHOW
-VIEWS displays all of the views in the current schema.</p> <p>If <codeph><b>IN <i>schemaName</i></b></codeph> is
-specified, the views in the given schema are displayed.</p> <p><b>Example</b></p> <codeblock>ij&gt; <b>show views;</b>
+7 rows selected</codeblock>
+</example>
+<section id="showviews"><title>SHOW VIEWS</title>
+<p>The <codeph>SHOW VIEWS</codeph> command displays all of the views in the
+current schema.</p>
+<p>If <codeph>IN <i>schemaName</i></codeph> is specified, the views in the given
+schema are displayed.</p>
+</section>
+<example><title>SHOW VIEWS Example</title>
+<codeblock>ij&gt; <b>show views;</b>
 TABLE_SCHEM         |TABLE_NAME                    |REMARKS
 ------------------------------------------------------------------------
 APP                 |TOTALSEATS                    |
 
-1 row selected</codeblock> </section>
+1 row selected</codeblock>
+</example>
 </refbody>
 </reference>



Mime
View raw message