db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1527587 [4/4] - /db/derby/docs/trunk/src/ref/
Date Mon, 30 Sep 2013 14:23:21 GMT
Modified: db/derby/docs/trunk/src/ref/rreftableexpression.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreftableexpression.dita?rev=1527587&r1=1527586&r2=1527587&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rreftableexpression.dita (original)
+++ db/derby/docs/trunk/src/ref/rreftableexpression.dita Mon Sep 30 14:23:19 2013
@@ -17,18 +17,18 @@ limitations under the License.
 -->
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
 <reference xml:lang="en-us" id="rreftableexpression">
-<title>TableExpression</title>
+<title>tableExpression</title>
 <prolog><metadata>
-<keywords><indexterm>TableExpression</indexterm>
+<keywords><indexterm>tableExpression</indexterm>
 </keywords>
 </metadata>
 </prolog><refbody>
 <section>
-<p>A <i>TableExpression</i> specifies a table, view, or
+<p>A <i>tableExpression</i> specifies a table, view, or
 function in a <xref href="rrefsqlj21583.dita#rrefsqlj21583">FROM clause</xref>.
It is the source from which
-a <i><xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpression</xref></i>
selects
+a <i><xref href="rrefselectexpression.dita#rrefselectexpression">selectExpression</xref></i>
selects
 a result.</p>
-<p>A correlation name can be applied to a table in a <i>TableExpression</i>
so that its columns can be qualified with that name.
+<p>A correlation name can be applied to a table in a <i>tableExpression</i>
so that its columns can be qualified with that name.
 If you do not supply a correlation name, the table name qualifies the column
 name. When you give a table a correlation name, you cannot use the table name
 to qualify columns. You must use the correlation name when qualifying column
@@ -40,18 +40,21 @@ specified in that FROM clause.</p>
 of the table new names in the AS clause. Some situations in which this is
 useful:  
 <ul>
-<li>When a <xref href="rrefsqlj11277.dita#rrefsqlj11277">VALUES expression</xref>
is used as a <i><xref href="rreftablesubquery.dita#rreftablesubquery">TableSubquery</xref>,</i>
since there is no other way to name
+<li>When a <xref href="rrefsqlj11277.dita#rrefsqlj11277">VALUES expression</xref>
is used as a <i><xref href="rreftablesubquery.dita#rreftablesubquery">tableSubquery</xref>,</i>
since there is no other way to name
 the columns of a <xref href="rrefsqlj11277.dita#rrefsqlj11277">VALUES expression</xref>.</li>
 <li>When column names would otherwise be the same as those of columns in other
 tables; renaming them means you don't have to qualify them.</li>
 </ul></p>
-<p>The Query in a <i><xref href="rreftablesubquery.dita#rreftablesubquery">TableSubquery</xref></i>
appearing in a <i>FromItem</i> can contain
-multiple columns and return multiple rows. See <i><xref href="rreftablesubquery.dita#rreftablesubquery"></xref>.</i></p>
+<p>The <i>query</i> in a
+<i><xref href="rreftablesubquery.dita#rreftablesubquery">tableSubquery</xref></i>
+appearing in a <i>fromItem</i> can contain multiple columns and return multiple
+rows.</p>
 <p>For information about the optimizer overrides you
 can specify, see <cite><ph conref="../conrefs.dita#pub/cittuning"></ph></cite>.</p></section>
 <refsyn><title>Syntax</title>
 <codeblock><b>{
-<i><xref href="rrefsqlj33215.dita#rrefsqlj33215">TableViewOrFunctionExpression</xref></i>
| <xref href="rrefsqlj29840.dita#rrefsqlj29840">JOIN operation</xref>
+    <i><xref href="rrefsqlj33215.dita#rrefsqlj33215">tableViewOrFunctionExpression</xref></i>
|
+    <xref href="rrefsqlj29840.dita#rrefsqlj29840">JOIN operation</xref>
 }
 </b></codeblock>
 </refsyn>

Modified: db/derby/docs/trunk/src/ref/rreftablename.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreftablename.dita?rev=1527587&r1=1527586&r2=1527587&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rreftablename.dita (original)
+++ db/derby/docs/trunk/src/ref/rreftablename.dita Mon Sep 30 14:23:19 2013
@@ -19,13 +19,17 @@ limitations under the License.
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
  "../dtd/reference.dtd">
 <reference id="rreftablename" xml:lang="en-us">
-<title>table-Name</title>
+<title>tableName</title>
 <refbody>
