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 2014/05/19 17:25:44 UTC
svn commit: r1595931 - /db/derby/docs/trunk/src/ref/
Author: chaase3
Date: Mon May 19 15:25:43 2014
New Revision: 1595931
URL: http://svn.apache.org/r1595931
Log:
DERBY-6379 Manuals are inconsistent in their use of the <shortdesc> element
Modified 44 Reference Manual topics.
Patch: DERBY-6379-ref-stmts-2.diff
Modified:
db/derby/docs/trunk/src/ref/crefsqlj22771.dita
db/derby/docs/trunk/src/ref/crefsqljrenamestatements.dita
db/derby/docs/trunk/src/ref/rrefcallprocedure.dita
db/derby/docs/trunk/src/ref/rrefcreatefunctionstatement.dita
db/derby/docs/trunk/src/ref/rrefcreateprocedurestatement.dita
db/derby/docs/trunk/src/ref/rrefcreaterole.dita
db/derby/docs/trunk/src/ref/rrefdeclaretemptable.dita
db/derby/docs/trunk/src/ref/rrefdropfunctionstatement.dita
db/derby/docs/trunk/src/ref/rrefdropprocedurestatement.dita
db/derby/docs/trunk/src/ref/rrefdroprole.dita
db/derby/docs/trunk/src/ref/rrefsetrole.dita
db/derby/docs/trunk/src/ref/rrefsqlj15446.dita
db/derby/docs/trunk/src/ref/rrefsqlj20937.dita
db/derby/docs/trunk/src/ref/rrefsqlj24513.dita
db/derby/docs/trunk/src/ref/rrefsqlj26498.dita
db/derby/docs/trunk/src/ref/rrefsqlj31580.dita
db/derby/docs/trunk/src/ref/rrefsqlj31648.dita
db/derby/docs/trunk/src/ref/rrefsqlj32268.dita
db/derby/docs/trunk/src/ref/rrefsqlj34148.dita
db/derby/docs/trunk/src/ref/rrefsqlj35981.dita
db/derby/docs/trunk/src/ref/rrefsqlj40506.dita
db/derby/docs/trunk/src/ref/rrefsqlj40774.dita
db/derby/docs/trunk/src/ref/rrefsqlj41180.dita
db/derby/docs/trunk/src/ref/rrefsqlj41360.dita
db/derby/docs/trunk/src/ref/rrefsqlj42082.dita
db/derby/docs/trunk/src/ref/rrefsqlj43125.dita
db/derby/docs/trunk/src/ref/rrefsqlj59893.dita
db/derby/docs/trunk/src/ref/rrefsqlj61102.dita
db/derby/docs/trunk/src/ref/rrefsqlj81859.dita
db/derby/docs/trunk/src/ref/rrefsqlj95598.dita
db/derby/docs/trunk/src/ref/rrefsqljcreateaggregate.dita
db/derby/docs/trunk/src/ref/rrefsqljcreatesequence.dita
db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita
db/derby/docs/trunk/src/ref/rrefsqljcreatetype.dita
db/derby/docs/trunk/src/ref/rrefsqljdropaggregate.dita
db/derby/docs/trunk/src/ref/rrefsqljdropsequence.dita
db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita
db/derby/docs/trunk/src/ref/rrefsqljdroptype.dita
db/derby/docs/trunk/src/ref/rrefsqljgrant.dita
db/derby/docs/trunk/src/ref/rrefsqljmerge.dita
db/derby/docs/trunk/src/ref/rrefsqljrenamecolumnstatement.dita
db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita
db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita
db/derby/docs/trunk/src/ref/rrefsqljtruncatetable.dita
Modified: db/derby/docs/trunk/src/ref/crefsqlj22771.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/crefsqlj22771.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/crefsqlj22771.dita (original)
+++ db/derby/docs/trunk/src/ref/crefsqlj22771.dita Mon May 19 15:25:43 2014
@@ -20,12 +20,16 @@ limitations under the License.
"../dtd/concept.dtd">
<concept id="crefsqlj22771" xml:lang="en-us">
<title>Interaction with the dependency system</title>
-<conbody>
-<p><indexterm>Dependencies<indexterm>internal tracking of</indexterm></indexterm><indexterm>Prepared
-statements<indexterm>tracking of dependencies</indexterm></indexterm><ph conref="../conrefs.dita#prod/productshortname"></ph> internally
+<shortdesc><ph conref="../conrefs.dita#prod/productshortname"></ph> internally
tracks the dependencies of prepared statements, which are SQL statements that
are precompiled before being executed. Typically they are prepared (precompiled)
-once and executed multiple times.</p>
+once and executed multiple times.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>Dependencies<indexterm>internal tracking of</indexterm></indexterm>
+<indexterm>Prepared statements<indexterm>tracking of dependencies</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<conbody>
<p>Prepared statements depend on the dictionary objects and statements they
reference. (Dictionary objects include tables, columns, constraints, indexes,
views, and triggers.) Removing or modifying the dictionary objects or statements
Modified: db/derby/docs/trunk/src/ref/crefsqljrenamestatements.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/crefsqljrenamestatements.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/crefsqljrenamestatements.dita (original)
+++ db/derby/docs/trunk/src/ref/crefsqljrenamestatements.dita Mon May 19 15:25:43 2014
@@ -21,7 +21,7 @@ limitations under the License.
<concept id="crefsqljrenamestatements" xml:lang="en-us">
<title>RENAME statements</title>
<conbody>
-<p>Use the Rename statements with indexes, columns, and tables.</p>
+<p>Use the RENAME statements with indexes, columns, and tables.</p>
</conbody>
</concept>
Modified: db/derby/docs/trunk/src/ref/rrefcallprocedure.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcallprocedure.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcallprocedure.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcallprocedure.dita Mon May 19 15:25:43 2014
@@ -18,14 +18,15 @@ limitations under the License.
<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
<reference xml:lang="en-us" id="rrefcallprocedure">
<title>CALL (PROCEDURE) statement</title>
+<shortdesc>The CALL (PROCEDURE) statement invokes a procedure. A call to
+a procedure does not return any value.</shortdesc>
<prolog><metadata>
<keywords>
</keywords>
</metadata>
</prolog>
<refbody>
-<section><p>The CALL (PROCEDURE) statement is used to call procedures. A call to a
-procedure does not return any value.</p>
+<section>
<p>When a procedure with definer's rights is called, the current default schema
is set to the eponymously named schema of the definer. For example, if the
defining user is called OWNER, the default schema will also be set to OWNER.
Modified: db/derby/docs/trunk/src/ref/rrefcreatefunctionstatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcreatefunctionstatement.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcreatefunctionstatement.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcreatefunctionstatement.dita Mon May 19 15:25:43 2014
@@ -20,8 +20,8 @@ limitations under the License.
-->
<reference id="rrefcreatefunctionstatement" xml:lang="en-us">
<title>CREATE FUNCTION statement</title>
-<shortdesc>The CREATE FUNCTION statement allows you to create Java functions,
-which you can then use in an expression.</shortdesc>
+<shortdesc>The CREATE FUNCTION statement creates a Java function, which you can
+then use in an expression.</shortdesc>
<prolog><metadata>
<keywords><indexterm>CREATE FUNCTION statement</indexterm><indexterm><indexterm>SQL
statements</indexterm>CREATE FUNCTION</indexterm><indexterm>functions<indexterm>creating</indexterm></indexterm>
Modified: db/derby/docs/trunk/src/ref/rrefcreateprocedurestatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcreateprocedurestatement.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcreateprocedurestatement.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcreateprocedurestatement.dita Mon May 19 15:25:43 2014
@@ -20,15 +20,15 @@ limitations under the License.
-->
<reference id="rrefcreateprocedurestatement" xml:lang="en-us">
<title>CREATE PROCEDURE statement</title>
+<shortdesc>The CREATE PROCEDURE statement creates a Java stored procedure, which
+you can then call using the CALL PROCEDURE statement.</shortdesc>
<prolog><metadata>
<keywords><indexterm>CREATE PROCEDURE statement</indexterm><indexterm><indexterm>SQL
statements</indexterm>CREATE PROCEDURE</indexterm><indexterm>procedures<indexterm>creating</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section><p>The CREATE PROCEDURE statement allows you to create Java stored
-procedures, which you can then call using the CALL PROCEDURE statement.</p><p>The
-procedure owner and the
+<section><p>The procedure owner and the
<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref>
automatically gain the EXECUTE privilege
on the procedure, and are able to grant this privilege to other users. The
Modified: db/derby/docs/trunk/src/ref/rrefcreaterole.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcreaterole.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcreaterole.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcreaterole.dita Mon May 19 15:25:43 2014
@@ -20,6 +20,8 @@ limitations under the License.
-->
<reference id="rrefcreaterole" xml:lang="en-us">
<title>CREATE ROLE statement</title>
+<shortdesc>The CREATE ROLE statement creates an SQL role. Roles are useful for
+administering privileges when a database has many users.</shortdesc>
<prolog><metadata>
<keywords>
<indexterm>CREATE ROLE statement</indexterm>
@@ -29,7 +31,6 @@ limitations under the License.
</metadata></prolog>
<refbody>
<section>
-<p>The CREATE ROLE statement allows you to create an SQL role.</p>
<p>Only the
<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> can
create a role.</p>
Modified: db/derby/docs/trunk/src/ref/rrefdeclaretemptable.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefdeclaretemptable.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefdeclaretemptable.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefdeclaretemptable.dita Mon May 19 15:25:43 2014
@@ -20,6 +20,8 @@ limitations under the License.
-->
<reference id="rrefdeclaretemptable" xml:lang="en-us">
<title>DECLARE GLOBAL TEMPORARY TABLE statement</title>
+<shortdesc>The DECLARE GLOBAL TEMPORARY TABLE statement defines a temporary
+table for the current connection.</shortdesc>
<prolog><metadata>
<keywords><indexterm>DECLARE GLOBAL TEMPORARY TABLE statement</indexterm>
<indexterm>tables<indexterm>temporary</indexterm></indexterm><indexterm><indexterm>SQL
@@ -27,9 +29,7 @@ statements</indexterm>DECLARE GLOBAL TEM
</metadata></prolog>
<refbody>
<section>
-<p>The DECLARE GLOBAL TEMPORARY TABLE statement defines a temporary table for
-the current connection.</p>
-<p>These tables do not reside in the system catalogs and are not
+<p>Temporary tables do not reside in the system catalogs and are not
persistent. Temporary tables exist only during the connection that declared
them and cannot be referenced outside of that connection. When the connection
closes, the rows of the table are deleted, and the in-memory description of
Modified: db/derby/docs/trunk/src/ref/rrefdropfunctionstatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefdropfunctionstatement.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefdropfunctionstatement.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefdropfunctionstatement.dita Mon May 19 15:25:43 2014
@@ -20,10 +20,18 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefdropfunctionstatement" xml:lang="en-us">
<title>DROP FUNCTION statement</title>
+<shortdesc>The DROP FUNCTION statement removes the specified Java
+function.</shortdesc>
<refbody>
-<section><title>Syntax</title> <codeblock><b>DROP FUNCTION <i><xref
+<section>
+<p>A function is created by a
+<xref href="rrefcreatefunctionstatement.dita"/>.</p>
+</section>
+<refsyn><title>Syntax</title>
+<codeblock><b>DROP FUNCTION <i><xref
href="rreffunctionname.dita#rreffunctionname">functionName</xref></i></b></codeblock>
-<p>Identifies the particular function to be dropped, and is valid only if there
+<p>The argument identifies the particular function to be dropped and is valid
+only if there
is exactly one function instance with the <i>functionName</i> in the schema.
The identified function can have any number of parameters defined for it.</p>
<p>An error will occur in any of the following circumstances:</p>
@@ -39,7 +47,7 @@ of a generated column</li>
<li>If you try to drop a user-defined function that is invoked in a view or
trigger</li>
</ul>
-</section>
+</refsyn>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefdropprocedurestatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefdropprocedurestatement.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefdropprocedurestatement.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefdropprocedurestatement.dita Mon May 19 15:25:43 2014
@@ -19,8 +19,15 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefdropprocedurestatement" xml:lang="en-us">
<title>DROP PROCEDURE statement</title>
+<shortdesc>The DROP PROCEDURE statement removes the specified Java stored
+procedure.</shortdesc>
<refbody>
-<section><title>Syntax</title> <codeblock><b>DROP PROCEDURE <i><xref
+<section>
+<p>A stored procedure is created by a
+<xref href="rrefcreateprocedurestatement.dita"/> and is called by a
+<xref href="rrefcallprocedure.dita"/>.</p>
+</section>
+<refsyn><title>Syntax</title> <codeblock><b>DROP PROCEDURE <i><xref
href="rrefprocedurename.dita#rrefprocedurename.dita">procedureName</xref></i></b>
</codeblock>
<p>Identifies the particular procedure to be dropped, and is valid only if there
@@ -35,7 +42,7 @@ implied schema</li>
<li>If you try to drop a user-defined procedure that is invoked in a
trigger</li>
</ul>
-</section>
+</refsyn>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefdroprole.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefdroprole.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefdroprole.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefdroprole.dita Mon May 19 15:25:43 2014
@@ -19,6 +19,7 @@ limitations under the License.
<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
<reference id="rrefdroprole" xml:lang="en-us">
<title>DROP ROLE statement</title>
+<shortdesc>The DROP ROLE statement removes the specified SQL role.</shortdesc>
<prolog><metadata>
<keywords><indexterm>DROP ROLE statement</indexterm>
<indexterm>SQL statements<indexterm>DROP ROLE</indexterm></indexterm>
@@ -27,7 +28,7 @@ limitations under the License.
</prolog>
<refbody>
<section>
-<p>The DROP ROLE statement allows you to drop an SQL role.</p>
+<p>A role is created by a <xref href="rrefcreaterole.dita"/>.</p>
<p>Only the
<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> can drop
a role.</p>
Modified: db/derby/docs/trunk/src/ref/rrefsetrole.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsetrole.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsetrole.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsetrole.dita Mon May 19 15:25:43 2014
@@ -19,6 +19,8 @@ limitations under the License.
<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
<reference id="rrefsetrole" xml:lang="en-us">
<title>SET ROLE statement</title>
+<shortdesc>The SET ROLE statement sets the current role for the current SQL
+context of a session.</shortdesc>
<prolog><metadata>
<keywords><indexterm>SET ROLE statement</indexterm>
<indexterm>SQL statements<indexterm>SET ROLE</indexterm></indexterm>
@@ -27,8 +29,6 @@ limitations under the License.
</metadata></prolog>
<refbody>
<section>
-<p>The SET ROLE statement allows you to set the current role for the
-current SQL context of a session.</p>
<p>You can set a role only if the current user has been granted the role, or
if the role has been granted to PUBLIC.</p>
<p>For more information on roles, see "Using SQL roles" in the
Modified: db/derby/docs/trunk/src/ref/rrefsqlj15446.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj15446.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj15446.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj15446.dita Mon May 19 15:25:43 2014
@@ -19,13 +19,15 @@ limitations under the License.
-->
<reference id="rrefsqlj15446" xml:lang="en-us">
<title>CREATE VIEW statement</title>
+<shortdesc>The CREATE VIEW statement creates a view, which is a virtual table
+formed by a query.</shortdesc>
<prolog><metadata>
<keywords><indexterm>CREATE VIEW statement</indexterm><indexterm><indexterm>SQL
statements</indexterm>CREATE VIEW</indexterm><indexterm>views<indexterm>creating</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section> <p>Views are virtual tables formed by a query. A view is a dictionary
+<section> <p>A view is a dictionary
object that you can use until you drop it. Views are not updatable.</p><p>If
a qualified view name is specified, the schema name cannot begin with <i>SYS</i>.</p>
<p>A view operates with the privileges of the owner of the view. See "Using SQL
Modified: db/derby/docs/trunk/src/ref/rrefsqlj20937.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj20937.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj20937.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj20937.dita Mon May 19 15:25:43 2014
@@ -19,6 +19,8 @@ limitations under the License.
-->
<reference id="rrefsqlj20937" xml:lang="en-us">
<title>CREATE INDEX statement</title>
+<shortdesc>A CREATE INDEX statement creates an index on a table. Indexes can be
+on one or more columns in the table.</shortdesc>
<prolog><metadata>
<keywords><indexterm>CREATE INDEX statement</indexterm><indexterm>Descending
indexes</indexterm><indexterm>Indexes<indexterm>created in descending order</indexterm></indexterm>
@@ -29,8 +31,6 @@ creation of for primary key, unique, and
</keywords>
</metadata></prolog>
<refbody>
-<section id="i1013640"> <p id="sqlj31027">A CREATE INDEX statement creates
-an index on a table. Indexes can be on one or more columns in the table.</p></section>
<refsyn><title>Syntax</title><codeblock><b>CREATE [ UNIQUE ] INDEX <i><xref
href="rrefindexname.dita#rrefindexname">indexName</xref></i>
ON <i><xref href="rreftablename.dita#rreftablename">tableName</xref></i> ( <i><xref
Modified: db/derby/docs/trunk/src/ref/rrefsqlj24513.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj24513.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj24513.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj24513.dita Mon May 19 15:25:43 2014
@@ -20,14 +20,15 @@ limitations under the License.
-->
<reference id="rrefsqlj24513" xml:lang="en-us">
<title>CREATE TABLE statement</title>
+<shortdesc>The CREATE TABLE statement creates a table. Tables contain columns
+and constraints, rules to which data must conform.</shortdesc>
<prolog><metadata>
<keywords><indexterm>CREATE TABLE statement</indexterm><indexterm><indexterm>SQL
statements</indexterm>CREATE TABLE</indexterm><indexterm>tables<indexterm>creating</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section> <p>A CREATE TABLE statement creates a table. Tables contain columns
-and constraints, rules to which data must conform. Table-level constraints
+<section> <p>Table-level constraints
specify a column or columns. Columns have a data type and can specify column
constraints (column-level constraints).</p><p>The table owner and the
<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj26498.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj26498.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj26498.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj26498.dita Mon May 19 15:25:43 2014
@@ -20,6 +20,8 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqlj26498" xml:lang="en-us">
<title>UPDATE statement</title>
+<shortdesc>The UPDATE statement updates the value of one or more columns of a
+table.</shortdesc>
<prolog><metadata>
<keywords><indexterm>UPDATE statement</indexterm></keywords>
</metadata></prolog>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj31580.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj31580.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj31580.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj31580.dita Mon May 19 15:25:43 2014
@@ -20,14 +20,15 @@ limitations under the License.
-->
<reference id="rrefsqlj31580" xml:lang="en-us">
<title>CREATE SCHEMA statement</title>
+<shortdesc>The CREATE SCHEMA statement creates a schema, which is a way to
+logically group objects in a single collection and to provide a unique namespace
+for objects.</shortdesc>
<prolog><metadata>
<keywords><indexterm>CREATE SCHEMA statement</indexterm><indexterm><indexterm>SQL
statements</indexterm>CREATE SCHEMA</indexterm><indexterm>schemas<indexterm>creating</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section> <p>A schema is a way to logically group objects in a single collection
-and provide a unique namespace for objects. </p></section>
<refsyn><title>Syntax</title>
<codeblock><b>CREATE SCHEMA
{
@@ -35,9 +36,8 @@ and provide a unique namespace for objec
[ <i><xref href="rrefschemaname.dita#rrefschemaname">schemaName</xref></i> ] |
[ AUTHORIZATION <i>userName</i> ]
}</b></codeblock>
-<p>The CREATE SCHEMA statement is used to create a schema.
-schema name cannot exceed 128 characters. Schema names must be unique within
-the database.</p>
+<p>A schema name cannot exceed 128 characters. Schema names must be unique
+within the database.</p>
<p>A schema name cannot start with the prefix SYS (after case normalization).
Use of the prefix SYS raises a <i>SQLException</i>.</p>
<p>The CREATE SCHEMA statement is subject to access control when the
Modified: db/derby/docs/trunk/src/ref/rrefsqlj31648.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj31648.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj31648.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj31648.dita Mon May 19 15:25:43 2014
@@ -20,14 +20,18 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqlj31648" xml:lang="en-us">
<title>DROP SCHEMA statement</title>
+<shortdesc>The DROP SCHEMA statement removes the specified schema.</shortdesc>
<prolog><metadata>
<keywords><indexterm>DROP SCHEMA statement</indexterm><indexterm>Schemas<indexterm>dropping</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section> <p>The DROP SCHEMA statement drops a schema. The target schema must
-be empty for the drop to succeed.</p> <p>Neither the <i>APP</i> schema (the
-default user schema) nor the <i>SYS</i> schema can be dropped.</p></section>
+<section>
+<p>A schema is created by a <xref href="rrefsqlj31580.dita"/>.</p>
+<p>The target schema must be empty for the drop to succeed.</p>
+<p>Neither the <i>APP</i> schema (the default user schema) nor the
+<i>SYS</i> schema can be dropped.</p>
+</section>
<refsyn><title>Syntax</title> <codeblock><b>DROP SCHEMA <i><xref
href="rrefschemaname.dita#rrefschemaname">schemaName</xref></i> RESTRICT</b></codeblock>
<p>The RESTRICT keyword enforces the rule that no objects can be defined in
Modified: db/derby/docs/trunk/src/ref/rrefsqlj32268.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj32268.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj32268.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj32268.dita Mon May 19 15:25:43 2014
@@ -20,13 +20,14 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqlj32268" xml:lang="en-us">
<title>SET SCHEMA statement</title>
+<shortdesc>The SET SCHEMA statement sets the default schema for a connection's
+session to the designated schema.</shortdesc>
<prolog><metadata>
<keywords><indexterm>SET SCHEMA statement</indexterm><indexterm>Schemas<indexterm>changing
default for session</indexterm></indexterm></keywords>
</metadata></prolog>
<refbody>
-<section> <p>The SET SCHEMA statement sets the default schema for a connection's
-session to the designated schema. The default schema is used as the target
+<section> <p>The default schema is used as the target
schema for all statements issued from the connection that do not explicitly
specify a schema name. </p> <p>The target schema must exist for the SET SCHEMA
statement to succeed. If the schema doesn't exist an error is returned. See <xref
Modified: db/derby/docs/trunk/src/ref/rrefsqlj34148.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj34148.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj34148.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj34148.dita Mon May 19 15:25:43 2014
@@ -20,12 +20,14 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqlj34148" xml:lang="en-us">
<title>DROP TABLE statement</title>
+<shortdesc>The DROP TABLE statement removes the specified table.</shortdesc>
<prolog><metadata>
<keywords><indexterm>DROP TABLE statement</indexterm><indexterm>Tables<indexterm>dropping</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section> <p>DROP TABLE removes the specified table.</p></section>
+<section><p>A table is created by a <xref href="rrefsqlj24513.dita"/>.</p>
+</section>
<refsyn><title>Syntax</title> <codeblock><b>DROP TABLE <i><xref href="rreftablename.dita#rreftablename">tableName</xref></i></b></codeblock> </refsyn>
<section id="sqlj38361"><title>Statement dependency system</title> <p>Triggers,
constraints (primary, unique, check and references from the table being
Modified: db/derby/docs/trunk/src/ref/rrefsqlj35981.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj35981.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj35981.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj35981.dita Mon May 19 15:25:43 2014
@@ -20,6 +20,7 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqlj35981" xml:lang="en-us">
<title>DELETE statement</title>
+<shortdesc>The DELETE statement removes rows from a table.</shortdesc>
<prolog><metadata>
<keywords><indexterm>DELETE statement</indexterm><indexterm>Read-write VTIs<indexterm>and
DELETES</indexterm></indexterm></keywords>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj40506.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj40506.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj40506.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj40506.dita Mon May 19 15:25:43 2014
@@ -20,16 +20,17 @@ limitations under the License.
-->
<reference id="rrefsqlj40506" xml:lang="en-us">
<title>LOCK TABLE statement</title>
+<shortdesc>The LOCK TABLE statement explicitly acquires a shared or exclusive
+table lock on the specified table.</shortdesc>
<prolog><metadata>
<keywords><indexterm>LOCK TABLE statement</indexterm><indexterm><indexterm>SQL
statements</indexterm>LOCK TABLE</indexterm><indexterm>tables<indexterm>locking</indexterm></indexterm>
<indexterm>lock escalation<indexterm>by user</indexterm></indexterm></keywords>
</metadata></prolog>
<refbody>
-<section> <p>The LOCK TABLE statement allows you to explicitly acquire a shared
-or exclusive table lock on the specified table. The table lock lasts until
-the end of the current transaction. </p><p>To lock a table, you must either
-be the
+<section>
+<p>The table lock lasts until the end of the current transaction.</p>
+<p>To lock a table, you must be either the
<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref>
or the table owner.</p><p>Explicitly locking a table
is useful to: <ul>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj40774.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj40774.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj40774.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj40774.dita Mon May 19 15:25:43 2014
@@ -20,14 +20,16 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqlj40774" xml:lang="en-us">
<title>INSERT statement</title>
+<shortdesc>The INSERT statement creates one or more rows and stores them in the
+named table.</shortdesc>
<prolog><metadata>
-<keywords><indexterm>INSERT statement</indexterm></keywords>
+<keywords><indexterm>INSERT statement</indexterm>
+<indexterm>Read-write VTIs<indexterm>and INSERTs</indexterm></indexterm>
+</keywords>
</metadata></prolog>
<refbody>
-<section> <p><indexterm>Read-write VTIs<indexterm>and INSERTs</indexterm></indexterm>An
-INSERT statement creates a row or rows and stores them in the named table.
-The number of values assigned in an INSERT statement must be the same as the
-number of specified or implied columns.</p>
+<section><p>The number of values assigned in an INSERT statement must be the
+same as the number of specified or implied columns.</p>
<p>Whenever you insert into a table which has generated columns,
<ph conref="../conrefs.dita#prod/productshortname"></ph> calculates the values
of those columns.</p></section>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj41180.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj41180.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj41180.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj41180.dita Mon May 19 15:25:43 2014
@@ -20,13 +20,14 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqlj41180" xml:lang="en-us">
<title>SET ISOLATION statement</title>
+<shortdesc>The SET ISOLATION statement changes the isolation level for a user's
+connection.</shortdesc>
<prolog><metadata>
<keywords><indexterm>SET ISOLATION statement</indexterm><indexterm>ISOLATION</indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section> <p>The SET ISOLATION statement allows a user to change
-the isolation level for the user's connection. Valid levels are SERIALIZABLE,
+<section> <p>Valid isolation levels are SERIALIZABLE,
REPEATABLE READ, READ COMMITTED, and READ UNCOMMITTED.</p> <p>Issuing this
statement always commits the current transaction. The JDBC
<i>java.sql.Connection.setTransactionIsolation</i> method behaves almost
Modified: db/derby/docs/trunk/src/ref/rrefsqlj41360.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj41360.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj41360.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj41360.dita Mon May 19 15:25:43 2014
@@ -20,6 +20,8 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqlj41360" xml:lang="en-us">
<title>SELECT statement</title>
+<shortdesc>The SELECT statement performs a query on one or more
+tables.</shortdesc>
<prolog><metadata>
<keywords><indexterm>SELECT statement</indexterm><indexterm>ORDER BY clause<indexterm>needed
to guarantee order of results</indexterm></indexterm></keywords>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj42082.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj42082.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj42082.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj42082.dita Mon May 19 15:25:43 2014
@@ -20,12 +20,14 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqlj42082" xml:lang="en-us">
<title>DROP TRIGGER statement</title>
+<shortdesc>The DROP TRIGGER statement removes the specified trigger.</shortdesc>
<prolog><metadata>
<keywords><indexterm>DROP TRIGGER statement</indexterm><indexterm>Triggers<indexterm>dropping</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section> <p>DROP TRIGGER removes the specified trigger.</p></section>
+<section><p>A trigger is created by a <xref href="rrefsqlj43125.dita"/>.</p>
+</section>
<refsyn><title>Syntax</title> <codeblock><b>DROP TRIGGER <i><xref href="rreftriggername.dita#rreftriggername">triggerName</xref></i></b></codeblock> </refsyn>
<example><title>Example</title>
<codeblock><b>DROP TRIGGER TRIG1</b></codeblock> </example>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj43125.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj43125.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj43125.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj43125.dita Mon May 19 15:25:43 2014
@@ -19,6 +19,9 @@ limitations under the License.
-->
<reference id="rrefsqlj43125" xml:lang="en-us">
<title>CREATE TRIGGER statement</title>
+<shortdesc>The CREATE TRIGGER statement creates a trigger, which defines a set
+of actions that are executed when a database event occurs on a specified
+table.</shortdesc>
<prolog><metadata>
<keywords><indexterm>CREATE TRIGGER statement</indexterm><indexterm>SQL statements<indexterm>CREATE
TRIGGER</indexterm></indexterm><indexterm>triggers<indexterm>creating</indexterm></indexterm>
@@ -31,8 +34,7 @@ clause</indexterm><indexterm>referencing
</keywords>
</metadata></prolog>
<refbody>
-<section> <p>A trigger defines a set of actions that are executed when a database
-event occurs on a specified table. A <i>database event</i> is a delete, insert,
+<section> <p>A <i>database event</i> is a delete, insert,
or update operation. For example, if you define a trigger for a delete on
a particular table, the trigger's action occurs whenever someone deletes a
row or rows from the table.</p><p>Along with constraints, triggers can help
Modified: db/derby/docs/trunk/src/ref/rrefsqlj59893.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj59893.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj59893.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj59893.dita Mon May 19 15:25:43 2014
@@ -20,11 +20,13 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqlj59893" xml:lang="en-us">
<title>DROP INDEX statement</title>
+<shortdesc>The DROP INDEX statement removes the specified index.</shortdesc>
<prolog><metadata>
<keywords><indexterm>DROP INDEX statement</indexterm></keywords>
</metadata></prolog>
<refbody>
-<section> <p>DROP INDEX removes the specified index.</p></section>
+<section><p>An index is created by a <xref href="rrefsqlj20937.dita"/>.</p>
+</section>
<refsyn><title>Syntax</title> <codeblock><b>DROP INDEX <i><xref href="rrefindexname.dita#rrefindexname">indexName</xref></i></b></codeblock> </refsyn>
<example><title>Examples</title>
<codeblock><b>DROP INDEX OrigIndex
Modified: db/derby/docs/trunk/src/ref/rrefsqlj61102.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj61102.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj61102.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj61102.dita Mon May 19 15:25:43 2014
@@ -20,12 +20,14 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqlj61102" xml:lang="en-us">
<title>DROP VIEW statement</title>
+<shortdesc>The DROP VIEW statement removes the specified view.</shortdesc>
<prolog><metadata>
<keywords><indexterm>DROP VIEW statement</indexterm><indexterm>Views<indexterm>dropping</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section> <p>Drops the specified view.</p></section>
+<section><p>A view is created by a <xref href="rrefsqlj15446.dita"/>.</p>
+</section>
<refsyn><title>Syntax</title> <codeblock><b>DROP VIEW <i><xref
href="rrefviewname.dita#rrefviewname">viewName</xref></i></b></codeblock> </refsyn>
<example><title>Example</title>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj81859.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj81859.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj81859.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj81859.dita Mon May 19 15:25:43 2014
@@ -20,6 +20,7 @@ limitations under the License.
-->
<reference id="rrefsqlj81859" xml:lang="en-us">
<title>ALTER TABLE statement</title>
+<shortdesc>The ALTER TABLE statement modifies a table.</shortdesc>
<prolog><metadata>
<keywords><indexterm>ALTER TABLE statement</indexterm><indexterm>Compressing
tables</indexterm><indexterm>Tables<indexterm>altering</indexterm><indexterm>compressing</indexterm></indexterm>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj95598.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj95598.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj95598.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj95598.dita Mon May 19 15:25:43 2014
@@ -20,12 +20,12 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqlj95598" xml:lang="en-us">
<title>RENAME INDEX statement</title>
+<shortdesc>The RENAME INDEX statement renames an index in the current schema,
+which can be any schema except the schema <i>SYS</i>.</shortdesc>
<prolog><metadata>
<keywords><indexterm>RENAME INDEX statement</indexterm></keywords>
</metadata></prolog>
<refbody>
-<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><xref
href="rrefindexname.dita#rrefindexname">indexName</xref></i> TO <i>newIndexName</i></b></codeblock> </refsyn>
<example><title>Example</title>
Modified: db/derby/docs/trunk/src/ref/rrefsqljcreateaggregate.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljcreateaggregate.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljcreateaggregate.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljcreateaggregate.dita Mon May 19 15:25:43 2014
@@ -20,6 +20,8 @@ limitations under the License.
-->
<reference id="rrefsqljcreateaggregate" xml:lang="en-us">
<title>CREATE DERBY AGGREGATE statement</title>
+<shortdesc>The CREATE DERBY AGGREGATE statement creates a user-defined
+aggregate (UDA). A UDA is a custom aggregate operator.</shortdesc>
<prolog><metadata>
<keywords><indexterm>CREATE DERBY AGGREGATE statement</indexterm>
<indexterm>SQL statements<indexterm>CREATE DERBY AGGREGATE</indexterm></indexterm>
@@ -28,8 +30,6 @@ limitations under the License.
</keywords>
</metadata></prolog>
<refbody>
-<section><p>The CREATE DERBY AGGREGATE statement creates a user-defined
-aggregate (UDA). A UDA is a custom aggregate operator.</p></section>
<refsyn><title>Syntax</title>
<codeblock><b>CREATE DERBY AGGREGATE <i><xref
href="rrefaggregatename.dita#rrefaggregatename">aggregateName</xref></i> FOR <i>valueDataType</i>
Modified: db/derby/docs/trunk/src/ref/rrefsqljcreatesequence.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljcreatesequence.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljcreatesequence.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljcreatesequence.dita Mon May 19 15:25:43 2014
@@ -20,6 +20,8 @@ limitations under the License.
-->
<reference id="rrefsqljcreatesequence" xml:lang="en-us">
<title>CREATE SEQUENCE statement</title>
+<shortdesc>The CREATE SEQUENCE statement creates a sequence generator, which is
+a mechanism for generating exact numeric values, one at a time.</shortdesc>
<prolog><metadata>
<keywords><indexterm>CREATE SEQUENCE statement</indexterm>
<indexterm>SQL statements<indexterm>CREATE SEQUENCE</indexterm></indexterm>
@@ -27,8 +29,7 @@ limitations under the License.
</keywords>
</metadata></prolog>
<refbody>
-<section><p>The CREATE SEQUENCE statement creates a sequence generator, which is
-a mechanism for generating exact numeric values, one at a time.</p>
+<section>
<p>The owner of the schema where the sequence generator lives automatically
gains the USAGE privilege on the sequence generator, and can grant this
privilege to other users and roles. Only the
Modified: db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita Mon May 19 15:25:43 2014
@@ -19,14 +19,15 @@ limitations under the License.
-->
<reference id="rrefsqljcreatesynonym" xml:lang="en-us">
<title>CREATE SYNONYM statement</title>
+<shortdesc>The CREATE SYNONYM statement provides an alternate name for a table
+or a view that is present in the same schema or another schema.</shortdesc>
<prolog><metadata>
<keywords><indexterm>CREATE SYNONYM statement</indexterm><indexterm>Synonyms<indexterm>creating</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section><p>Use the CREATE SYNONYM statement to provide an alternate name
-for a table or a view that is present in the same schema or another schema.
-You can also create synonyms for other synonyms, resulting in nested synonyms.
+<section>
+<p>You can also create synonyms for other synonyms, resulting in nested synonyms.
A synonym can be used instead of the original qualified table or view name
in SELECT, INSERT, UPDATE, DELETE or LOCK TABLE statements. You can create
a synonym for a table or a view that doesn't exist, but the target table or
Modified: db/derby/docs/trunk/src/ref/rrefsqljcreatetype.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljcreatetype.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljcreatetype.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljcreatetype.dita Mon May 19 15:25:43 2014
@@ -20,6 +20,8 @@ limitations under the License.
-->
<reference id="rrefsqljcreatetype" xml:lang="en-us">
<title>CREATE TYPE statement</title>
+<shortdesc>The CREATE TYPE statement creates a user-defined type (UDT). A UDT is
+a serializable Java class whose instances are stored in columns.</shortdesc>
<prolog><metadata>
<keywords><indexterm>CREATE TYPE statement</indexterm>
<indexterm>SQL statements<indexterm>CREATE TYPE</indexterm></indexterm>
@@ -28,10 +30,7 @@ limitations under the License.
</keywords>
</metadata></prolog>
<refbody>
-<section><p>
-The CREATE TYPE statement creates a user-defined type (UDT). A UDT is a
-serializable Java class whose instances are stored in columns. The class,
-specified by the <xref
+<section><p>The Java class, specified by the <xref
href="rrefsqljexternalname.dita#rrefsqljexternalname"></xref>, must
implement the <i>java.io.Serializable</i> interface.</p></section>
<refsyn><title>Syntax</title>
Modified: db/derby/docs/trunk/src/ref/rrefsqljdropaggregate.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljdropaggregate.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljdropaggregate.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljdropaggregate.dita Mon May 19 15:25:43 2014
@@ -20,6 +20,8 @@ limitations under the License.
-->
<reference id="rrefsqljdropaggregate" xml:lang="en-us">
<title>DROP DERBY AGGREGATE statement</title>
+<shortdesc>The DROP DERBY AGGREGATE statement removes the specified user-defined
+aggregate (UDA).</shortdesc>
<prolog><metadata>
<keywords><indexterm>DROP DERBY AGGREGATE statement</indexterm>
<indexterm>SQL statements<indexterm>DROP DERBY AGGREGATE</indexterm></indexterm>
@@ -28,8 +30,7 @@ limitations under the License.
</keywords>
</metadata></prolog>
<refbody>
-<section><p>The DROP DERBY AGGREGATE statement removes a user-defined aggregate
-(UDA) that was created using a
+<section><p>A UDA is created by a
<xref href="rrefsqljcreateaggregate.dita#rrefsqljcreateaggregate"></xref>.</p>
</section>
<refsyn><title>Syntax</title>
Modified: db/derby/docs/trunk/src/ref/rrefsqljdropsequence.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljdropsequence.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljdropsequence.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljdropsequence.dita Mon May 19 15:25:43 2014
@@ -20,6 +20,8 @@ limitations under the License.
-->
<reference id="rrefsqljdropsequence" xml:lang="en-us">
<title>DROP SEQUENCE statement</title>
+<shortdesc>The DROP SEQUENCE statement removes the specified sequence
+generator.</shortdesc>
<prolog><metadata>
<keywords><indexterm>DROP SEQUENCE statement</indexterm>
<indexterm>SQL statements<indexterm>DROP SEQUENCE</indexterm></indexterm>
@@ -27,8 +29,9 @@ limitations under the License.
</keywords>
</metadata></prolog>
<refbody>
-<section><p>The DROP SEQUENCE statement removes a sequence generator that was
-created using a <xref href="rrefsqljcreatesequence.dita#rrefsqljcreatesequence"></xref>.</p></section>
+<section><p>A sequence generator is created by a
+<xref href="rrefsqljcreatesequence.dita#rrefsqljcreatesequence"></xref>.</p>
+</section>
<refsyn><title>Syntax</title>
<codeblock><b>DROP SEQUENCE <i><xref
href="rrefsequencename.dita#rrefsequencename">sequenceName</xref></i> RESTRICT
Modified: db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita Mon May 19 15:25:43 2014
@@ -20,12 +20,15 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqljdropsynonym" xml:lang="en-us">
<title>DROP SYNONYM statement</title>
+<shortdesc>The DROP SYNONYM statement removes the specified synonym from a table
+or view.</shortdesc>
<prolog><metadata>
<keywords><indexterm>DROP SYNONYM statement</indexterm><indexterm>Synonyms<indexterm>dropping</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section> <p>Drops the specified synonym from a table or view.</p>
+<section><p>A synonym is created by a
+<xref href="rrefsqljcreatesynonym.dita"/>.</p>
<p>An error will occur if there are any views or triggers dependent on the
synonym.</p>
</section>
Modified: db/derby/docs/trunk/src/ref/rrefsqljdroptype.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljdroptype.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljdroptype.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljdroptype.dita Mon May 19 15:25:43 2014
@@ -20,6 +20,8 @@ limitations under the License.
-->
<reference id="rrefsqljdroptype" xml:lang="en-us">
<title>DROP TYPE statement</title>
+<shortdesc>The DROP TYPE statement removes the specified user-defined type
+(UDT).</shortdesc>
<prolog><metadata>
<keywords><indexterm>DROP TYPE statement</indexterm>
<indexterm>SQL statements<indexterm>DROP TYPE</indexterm></indexterm>
@@ -28,9 +30,7 @@ limitations under the License.
</keywords>
</metadata></prolog>
<refbody>
-<section><p>The DROP TYPE statement removes a user-defined type (UDT) that was
-created using a
-<xref href="rrefsqljcreatetype.dita#rrefsqljcreatetype"></xref>.</p>
+<section><p>A UDT is created by a <xref href="rrefsqljcreatetype.dita"/>.</p>
</section>
<refsyn><title>Syntax</title>
<codeblock><b>DROP TYPE <i><xref
Modified: db/derby/docs/trunk/src/ref/rrefsqljgrant.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljgrant.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljgrant.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljgrant.dita Mon May 19 15:25:43 2014
@@ -21,16 +21,17 @@ specific language governing permissions
under the License.
-->
<reference id="rrefsqljgrant" xml:lang="en-us">
-<title>GRANT statement </title>
+<title>GRANT statement</title>
+<shortdesc>The GRANT statement gives privileges to a specific user or role, or
+to all users, to perform actions on database objects.</shortdesc>
<prolog><metadata>
<keywords><indexterm>GRANT statement</indexterm><indexterm>SQL statements<indexterm>GRANT</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
<section>
-<p>Use the GRANT statement to give privileges to a specific user or role, or to
-all users, to perform actions on database objects. You can also use the GRANT
-statement to grant a role to a user, to PUBLIC, or to another role.</p>
+<p>You can also use the GRANT statement to grant a role to a user, to PUBLIC, or
+to another role.</p>
<p>The following types of privileges can be granted:<ul>
<li>Delete data from a specific table.</li>
<li>Insert data into a specific table.</li>
Modified: db/derby/docs/trunk/src/ref/rrefsqljmerge.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljmerge.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljmerge.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljmerge.dita Mon May 19 15:25:43 2014
@@ -22,16 +22,15 @@ under the License.
-->
<reference id="rrefsqljmerge" xml:lang="en-us">
<title>MERGE statement </title>
+<shortdesc>The MERGE statement scans a table and either INSERTs, UPDATEs, or
+DELETEs rows depending on whether the rows satisfy a specified
+condition.</shortdesc>
<prolog><metadata>
<keywords><indexterm>MERGE statement</indexterm>
<indexterm>SQL statements<indexterm>MERGE</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section>
-<p>The MERGE statement scans a table and either INSERTs, UPDATEs, or
-DELETEs rows depending on whether the rows satisfy a specified condition.</p>
-</section>
<refsyn><title>Syntax</title>
<codeblock><b>MERGE INTO <i>targetTable</i> [ [ AS ] <i>targetCorrelationName</i> ]
USING <i>sourceTable</i> [ [ AS ] <i>sourceCorrelationName</i> ]
Modified: db/derby/docs/trunk/src/ref/rrefsqljrenamecolumnstatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljrenamecolumnstatement.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljrenamecolumnstatement.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljrenamecolumnstatement.dita Mon May 19 15:25:43 2014
@@ -18,7 +18,9 @@ See the License for the specific languag
limitations under the License.
-->
<reference id="rrefsqljcolumnstatements" xml:lang="en-us">
- <title>RENAME COLUMN statement </title>
+<title>RENAME COLUMN statement </title>
+<shortdesc>The RENAME COLUMN statement renames an existing column in an existing
+table in any schema (except the schema <i>SYS</i>).</shortdesc>
<prolog><metadata>
<keywords><indexterm>RENAME COLUMN statement</indexterm>
<indexterm><indexterm>SQL statements</indexterm>RENAME COLUMN</indexterm>
@@ -27,11 +29,9 @@ limitations under the License.
</metadata></prolog>
<refbody>
<section>
-<p>Use the RENAME COLUMN statement to rename a column in a table.</p>
-<p>The RENAME COLUMN statement allows you to rename an existing
-column in an existing table in any schema
-(except the schema <i>SYS</i>). </p><p>To rename a column, you must either
-be the database owner or the table owner.</p>
+<p>To rename a column, you must be either the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> or the
+table owner.</p>
<p>Other types of table alterations are possible;
see <xref href="rrefsqlj81859.dita#rrefsqlj81859"></xref>
for more information.</p>
Modified: db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljrenametablestatement.dita Mon May 19 15:25:43 2014
@@ -19,15 +19,15 @@ limitations under the License.
-->
<reference id="rrefsqljrenametablestatement" xml:lang="en-us">
<title>RENAME TABLE statement </title>
+<shortdesc>The RENAME TABLE statement renames an existing table in any schema
+(except the schema <i>SYS</i>).</shortdesc>
<prolog><metadata>
<keywords><indexterm>RENAME TABLE statement</indexterm><indexterm><indexterm>SQL
statements</indexterm>RENAME TABLE</indexterm><indexterm><indexterm>tables</indexterm>renaming</indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section> <p>RENAME TABLE allows you to rename an existing table in any schema
-(except the schema <i>SYS</i>). </p><p>To rename a table, you must either
-be the
+<section><p>To rename a table, you must be either the
<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref>
or the table owner.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>RENAME TABLE <i><xref
Modified: db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita Mon May 19 15:25:43 2014
@@ -19,6 +19,8 @@ See the License for the specific languag
limitations under the License.-->
<reference id="rrefsqljrevoke" xml:lang="en-us">
<title>REVOKE statement </title>
+<shortdesc>The REVOKE statement removes privileges from a specific user or role,
+or from all users, to perform actions on database objects.</shortdesc>
<prolog><metadata>
<keywords><indexterm>REVOKE statement<indexterm>syntax</indexterm></indexterm>
<indexterm>SQL statements<indexterm>REVOKE</indexterm></indexterm><indexterm>REVOKE
@@ -27,10 +29,8 @@ and columns, revoking</indexterm></index
</metadata></prolog>
<refbody>
<section>
-<p>Use the REVOKE statement to remove privileges from a specific user or role,
-or from all users, to perform actions on database objects. You can also use the
-REVOKE statement to revoke a role from a user, from PUBLIC, or from another
-role.</p>
+<p>You can also use the REVOKE statement to revoke a role from a user, from
+PUBLIC, or from another role.</p>
<p>The following types of privileges can be revoked:<ul>
<li>Delete data from a specific table.</li>
<li>Insert data into a specific table.</li>
Modified: db/derby/docs/trunk/src/ref/rrefsqljtruncatetable.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljtruncatetable.dita?rev=1595931&r1=1595930&r2=1595931&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljtruncatetable.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljtruncatetable.dita Mon May 19 15:25:43 2014
@@ -20,16 +20,15 @@ limitations under the License.
-->
<reference id="rrefsqljtruncatetable" xml:lang="en-us">
<title>TRUNCATE TABLE statement</title>
+<shortdesc>The TRUNCATE TABLE statement quickly removes all content from the
+specified table and returns it to its initial empty state.</shortdesc>
<prolog><metadata>
<keywords><indexterm>TRUNCATE TABLE statement</indexterm><indexterm><indexterm>SQL
statements</indexterm>TRUNCATE TABLE</indexterm><indexterm>tables<indexterm>space</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section> <p>The TRUNCATE TABLE statement allows you to quickly remove all
-content from the specified table and return it to its initial empty state.</p>
-<p>To truncate a table, you must either
-be the
+<section><p>To truncate a table, you must be either the
<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref>
or the table owner.</p>
<p>You cannot truncate system tables or global temporary tables with this statement.</p>