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 fu...@apache.org on 2006/11/02 07:13:21 UTC
svn commit: r470242 - in /db/derby/docs/branches/10.2/src/tools:
rtoolsijcomrefshow.dita rtoolssysinfo1002629.dita
Author: fuzzylogic
Date: Wed Nov 1 22:13:20 2006
New Revision: 470242
URL: http://svn.apache.org/viewvc?view=rev&rev=470242
Log:
DERBY-1969: Fix typos in doc for ij show command. Merge of revision 470241 from
trunk.
Modified:
db/derby/docs/branches/10.2/src/tools/rtoolsijcomrefshow.dita
db/derby/docs/branches/10.2/src/tools/rtoolssysinfo1002629.dita
Modified: db/derby/docs/branches/10.2/src/tools/rtoolsijcomrefshow.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.2/src/tools/rtoolsijcomrefshow.dita?view=diff&rev=470242&r1=470241&r2=470242
==============================================================================
--- db/derby/docs/branches/10.2/src/tools/rtoolsijcomrefshow.dita (original)
+++ db/derby/docs/branches/10.2/src/tools/rtoolsijcomrefshow.dita Wed Nov 1 22:13:20 2006
@@ -1,4 +1,7 @@
<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
@@ -15,20 +18,19 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtoolsijcomrefshow">
+<reference id="rtoolsijcomrefshow" xml:lang="en-us">
<title>Show</title>
<prolog><metadata>
-<keywords><indexterm>Show</indexterm><indexterm>Show Tables</indexterm>
-<indexterm>Show Connections</indexterm><indexterm>Multiple connections<indexterm>displaying</indexterm></indexterm>
-<indexterm>Show Schemas</indexterm><indexterm>Show Views</indexterm>
-<indexterm>Show Procedures</indexterm><indexterm>Show Synonyms</indexterm>
-<indexterm>Show Indexes in Schema</indexterm><indexterm>Show Indexes from Table</indexterm>
-</keywords></metadata></prolog>
+<keywords><indexterm>ij commands<indexterm>SHOW</indexterm>Show</indexterm>
+<indexterm>Show Tables</indexterm><indexterm>Show Connections</indexterm>
+<indexterm>Multiple connections<indexterm>displaying</indexterm></indexterm>
+<indexterm>Show Schemas</indexterm><indexterm>Show Views</indexterm><indexterm>Show
+Procedures</indexterm><indexterm>Show Synonyms</indexterm><indexterm>Show
+Indexes in Schema</indexterm><indexterm>Show Indexes from Table</indexterm>
+</keywords>
+</metadata></prolog>
<refbody>
-<refsyn>
-<title>Syntax</title>
-<codeblock><b>SHOW
+<refsyn> <title>Syntax</title> <codeblock><b>SHOW
{
CONNECTIONS |
INDEXES [ IN <i>schemaName</i> | FROM <i>table-Name</i> ] |
@@ -38,29 +40,23 @@
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> <b>connect 'sample' as sample1;</b>
+}</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> <b>connect 'sample' as sample1;</b
+>
ij> <b>connect 'newDB;create=true' as newDB;</b>
ij(NEWDB)> <b>show connections;</b>
SAMPLE1 - jdbc:derby:sample
NEWDB* - jdbc:derby:newDB;create=true
* = current connection
-ij(NEWDB)></codeblock>
-<p id="showindexes"><b>SHOW INDEXES</b></p>
-<p>SHOW INDEXES will display 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> <b>show indexes in app</b>;
+ij(NEWDB)></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> <b>show indexes in app</b>;
TABLE_NAME |COLUMN_NAME |NON_U&|TYPE|ASC&|CARDINA&|PAGES
----------------------------------------------------------------------------
AIRLINES |AIRLINE |false |3 |A |NULL |NULL
@@ -89,14 +85,11 @@
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 will display 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> <b>show procedures in syscs_util;</b>
+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> <b>show procedures in syscs_util;</b
+>
PROCEDURE_SCHEM |PROCEDURE_NAME |REMARKS
------------------------------------------------------------------------
SYSCS_UTIL |SYSCS_BACKUP_DATABASE |org.apache.derby.ca&
@@ -118,12 +111,8 @@
SYSCS_UTIL |SYSCS_SET_STATISTICS_TIMING |org.apache.derby.ca&
SYSCS_UTIL |SYSCS_UNFREEZE_DATABASE |org.apache.derby.ca&
-18 rows selected</codeblock>
-
-<p id="showschemas"><b>SHOW SCHEMAS</b></p>
-<p>SHOW SCHEMAS will display all of the schemas in the current connection.</p>
-<p><b>Example</b></p>
-<codeblock>ij> <b>show schemas;</b>
+18 rows selected</codeblock> <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> <b>show schemas;</b>
TABLE_SCHEM
------------------------------
APP
@@ -138,23 +127,15 @@
SYSPROC
SYSSTAT
-11 rows selected</codeblock>
-
-<p id="showsynonyms"><b>SHOW SYNONYMS</b></p>
-<p>SHOW SYNONYMS will display 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> <b>show synonyms;</b>
+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> <b>show synonyms;</b>
TABLE_SCHEM |TABLE_NAME |REMARKS
------------------------------------------------------------------------
-APP |MYAIRLINES |</codeblock>
-
-<p id="showtables"><b>SHOW TABLES</b></p>
-<p>SHOW TABLES will diplay 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> <b>show tables;</b>
+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> <b>show tables;</b>
TABLE_SCHEM |TABLE_NAME |REMARKS
------------------------------------------------------------------------
APP |AIRLINES |
@@ -165,16 +146,13 @@
APP |FLIGHTS_HISTORY |
APP |MAPS |
-7 rows selected</codeblock>
-<p id="showviews"><b>SHOW VIEWS</b></p>
-<p>SHOW VIEWS will display all of the views 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> <b>show views;</b>
+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> <b>show views;</b>
TABLE_SCHEM |TABLE_NAME |REMARKS
------------------------------------------------------------------------
APP |TOTALSEATS |
-1 row selected</codeblock>
-</section>
-</refbody></reference>
+1 row selected</codeblock> </section>
+</refbody>
+</reference>
Modified: db/derby/docs/branches/10.2/src/tools/rtoolssysinfo1002629.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.2/src/tools/rtoolssysinfo1002629.dita?view=diff&rev=470242&r1=470241&r2=470242
==============================================================================
--- db/derby/docs/branches/10.2/src/tools/rtoolssysinfo1002629.dita (original)
+++ db/derby/docs/branches/10.2/src/tools/rtoolssysinfo1002629.dita Wed Nov 1 22:13:20 2006
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="utf-8"?>
-<!--Arbortext, Inc., 1988-2005, v.4002-->
+
<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--