-<section><p>A <i>table-Name</i> represents a table. You can qualify
a <i>table-Name</i> with
-a <i>schemaName</i>.</p></section>
+<section><p>A <i>tableName</i> represents a table. To create a table,
use the
+<xref href="rrefsqlj24513.dita#rrefsqlj24513">CREATE TABLE statement</xref>.</p>
+</section>
 <section><title>Syntax</title> <codeblock><b>[ <i><xref
href="rrefschemaname.dita#rrefschemaname">schemaName</xref>.</i> ] <i><xref
-href="crefsqlj34834.dita#crefsqlj34834">SQL92Identifier</xref></i></b></codeblock></section>
-<section><title>Example</title> <codeblock><b><ph>--
SAMP.PROJECT is a table-Name that includes a schemaName</ph>
+href="crefsqlj34834.dita#crefsqlj34834">SQL92Identifier</xref></i></b></codeblock>
+<p>You can qualify a table name with a <i>schemaName</i>. If a qualified
+table name is specified, the schema name cannot begin with SYS.</p>
+</section>
+<section><title>Example</title> <codeblock><b><ph>--
SAMP.PROJECT is a tableName that includes a schemaName</ph>
 SELECT COUNT(*) FROM SAMP.PROJECT</b></codeblock></section>
 </refbody>
 </reference>

Modified: db/derby/docs/trunk/src/ref/rreftablesubquery.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreftablesubquery.dita?rev=1527587&r1=1527586&r2=1527587&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rreftablesubquery.dita (original)
+++ db/derby/docs/trunk/src/ref/rreftablesubquery.dita Mon Sep 30 14:23:19 2013
@@ -17,43 +17,43 @@ limitations under the License.
 -->
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
 <reference xml:lang="en-us" id="rreftablesubquery">
-<title>TableSubquery</title>
+<title>tableSubquery</title>
 <prolog><metadata>
-<keywords><indexterm>TableSubquery</indexterm>
+<keywords><indexterm>tableSubquery</indexterm>
 </keywords>
 </metadata>
 </prolog><refbody>
 <section>
-<p>A <i>TableSubquery</i> is a subquery that returns
+<p>A <i>tableSubquery</i> is a subquery that returns
 multiple rows.</p> 
-<p>Unlike a <i><xref href="rrefscalarsubquery.dita#rrefscalarsubquery">ScalarSubquery</xref>,</i>
a <i>TableSubquery</i> is allowed only:
+<p>Unlike a <i><xref href="rrefscalarsubquery.dita#rrefscalarsubquery">scalarSubquery</xref>,</i>
a <i>tableSubquery</i> is allowed only:
  
 <ul>
-<li>as a <i><xref href="rreftableexpression.dita#rreftableexpression">TableExpression</xref></i>
in
+<li>As a <i><xref href="rreftableexpression.dita#rreftableexpression">tableExpression</xref></i>
in
 a <xref href="rrefsqlj21583.dita#rrefsqlj21583">FROM clause</xref></li>
-<li>with EXISTS, IN, or quantified comparisons.</li>
+<li>With EXISTS, IN, or quantified comparisons</li>
 </ul></p> 
 <p>When used as a
-<i><xref href="rreftableexpression.dita#rreftableexpression">TableExpression</xref></i>
+<i><xref href="rreftableexpression.dita#rreftableexpression">tableExpression</xref></i>
 in a <xref href="rrefsqlj21583.dita#rrefsqlj21583">FROM clause</xref>, or with
 EXISTS, it can return multiple columns. </p>
 <p>When used with IN or quantified
 comparisons, it must return a single column.</p></section>
 <refsyn><title>Syntax</title>
-<codeblock><b>( <i><xref href="rrefsqlj21571.dita#rrefsqlj21571">Query</xref></i>
+<codeblock><b>( <i><xref href="rrefsqlj21571.dita#rrefsqlj21571">query</xref></i>
     [ <i><xref href="rrefsqlj13658.dita#rrefsqlj13658">ORDER BY clause</xref></i>
]
     [ <i><xref href="rrefsqljoffsetfetch.dita#rrefsqljoffsetfetch">result offset
clause</xref></i> ]
     [ <i><xref href="rrefsqljoffsetfetch.dita#rrefsqljoffsetfetch">fetch first
clause</xref></i> ]
 )</b></codeblock>
 </refsyn>
-<example><title>Example</title><codeblock><b><ph>-- a
subquery used as a TableExpression in a FROM clause</ph>
+<example><title>Example</title><codeblock><b><ph>-- a
subquery used as a tableExpression in a FROM clause</ph>
 SELECT VirtualFlightTable.flight_ID
 FROM
     (SELECT flight_ID, orig_airport, dest_airport
     FROM Flights
     WHERE (orig_airport = 'SFO' OR dest_airport = 'SCL') )
 AS VirtualFlightTable
-<ph>-- a subquery (values expression) used as a TableExpression
+<ph>-- a subquery (values expression) used as a tableExpression
 -- in a FROM clause</ph>
 SELECT mycol1
 FROM

Modified: db/derby/docs/trunk/src/ref/rreftriggername.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreftriggername.dita?rev=1527587&r1=1527586&r2=1527587&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rreftriggername.dita (original)
+++ db/derby/docs/trunk/src/ref/rreftriggername.dita Mon Sep 30 14:23:19 2013
@@ -19,11 +19,17 @@ limitations under the License.
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
  "../dtd/reference.dtd">
 <reference id="rreftriggername" xml:lang="en-us">
-<title>TriggerName</title>
+<title>triggerName</title>
 <refbody>
-<section><p>A<i> TriggerName</i> refers to a trigger created by a
user.</p></section>
+<section><p>A <i>triggerName</i> refers to a trigger created by a
user.
+To create a trigger, use the
+<xref href="rrefsqlj43125.dita#rrefsqlj43125">CREATE TRIGGER statement</xref>.
+</p></section>
 <section><title>Syntax</title> <codeblock><b>[ <i><xref
href="rrefschemaname.dita#rrefschemaname">schemaName</xref></i> . ] <i><xref
-href="crefsqlj34834.dita#crefsqlj34834">SQL92Identifier</xref></i></b></codeblock></section>
+href="crefsqlj34834.dita#crefsqlj34834">SQL92Identifier</xref></i></b></codeblock>
+<p>You can qualify a trigger name with a <i>schemaName</i>. If a qualified
+trigger name is specified, the schema name cannot begin with SYS.</p>
+</section>
 <section><title>Example</title> <codeblock><b>DROP TRIGGER
TRIG1</b></codeblock></section>
 </refbody>
 </reference>

Added: db/derby/docs/trunk/src/ref/rreftypename.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreftypename.dita?rev=1527587&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreftypename.dita (added)
+++ db/derby/docs/trunk/src/ref/rreftypename.dita Mon Sep 30 14:23:19 2013
@@ -0,0 +1,41 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+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 id="rreftypename" xml:lang="en-us">
+<title>typeName</title>
+<refbody>
+<section>
+<p>A <i>typeName</i> represents a user-defined type (UDT). To create a
UDT,
+use the
+<xref href="rrefsqljcreatetype.dita#rrefsqljcreatetype"></xref>.</p>
+</section>
+<section><title>Syntax</title>
+<codeblock><b>[ <i><xref href="rrefschemaname.dita#rrefschemaname">schemaName</xref>.</i>
] <i><xref
+href="crefsqlj34834.dita#crefsqlj34834">SQL92Identifier</xref></i></b></codeblock>
+<p>You can qualify a type name with a <i>schemaName</i>. If a qualified
type
+name is specified, the schema name cannot begin with SYS.</p>
+</section>
+<section><title>Example</title>
+<codeblock><b>CREATE TYPE price
+EXTERNAL NAME 'com.example.types.Price'
+LANGUAGE JAVA</b></codeblock>
+</section>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreftypename.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: db/derby/docs/trunk/src/ref/rrefviewname.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefviewname.dita?rev=1527587&r1=1527586&r2=1527587&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefviewname.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefviewname.dita Mon Sep 30 14:23:19 2013
@@ -19,13 +19,18 @@ limitations under the License.
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
  "../dtd/reference.dtd">
 <reference id="rrefviewname" xml:lang="en-us">
-<title>view-Name</title>
+<title>viewName</title>
 <refbody>
-<section><p>A <i>view-Name</i> represents a table or a view. You
can qualify
-a <i>view-Name</i> with a <i>schema-Name</i>.</p></section>
+<section><p>A <i>viewName</i> represents a table or a view. To create
a view,
+use the <xref
+href="rrefsqlj15446.dita#rrefsqlj15446">CREATE VIEW statement</xref>.</p>
+</section>
 <section><title>Syntax</title> <codeblock><b>[ <i><xref
href="rrefschemaname.dita#rrefschemaname">schemaName</xref>.</i> ] <i><xref
-href="crefsqlj34834.dita#crefsqlj34834">SQL92Identifier</xref></i></b></codeblock></section>
-<section><title>Example</title> <codeblock><b><ph>--
This is a View qualified by a schema-Name</ph>
+href="crefsqlj34834.dita#crefsqlj34834">SQL92Identifier</xref></i></b></codeblock>
+<p>You can qualify a view name with a <i>schemaName</i>. If a qualified
+view name is specified, the schema name cannot begin with SYS.</p>
+</section>
+<section><title>Example</title> <codeblock><b><ph>--
This is a view qualified by a schemaName</ph>
 SELECT COUNT(*) FROM SAMP.EMP_RESUME</b></codeblock></section>
 </refbody>
 </reference>



Mime
View raw message