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 2005/06/29 00:46:37 UTC
svn commit: r202296 [12/16] - in /incubator/derby/docs/trunk/src:
adminguide/ devguide/ getstart/ ref/ tools/ tuning/
Modified: incubator/derby/docs/trunk/src/ref/rrefsql9241891.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsql9241891.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsql9241891.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsql9241891.dita Tue Jun 28 15:46:15 2005
@@ -1,4 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
<!--
Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
@@ -14,897 +16,1097 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
<reference id="rrefsql9241891" xml:lang="en-us">
-<title>Derby support for
-SQL-92 features </title>
+<title>Derby support for SQL-92 features </title>
<prolog><metadata>
<keywords><indexterm>SQL-92<indexterm>features supported by Derby</indexterm><indexterm>features
not supported by Derby</indexterm></indexterm></keywords>
</metadata></prolog>
<refbody>
-<section><p><xref href="rrefsql9241891.dita#rrefsql9241891/sql921038347"></xref> shows the SQL-92
-features that <ph conref="refconrefs.dita#prod/productshortname"></ph> supports.
-There are four levels of SQL-92 support: <ul>
+<section><p> There are four levels of SQL-92 support: <ul>
<li>SQL92E <p>Entry</p></li>
<li>SQL92T <p>Transitional, a level defined by NIST in a publication called
FIPS 127-2</p></li>
<li>SQL92I <p>Intermediate</p></li>
<li>SQL92F <p>Full</p></li>
-</ul> <table frame="all" id="sql921038347"><title>Support for SQL-92 Features</title>
-<tgroup cols="4" colsep="1" rowsep="1"><colspec colname="1" colnum="1"/>
-<colspec colname="2" colnum="2"/><colspec colname="3" colnum="3"/><colspec colname="4" colnum="4"/>
+</ul> <table><title>Support for SQL-92 Features: Basic types</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
<thead>
-<row>
-<entry align="left" nameend="2" namest="1" valign="bottom">Feature</entry>
-<entry align="left" colname="3" valign="bottom">Source</entry>
-<entry align="left" colname="4" valign="bottom"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
</thead>
<tbody>
<row>
-<entry nameend="2" namest="1"><i>Basic types</i></entry>
-<entry colname="3" morerows="8">SQL92E</entry>
-<entry colname="4"></entry>
-</row>
-<row>
-<entry colname="1"></entry>
-<entry colname="2">SMALLINT</entry>
-<entry colname="4">yes</entry>
-</row>
-<row>
-<entry colname="1"></entry>
-<entry colname="2">INTEGER</entry>
-<entry colname="4">yes</entry>
-</row>
-<row>
-<entry colname="1"></entry>
-<entry colname="2">DECIMAL(p,s)</entry>
-<entry colname="4">yes</entry>
-</row>
-<row>
-<entry colname="1"></entry>
-<entry colname="2">NUMERIC(p,s)</entry>
-<entry colname="4">yes</entry>
-</row>
-<row>
-<entry colname="1"></entry>
-<entry colname="2">REAL</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">SMALLINT</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">FLOAT(p)</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">INTEGER</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">DOUBLE PRECISION</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">DECIMAL(p,s)</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">CHAR(n)</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">NUMERIC(p,s)</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1"><i>Basic math operations</i></entry>
-<entry colname="3" morerows="1">SQL92E</entry>
-<entry colname="4"></entry>
+<entry colname="col1">REAL</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">+, *, -, /, unary +, unary -</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">FLOAT(p)</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1"><i>Basic comparisons</i></entry>
-<entry colname="3" morerows="1">SQL92E</entry>
-<entry colname="4"></entry>
+<entry colname="col1">DOUBLE PRECISION</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2"><, >, <= ,>=, <>, =</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">CHAR(n)</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
-<row>
-<entry nameend="2" namest="1"><i>Basic predicates</i></entry>
-<entry colname="3" morerows="1">SQL92E</entry>
-<entry colname="4"></entry>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Basic math operations</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="1"></entry>
-<entry colname="2">BETWEEN, LIKE, NULL</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">+, *, -, /, unary +, unary -</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Basic comparisons</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry nameend="2" namest="1"><i>Quantified predicates</i></entry>
-<entry colname="3" morerows="1">SQL92E</entry>
-<entry colname="4"></entry>
+<entry colname="col1"><, >, <= ,>=, <>, =</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Basic predicates</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="1"></entry>
-<entry colname="2">IN, ALL/SOME, EXISTS</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">BETWEEN, LIKE, NULL</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Quantified predicates</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry nameend="2" namest="1"><i>schema definition</i></entry>
-<entry colname="3" morerows="3">SQL92E</entry>
-<entry colname="4"></entry>
+<entry colname="col1">IN, ALL/SOME, EXISTS</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: schema definition</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="1"></entry>
-<entry colname="2">tables</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">tables</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">views</entry>
-<entry colname="4">yes (not updatable)</entry>
+<entry colname="col1">views</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">privileges</entry>
-<entry colname="4">no, but you can configure databases for user authentication
-and restriction to read-only access</entry>
+<entry colname="col1">privileges</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
-<row>
-<entry nameend="2" namest="1"><i>column attributes</i></entry>
-<entry colname="3" morerows="2">SQL92E</entry>
-<entry colname="4"></entry>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: column attributes</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="1"></entry>
-<entry colname="2">default values</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">default values</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">nullability</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">nullability</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: constraints (non-deferrable)</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry nameend="2" namest="1"><i>constraints (non-deferrable)</i></entry>
-<entry colname="3" morerows="5">SQL92E</entry>
-<entry colname="4"></entry>
+<entry colname="col1">NOT NULL</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes (not stored in SYSCONSTRAINTS)</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">NOT NULL</entry>
-<entry colname="4">yes (not stored in SYSCONSTRAINTS)</entry>
+<entry colname="col1">UNIQUE/PRIMARY KEY</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">UNIQUE/PRIMARY KEY</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">FOREIGN KEY</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">FOREIGN KEY</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">CHECK</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">CHECK</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">View WITH CHECK OPTION</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">no, since views are not updatable</entry>
</row>
-<row>
-<entry colname="1"></entry>
-<entry colname="2">View WITH CHECK OPTION</entry>
-<entry colname="4">no, since views are not updatable</entry>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Cursors</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry nameend="2" namest="1">Delimited identifiers</entry>
-<entry colname="3">SQL92E</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">DECLARE, OPEN, FETCH, CLOSE</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">done through JDBC</entry>
</row>
<row>
-<entry nameend="2" namest="1">Correlated subqueries</entry>
-<entry colname="3">SQL92E</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">UPDATE, DELETE CURRENT</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Dynamic SQL 1</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry nameend="2" namest="1"><i>Cursors</i></entry>
-<entry colname="3" morerows="2">SQL92E</entry>
-<entry colname="4"></entry>
+<entry colname="col1">ALLOCATE / DEALLOCATE / GET / SET DESCRIPTOR</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">done through JDBC</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">DECLARE, OPEN, FETCH, CLOSE</entry>
-<entry colname="4">done through JDBC</entry>
+<entry colname="col1">PREPARE / EXECUTE / EXECUTE IMMEDIATE</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">done through JDBC</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">UPDATE, DELETE CURRENT</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">DECLARE, OPEN, FETCH, CLOSE, UPDATE, DELETE dynamic
+cursor</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">done through JDBC</entry>
</row>
<row>
-<entry nameend="2" namest="1">Insert, Update, Delete statements</entry>
-<entry colname="3">SQL92E</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">DESCRIBE output</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">done through JDBC</entry>
</row>
-<row>
-<entry nameend="2" namest="1">Joins</entry>
-<entry colname="3">SQL92E</entry>
-<entry colname="4">yes</entry>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Basic information schema</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry nameend="2" namest="1">Where qualifications</entry>
-<entry colname="3">SQL92E</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">TABLES</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3"><i>SYS.SYSTABLES, SYS.SYSVIEWS, SYS.SYSCOLUMNS</i></entry>
</row>
<row>
-<entry nameend="2" namest="1">Group by</entry>
-<entry colname="3">SQL92E</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">VIEWS</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3"><i>SYS.SYSTABLES, SYS.SYSVIEWS, SYS.SYSCOLUMNS</i></entry>
</row>
<row>
-<entry nameend="2" namest="1">Having</entry>
-<entry colname="3">SQL92E</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">COLUMNS</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3"><i>SYS.SYSTABLES, SYS.SYSVIEWS, SYS.SYSCOLUMNS</i></entry>
</row>
-<row>
-<entry nameend="2" namest="1">Aggregate functions</entry>
-<entry colname="3">SQL92E</entry>
-<entry colname="4">yes</entry>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Basic schema manipulation</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry nameend="2" namest="1">Order by</entry>
-<entry colname="3">SQL92E</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">CREATE / DROP TABLE</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Select expressions</entry>
-<entry colname="3">SQL92E</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">CREATE / DROP VIEW</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Select *</entry>
-<entry colname="3">SQL92E</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">GRANT / REVOKE</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">SQLCODE</entry>
-<entry colname="3">SQL92E</entry>
-<entry colname="4">no, deprecated in SQL-92</entry>
+<entry colname="col1">ALTER TABLE ADD COLUMN</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">SQLSTATE</entry>
-<entry colname="3">SQL92E</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">ALTER TABLE DROP COLUMN</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
-<row>
-<entry nameend="2" namest="1"><i>Dynamic SQL 1</i></entry>
-<entry colname="3" morerows="4">SQL92T</entry>
-<entry colname="4" morerows="4">done through JDBC</entry>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Joined table</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="1"></entry>
-<entry colname="2">ALLOCATE/DEALLOCATE/ GET/SET DESCRIPTOR</entry>
+<entry colname="col1">INNER JOIN</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">PREPARE/EXECUTE/ EXECUTE IMMEDIATE</entry>
+<entry colname="col1">natural join</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">DECLARE, OPEN, FETCH, CLOSE, UPDATE, DELETE dynamic cursor</entry>
+<entry colname="col1">LEFT, RIGHT OUTER JOIN</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">DESCRIBE output</entry>
+<entry colname="col1">join condition</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1"><i>Basic information schema</i></entry>
-<entry colname="3" morerows="3">SQL92T</entry>
-<entry colname="4" morerows="3"><i>SYS.SYSTABLES, SYS.SYSVIEWS, SYS.SYSCOLUMNS</i></entry>
+<entry colname="col1">named columns join</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
-<row>
-<entry colname="1"></entry>
-<entry colname="2">TABLES</entry>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Joined table</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="1"></entry>
-<entry colname="2">VIEWS</entry>
+<entry colname="col1">simple DATE, TIME, TIMESTAMP, INTERVAL</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes, not INTERVAL</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">COLUMNS</entry>
+<entry colname="col1">datetime constants</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1"><i>Basic schema manipulation</i></entry>
-<entry colname="3" morerows="5">SQL92T</entry>
-<entry colname="4"></entry>
+<entry colname="col1">datetime math</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">can do with Java methods</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">CREATE/DROP TABLE</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">datetime comparisons</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">CREATE/DROP VIEW</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">predicates: OVERLAPS</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">can do with Java methods</entry>
</row>
-<row>
-<entry colname="1"></entry>
-<entry colname="2">GRANT/REVOKE</entry>
-<entry colname="4">no</entry>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: VARCHAR</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="1"></entry>
-<entry colname="2">ALTER TABLE ADD COLUMN</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">LENGTH</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">ALTER TABLE DROP COLUMN</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">concatenation (||)</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Transaction isolation</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry nameend="2" namest="1"><i>Joined table</i></entry>
-<entry colname="3" morerows="5">SQL92T</entry>
-<entry colname="4"></entry>
+<entry colname="col1">READ WRITE / READ ONLY</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">through JDBC, database properties, and storage media.</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">INNER JOIN</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">RU, RC, RR, SER</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Multiple schemas per user</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="1"></entry>
-<entry colname="2">natural join</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">SCHEMATA view</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3"><i>SYS.SYSSCHEMAS</i></entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Privilege tables</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="1"></entry>
-<entry colname="2">LEFT, RIGHT OUTER JOIN</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">TABLE_PRIVILEGES</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">join condition</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">COLUMNS_PRIVILEGES</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">named columns join</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">USAGE_PRIVILEGES</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">no</entry>
</row>
-<row>
-<entry nameend="2" namest="1"><i>DATETIME data types 1</i></entry>
-<entry colname="3" morerows="5">SQL92T</entry>
-<entry colname="4"></entry>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Table operations</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="1"></entry>
-<entry colname="2">simple DATE, TIME, TIMESTAMP, INTERVAL</entry>
-<entry colname="4">yes, not INTERVAL</entry>
+<entry colname="col1">UNION relaxations</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">datetime constants</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">EXCEPT</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">datetime math</entry>
-<entry colname="4">can do with Java methods</entry>
+<entry colname="col1">INTERSECT</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">datetime comparisons</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">CORRESPONDING</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">no</entry>
</row>
-<row>
-<entry colname="1"></entry>
-<entry colname="2">predicates: OVERLAPS</entry>
-<entry colname="4">can do with Java methods</entry>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Schema definition statement</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry nameend="2" namest="1"><i>VARCHAR</i></entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">CREATE SCHEMA</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">yes, partially</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: User authorization</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="1"></entry>
-<entry colname="2">LENGTH</entry>
-<entry colname="3" morerows="1"></entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">SET SESSION AUTHORIZATION</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">use set schema</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">concatenation (||)</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">CURRENT_USER</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">UNION, INTERSECT, and EXCEPT in views</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">SESSION_USER</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Implicit numeric casting</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">SYSTEM_USER</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">no</entry>
</row>
-<row>
-<entry nameend="2" namest="1">Implicit character casting</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">yes</entry>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Constraint tables</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry nameend="2" namest="1"><i>Transaction isolation</i></entry>
-<entry colname="3" morerows="2">SQL92T</entry>
-<entry colname="4"></entry>
+<entry colname="col1">TABLE CONSTRAINTS</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3"><i>SYS.SYSCONSTRAINTS</i></entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">READ WRITE/READ ONLY</entry>
-<entry colname="4">through JDBC, database properties, and storage media.</entry>
+<entry colname="col1">REFERENTIAL CONSTRAINTS</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3"><i>SYS.SYSFOREIGNKEYS</i></entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">RU, RC, RR, SER</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">CHECK CONSTRAINTS</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3"><i>SYS.SYSCHECKS</i></entry>
</row>
-<row>
-<entry nameend="2" namest="1">Get diagnostics</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">use JDBC <i>SQLExceptions</i></entry>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Documentation schema</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry nameend="2" namest="1">Grouped operations</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">SQL_FEATURES</entry>
+<entry colname="col2">SQL92I/FIPS 127-2</entry>
+<entry colname="col3">use JDBC <i>DatabaseMetaData</i></entry>
</row>
<row>
-<entry nameend="2" namest="1">Qualified * in select list</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">SQL_SIZING</entry>
+<entry colname="col2">SQL92I/FIPS 127-2</entry>
+<entry colname="col3">use JDBC <i>DatabaseMetaData</i></entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Full DATETIME</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry nameend="2" namest="1">Lowercase identifiers</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">precision for TIME and TIMESTAMP</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Full character functions</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry nameend="2" namest="1">nullable PRIMARY KEYs</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">POSITION expression</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">use Java methods or LOCATE</entry>
</row>
<row>
-<entry nameend="2" namest="1"><i>Multiple schemas per user</i></entry>
-<entry colname="3" morerows="1">SQL92T</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">UPPER/LOWER functions</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table><table><title>Support for SQL-92 Features: Miscellaneous</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Feature</entry>
+<entry colname="col2">Source</entry>
+<entry colname="col3"><ph conref="refconrefs.dita#prod/productshortname"></ph></entry>
</row>
+</thead>
+<tbody>
<row>
-<entry colname="1"></entry>
-<entry colname="2">SCHEMATA view</entry>
-<entry colname="4"><i>SYS.SYSSCHEMAS</i></entry>
+<entry colname="col1">Delimited identifiers</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Multiple module support</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">no (not required and not part of JDBC)</entry>
+<entry colname="col1">Correlated subqueries</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Referential delete actions</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">CASCADE, SET NULL, RESTRICT, and NO ACTION.</entry>
+<entry colname="col1">Insert, Update, Delete statements</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">CAST functions</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Joins</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">INSERT expressions</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Where qualifications</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Explicit defaults</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Group by</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1"><i>Privilege tables</i></entry>
-<entry colname="3" morerows="3">SQL92T</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Having</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">TABLE_PRIVILEGES</entry>
-<entry colname="4"></entry>
+<entry colname="col1">Aggregate functions</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">COLUMNS_PRIVILEGES</entry>
-<entry colname="4"></entry>
+<entry colname="col1">Order by</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">USAGE_PRIVILEGES</entry>
-<entry colname="4"></entry>
+<entry colname="col1">Select expressions</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Keyword relaxations</entry>
-<entry colname="3">SQL92T</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Select *</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Domain definition</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">SQLCODE</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">no, deprecated in SQL-92</entry>
</row>
<row>
-<entry nameend="2" namest="1">CASE expression</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">partial support</entry>
+<entry colname="col1">SQLSTATE</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Compound character string constantss</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">use concatenation</entry>
+<entry colname="col1">UNION, INTERSECT, and EXCEPT in views</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">LIKE enhancements</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Implicit numeric casting</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">UNIQUE predicate</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Implicit character casting</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1"><i>Table operations</i></entry>
-<entry colname="3" morerows="4">SQL92I</entry>
-<entry colname="4"></entry>
+<entry colname="col1">Get diagnostics</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">use JDBC <i>SQLExceptions</i></entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">UNION relaxations</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Grouped operations</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">EXCEPT</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Qualified * in select list</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">INTERSECT</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Lowercase identifiers</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">CORRESPONDING</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">nullable PRIMARY KEYs</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1"><i>Schema definition statement</i></entry>
-<entry colname="3" morerows="1">SQL92I</entry>
-<entry colname="4"></entry>
+<entry colname="col1">Multiple module support</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">no (not required and not part of JDBC)</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">CREATE SCHEMA</entry>
-<entry colname="4">yes, partially</entry>
+<entry colname="col1">Referential delete actions</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">CASCADE, SET NULL, RESTRICT, and NO ACTION.</entry>
</row>
<row>
-<entry nameend="2" namest="1"><i>User authorization</i></entry>
-<entry colname="3" morerows="4">SQL92I</entry>
-<entry colname="4"></entry>
+<entry colname="col1">CAST functions</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">SET SESSION AUTHORIZATION</entry>
-<entry colname="4">use set schema</entry>
+<entry colname="col1">INSERT expressions</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">CURRENT_USER</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Explicit defaults</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">SESSION_USER</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Keyword relaxations</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">SYSTEM_USER</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Domain definition</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1"><i>Constraint tables</i></entry>
-<entry colname="3" morerows="3">SQL92I</entry>
-<entry colname="4"></entry>
+<entry colname="col1">CASE expression</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">partial support</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">TABLE_CONSTRAINTS</entry>
-<entry colname="4"><i>SYS.SYSCONSTRAINTS</i></entry>
+<entry colname="col1">Compound character string constantss</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">use concatenation</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">REFERENTIAL_CONSTRAINTS</entry>
-<entry colname="4"><i>SYS.SYSFOREIGNKEYS</i></entry>
+<entry colname="col1">LIKE enhancements</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">CHECK_CONSTRAINTS</entry>
-<entry colname="4"><i>SYS.SYSCHECKS</i></entry>
+<entry colname="col1">UNIQUE predicate</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">Usage tables</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4"><i>SYS.SYSDEPENDS</i> </entry>
+<entry colname="col1">Usage tables</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3"><i>SYS.SYSDEPENDS</i> </entry>
</row>
<row>
-<entry nameend="2" namest="1">Intermediate information schema</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">use JDBC <i>DatabaseMetaData</i> and <ph conref="refconrefs.dita#prod/productshortname"></ph> system
+<entry colname="col1">Intermediate information schema</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">use JDBC <i>DatabaseMetaData</i> and <ph conref="refconrefs.dita#prod/productshortname"></ph> system
tables</entry>
</row>
<row>
-<entry nameend="2" namest="1">Subprogram support</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">not relevant to JDBC, which is much richer</entry>
+<entry colname="col1">Subprogram support</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">not relevant to JDBC, which is much richer</entry>
</row>
<row>
-<entry nameend="2" namest="1">Intermediate SQL Flagging</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Intermediate SQL Flagging</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">Schema manipulation</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">yes, to drop a default, set it to NULL.</entry>
+<entry colname="col1">Schema manipulation</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">yes, to drop a default, set it to NULL.</entry>
</row>
<row>
-<entry nameend="2" namest="1">Long identifiers</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Long identifiers</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Full outer join</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Full outer join</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">Time zone specification</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Time zone specification</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">Scrolled cursors</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">partial (scrolling insensitive result sets through JDBC
+<entry colname="col1">Scrolled cursors</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">partial (scrolling insensitive result sets through JDBC
2.0)</entry>
</row>
<row>
-<entry nameend="2" namest="1">Intermediate set function support</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">partial</entry>
-</row>
-<row>
-<entry nameend="2" namest="1">Character set definition</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">supports Java locales</entry>
-</row>
-<row>
-<entry nameend="2" namest="1">Named character sets</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">supports Java locales</entry>
-</row>
-<row>
-<entry nameend="2" namest="1">Scalar subquery values</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">yes</entry>
-</row>
-<row>
-<entry nameend="2" namest="1">Expanded null predicate</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">yes</entry>
-</row>
-<row>
-<entry nameend="2" namest="1">Constraint management</entry>
-<entry colname="3">SQL92I</entry>
-<entry colname="4">yes (ADD/DROP CONSTRAINT)</entry>
-</row>
-<row>
-<entry nameend="2" namest="1"><i>Documentation schema</i></entry>
-<entry colname="3" morerows="2">SQL92I/FIPS 127-2</entry>
-<entry colname="4"></entry>
-</row>
-<row>
-<entry colname="1"></entry>
-<entry colname="2">SQL_FEATURES</entry>
-<entry colname="4">use JDBC <i>DatabaseMetaData</i></entry>
-</row>
-<row>
-<entry colname="1"></entry>
-<entry colname="2">SQL_SIZING</entry>
-<entry colname="4">use JDBC <i>DatabaseMetaData</i></entry>
+<entry colname="col1">Intermediate set function support</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">partial</entry>
</row>
<row>
-<entry nameend="2" namest="1">FOR BIT DATA types</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">yes </entry>
+<entry colname="col1">Character set definition</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">supports Java locales</entry>
</row>
<row>
-<entry nameend="2" namest="1">Assertion constraints</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Named character sets</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">supports Java locales</entry>
</row>
<row>
-<entry nameend="2" namest="1">Temporary tables</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">IBM specific syntax only</entry>
+<entry colname="col1">Scalar subquery values</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Full dynamic SQL</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Expanded null predicate</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1"><i>Full DATETIME</i></entry>
-<entry colname="3" morerows="1">SQL92F</entry>
-<entry colname="4"></entry>
+<entry colname="col1">Constraint management</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">yes (ADD/DROP CONSTRAINT)</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">precision for TIME and TIMESTAMP</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">FOR BIT DATA types</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">yes </entry>
</row>
<row>
-<entry nameend="2" namest="1">Full value expressions</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Assertion constraints</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">Truth value tests</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Temporary tables</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">IBM specific syntax only</entry>
</row>
<row>
-<entry nameend="2" namest="1"><i>Full character functions</i></entry>
-<entry colname="3" morerows="2">SQL92F</entry>
-<entry colname="4"></entry>
+<entry colname="col1">Full dynamic SQL</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">POSITION expression</entry>
-<entry colname="4">use Java methods or LOCATE</entry>
+<entry colname="col1">Full value expressions</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry colname="1"></entry>
-<entry colname="2">UPPER/LOWER functions</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Truth value tests</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Derived tables in FROM</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Derived tables in FROM</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Trailing underscore</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Trailing underscore</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Indicator data types</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">not relevant to JDBC</entry>
+<entry colname="col1">Indicator data types</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">not relevant to JDBC</entry>
</row>
<row>
-<entry nameend="2" namest="1">Referential name order</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Referential name order</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">Full SQL Flagging</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Full SQL Flagging</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">Row and table constructors</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Row and table constructors</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Catalog name qualifiers</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Catalog name qualifiers</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">Simple tables</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Simple tables</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">Subqueries in CHECK</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no, but can do with Java methods</entry>
+<entry colname="col1">Subqueries in CHECK</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no, but can do with Java methods</entry>
</row>
<row>
-<entry nameend="2" namest="1">Union join</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Union join</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">Collation and translation</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">Java locales supported</entry>
+<entry colname="col1">Collation and translation</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Java locales supported</entry>
</row>
<row>
-<entry nameend="2" namest="1">Referential update actions</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">RESTRICT and NO ACTION. Can do others with triggers.</entry>
+<entry colname="col1">Referential update actions</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">RESTRICT and NO ACTION. Can do others with triggers.</entry>
</row>
<row>
-<entry nameend="2" namest="1">ALTER domain</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">ALTER domain</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">INSERT column privileges</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">INSERT column privileges</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">Referential MATCH types</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Referential MATCH types</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">View CHECK enhancements</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no, views not updateable</entry>
+<entry colname="col1">View CHECK enhancements</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no, views not updateable</entry>
</row>
<row>
-<entry nameend="2" namest="1">Session management</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">use JDBC</entry>
+<entry colname="col1">Session management</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">use JDBC</entry>
</row>
<row>
-<entry nameend="2" namest="1">Connection management</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">use JDBC</entry>
+<entry colname="col1">Connection management</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">use JDBC</entry>
</row>
<row>
-<entry nameend="2" namest="1">Self-referencing operations</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">yes</entry>
+<entry colname="col1">Self-referencing operations</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
-<entry nameend="2" namest="1">Insensitive cursors</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">Yes through JDBC 2.0</entry>
+<entry colname="col1">Insensitive cursors</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Yes through JDBC 2.0</entry>
</row>
<row>
-<entry nameend="2" namest="1">Full set function</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">partially</entry>
+<entry colname="col1">Full set function</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">partially</entry>
</row>
<row>
-<entry nameend="2" namest="1">Catalog flagging</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Catalog flagging</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">Local table references</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Local table references</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
</row>
<row>
-<entry nameend="2" namest="1">Full cursor update</entry>
-<entry colname="3">SQL92F</entry>
-<entry colname="4">no</entry>
+<entry colname="col1">Full cursor update</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">no</entry>
</row>
</tbody>
</tgroup>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj11277.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj11277.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj11277.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj11277.dita Tue Jun 28 15:46:15 2005
@@ -30,12 +30,12 @@
and statements wherever subqueries are permitted, and as the source of values
for an INSERT statement.</p> </section>
<refsyn><title>Syntax</title> <codeblock><b>{
- VALUES ( <i><xref href="rrefsqlj87167.dita#rrefsqlj87167"></xref></i> {, <i><xref
-href="rrefsqlj87167.dita#rrefsqlj87167"></xref></i> }* )
- [ , ( <i><xref href="rrefsqlj87167.dita#rrefsqlj87167"></xref></i> {, <i><xref
-href="rrefsqlj87167.dita#rrefsqlj87167"></xref></i> }* ) ]* |
- VALUES <i><xref href="rrefsqlj87167.dita#rrefsqlj87167"></xref></i> [ , <i><xref
-href="rrefsqlj87167.dita#rrefsqlj87167"></xref></i> ]* |
+ VALUES ( <i><xref href="rrefsqlj87167.dita#rrefsqlj87167">Value</xref></i> {, <i><xref
+href="rrefsqlj87167.dita#rrefsqlj87167">Value</xref></i> }* )
+ [ , ( <i><xref href="rrefsqlj87167.dita#rrefsqlj87167">Value</xref></i> {, <i><xref
+href="rrefsqlj87167.dita#rrefsqlj87167">Value</xref></i> }* ) ]* |
+ VALUES <i><xref href="rrefsqlj87167.dita#rrefsqlj87167">Value</xref></i> [ , <i><xref
+href="rrefsqlj87167.dita#rrefsqlj87167">Value</xref></i> ]* |
}</b></codeblock> <p>The first form constructs multi-column rows. The second
form constructs single-column rows, each expression being the value of the
column of the row.</p> <p>The DEFAULT keyword is allowed only if the VALUES
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj12362.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj12362.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj12362.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj12362.dita Tue Jun 28 15:46:15 2005
@@ -23,7 +23,7 @@
<keywords><indexterm>NUMERIC data type</indexterm></keywords>
</metadata></prolog>
<refbody>
-<section> <p>NUMERIC is a synonym for <xref href="rrefsqlj15260.dita#rrefsqlj15260"></xref> and
+<section> <p>NUMERIC is a synonym for <xref href="rrefsqlj15260.dita#rrefsqlj15260">DECIMAL</xref> and
behaves the same way. See <xref href="rrefsqlj15260.dita#rrefsqlj15260"></xref>.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>NUMERIC [(<i>precision</i> [, <i>scale</i> ])]</b></codeblock> </refsyn>
<section><title>Corresponding compile-time Java type</title> <p><i>java.math.BigDecimal</i></p> </section>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj13083.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj13083.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj13083.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj13083.dita Tue Jun 28 15:46:15 2005
@@ -30,7 +30,7 @@
DISTINCT and ALL qualifiers eliminate or retain duplicates. ALL is assumed
if neither ALL nor DISTINCT is specified. For example, if a column contains
the values 1, 1, 1, 1, and 2, SUM(col) returns a greater value than SUM(DISTINCT
-col).</p> <p>Only one DISTINCT aggregate expression per <i><xref href="rrefselectexpression.dita#rrefselectexpression"></xref></i> is
+col).</p> <p>Only one DISTINCT aggregate expression per <i><xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpression</xref></i> is
allowed. For example, the following query is not allowed: <codeblock><b>SELECT AVG (DISTINCT flying_time), SUM (DISTINCT miles)
FROM Flights</b></codeblock></p> <p>The <i>Expression</i> can contain multiple
column references or expressions, but it cannot contain another aggregate
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj13590.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj13590.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj13590.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj13590.dita Tue Jun 28 15:46:15 2005
@@ -24,8 +24,8 @@
</keywords>
</metadata></prolog>
<refbody>
-<section> <p>A CONSTRAINT clause is an optional part of a <xref href="rrefsqlj24513.dita#rrefsqlj24513"></xref> or <xref
-href="rrefsqlj81859.dita#rrefsqlj81859"></xref>. A constraint is a rule to which data
+<section> <p>A CONSTRAINT clause is an optional part of a <xref href="rrefsqlj24513.dita#rrefsqlj24513">CREATE TABLE statement</xref> or <xref
+href="rrefsqlj81859.dita#rrefsqlj81859">ALTER TABLE statement</xref>. A constraint is a rule to which data
must conform. Constraint names are optional.</p> <p>A CONSTRAINT can be one
of the following: <ul>
<li><indexterm>Column-level constraints</indexterm><indexterm>Constraints<indexterm>column-level</indexterm></indexterm>a
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj15309.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj15309.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj15309.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj15309.dita Tue Jun 28 15:46:15 2005
@@ -27,7 +27,7 @@
statements. It allows you to perform positioned updates and deletes on updatable
cursors. For more information about updatable cursors, see <xref href="rrefsqlj41360.dita#rrefsqlj41360"/>.</p></section>
<refsyn><title>Syntax</title>
-<codeblock><b>WHERE CURRENT OF <i><xref href="rrefcursorname.dita#rrefcursorname"/></i></b></codeblock>
+<codeblock><b>WHERE CURRENT OF <i><xref href="rrefcursorname.dita#rrefcursorname">cursor-Name</xref></i></b></codeblock>
</refsyn>
<example>
<codeblock expanse="column">Statement s = conn.createStatement();
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj15446.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj15446.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj15446.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj15446.dita Tue Jun 28 15:46:15 2005
@@ -27,10 +27,10 @@
<section> <p>Views are virtual tables formed by a query. A view is a dictionary
object that you can use until you drop it.</p> <p>Views are not updatable.</p> <p>If
a qualified view name is specified, the schema name cannot begin with <i>SYS</i>.</p></section>
-<refsyn><title>Syntax</title> <codeblock><b>CREATE VIEW <i><xref href="rrefviewname.dita#rrefviewname"></xref></i>
- [ ( <i><xref href="rrefsimplecolumnname.dita#rrefsimplecolumnname"></xref></i> [, <i><xref
-href="rrefsimplecolumnname.dita#rrefsimplecolumnname"></xref></i>] * ) ]
-AS <i><xref href="rrefsqlj21571.dita#rrefsqlj21571"></xref></i> </b></codeblock> <p>A
+<refsyn><title>Syntax</title> <codeblock><b>CREATE VIEW <i><xref href="rrefviewname.dita#rrefviewname">view-Name</xref></i>
+ [ ( <i><xref href="rrefsimplecolumnname.dita#rrefsimplecolumnname">Simple-column-Name</xref></i> [, <i><xref
+href="rrefsimplecolumnname.dita#rrefsimplecolumnname">Simple-column-Name</xref></i>] * ) ]
+AS <i><xref href="rrefsqlj21571.dita#rrefsqlj21571">Query</xref></i> </b></codeblock> <p>A
view definition can contain an optional view column list to explicitly name
the columns in the view. If there is no column list, the view inherits the
column names from the underlying query. All columns in a view must be uniquely
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj16095.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj16095.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj16095.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj16095.dita Tue Jun 28 15:46:15 2005
@@ -22,13 +22,13 @@
<refbody>
<example> <codeblock><b>{
NOT NULL |
- [ [CONSTRAINT <i><xref href="rrefconstraintname.dita#rrefconstraintname"></xref></i>]
+ [ [CONSTRAINT <i><xref href="rrefconstraintname.dita#rrefconstraintname">constraint-Name</xref></i>]
{
- CHECK (<i><xref href="rrefsqlj91438.dita#rrefsqlj91438"></xref></i>) |
+ CHECK (<i><xref href="rrefsqlj91438.dita#rrefsqlj91438">searchCondition</xref></i>) |
{
PRIMARY KEY |
UNIQUE |
- <i><xref href="rrefsqlj16357.dita#rrefsqlj16357"></xref></i>
+ <i><xref href="rrefsqlj16357.dita#rrefsqlj16357">REFERENCES clause</xref></i>
}
}
}</b></codeblock></example>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj16357.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj16357.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj16357.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj16357.dita Tue Jun 28 15:46:15 2005
@@ -20,9 +20,9 @@
<reference id="rrefsqlj16357" xml:lang="en-us">
<title>References specification</title>
<refbody>
-<example> <codeblock><b>REFERENCES <i><xref href="rreftablename.dita#rreftablename"></xref></i> [ ( <i><xref
-href="rrefsimplecolumnname.dita#rrefsimplecolumnname"></xref></i> [ , <i><xref
-href="rrefsimplecolumnname.dita#rrefsimplecolumnname"></xref></i> ]* ) ]
+<example> <codeblock><b>REFERENCES <i><xref href="rreftablename.dita#rreftablename">table-Name</xref></i> [ ( <i><xref
+href="rrefsimplecolumnname.dita#rrefsimplecolumnname">Simple-column-Name</xref></i> [ , <i><xref
+href="rrefsimplecolumnname.dita#rrefsimplecolumnname">Simple-column-Name</xref></i> ]* ) ]
[ ON DELETE {NO ACTION | RESTRICT | CASCADE | SET NULL}]
[ ON UPDATE {NO ACTION | RESTRICT }]
|
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj18922.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj18922.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj18922.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj18922.dita Tue Jun 28 15:46:15 2005
@@ -23,7 +23,7 @@
<keywords><indexterm>LEFT OUTER JOIN expression</indexterm></keywords>
</metadata></prolog>
<refbody>
-<section> <p>A LEFT OUTER JOIN is one of the <xref href="rrefsqlj29840.dita#rrefsqlj29840"></xref>s
+<section> <p>A LEFT OUTER JOIN is one of the <xref href="rrefsqlj29840.dita#rrefsqlj29840">JOIN operations</xref>s
that allow you to specify a join clause. It preserves the unmatched rows from
the first (left) table, joining them with a NULL row in the shape of the second
(right) table.</p></section>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj19433.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj19433.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj19433.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj19433.dita Tue Jun 28 15:46:15 2005
@@ -28,10 +28,10 @@
SQL expressions and indicates where they are allowed.</p></section>
<section><p>If not otherwise specified, an expression is permitted anywhere
the word <i>Expression</i> appears in the syntax. This includes: <ul>
-<li><i><xref href="rrefselectexpression.dita#rrefselectexpression"></xref></i></li>
-<li><xref href="rrefsqlj26498.dita#rrefsqlj26498"></xref> (SET portion)</li>
-<li><xref href="rrefsqlj11277.dita#rrefsqlj11277"></xref></li>
-<li><xref href="rrefsqlj33602.dita#rrefsqlj33602"></xref></li>
+<li><i><xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpression</xref></i></li>
+<li><xref href="rrefsqlj26498.dita#rrefsqlj26498">UPDATE statement</xref> (SET portion)</li>
+<li><xref href="rrefsqlj11277.dita#rrefsqlj11277">VALUES Expression</xref></li>
+<li><xref href="rrefsqlj33602.dita#rrefsqlj33602">WHERE clause</xref></li>
</ul></p></section>
<section><p>Of course, many other statements include these elements as building
blocks, and so allow expressions as part of these elements. <table frame="all"
@@ -54,15 +54,15 @@
<row>
<entry colname="1"></entry>
<entry colname="2"> <p><indexterm>Column reference expression</indexterm>Column
-reference</p> <p>Allowed in <i><xref href="rrefselectexpression.dita#rrefselectexpression"></xref>s</i>,
+reference</p> <p>Allowed in <i><xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpression</xref>s</i>,
UPDATE statements, and the WHERE clauses of data manipulation statements.</p></entry>
-<entry colname="3">A <i><xref href="rrefcolumnname.dita#rrefcolumnname"></xref></i> that
+<entry colname="3">A <i><xref href="rrefcolumnname.dita#rrefcolumnname">column-Name</xref></i> that
references the value of the column made visible to the expression containing
the Column reference. <p>You must qualify the <i>column-Name</i> by the
table name or correlation name if it is ambiguous.</p> <p>The qualifier of
-a <i><xref href="rrefcolumnname.dita#rrefcolumnname"></xref></i> must be the
+a <i><xref href="rrefcolumnname.dita#rrefcolumnname">column-Name</xref></i> must be the
correlation name, if a correlation name is given to a table that is in a <xref
-href="rrefsqlj21583.dita#rrefsqlj21583"></xref>. The table name is no longer visible
+href="rrefsqlj21583.dita#rrefsqlj21583">FROM clause</xref>. The table name is no longer visible
as a <i>column-Name</i> qualifier once it has been aliased by a correlation
name.</p></entry>
</row>
@@ -111,7 +111,7 @@
subquery</p> <p>Allowed as a tableExpression in a FROM clause and with EXISTS,
IN, and quantified comparisons.</p></entry>
<entry colname="3">Subquery that returns more than one column and more than
-one row. See <i><xref href="rreftablesubquery.dita#rreftablesubquery"></xref>.</i></entry>
+one row. See <i><xref href="rreftablesubquery.dita#rreftablesubquery">TableSubquery</xref>.</i></entry>
</row>
<row>
<entry colname="1"></entry>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita Tue Jun 28 15:46:15 2005
@@ -26,10 +26,10 @@
<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"></xref></i>
-ON <i><xref href="rreftablename.dita#rreftablename"></xref></i> ( <i><xref
-href="rrefsimplecolumnname.dita#rrefsimplecolumnname"></xref></i> [ ASC | DESC ]
- [ , <i><xref href="rrefsimplecolumnname.dita#rrefsimplecolumnname"></xref></i> [ ASC | DESC ]] * )</b></codeblock><p>The
+href="rrefindexname.dita#rrefindexname">index-Name</xref></i>
+ON <i><xref href="rreftablename.dita#rreftablename">table-Name</xref></i> ( <i><xref
+href="rrefsimplecolumnname.dita#rrefsimplecolumnname">Simple-column-Name</xref></i> [ ASC | DESC ]
+ [ , <i><xref href="rrefsimplecolumnname.dita#rrefsimplecolumnname">Simple-column-Name</xref></i> [ ASC | DESC ]] * )</b></codeblock><p>The
maximum number of columns for an index key in <ph conref="refconrefs.dita#prod/productshortname"></ph> is
16.</p><p>An index name cannot exceed 128 characters.</p><p>A column must not
be named more than once in a single CREATE INDEX statement. Different indexes
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj21571.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj21571.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj21571.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj21571.dita Tue Jun 28 15:46:15 2005
@@ -29,8 +29,8 @@
<i> Query</i> INTERSECT [ ALL | DISTINCT ] <i>Query</i> |
<i> Query</i> EXCEPT [ ALL | DISTINCT ] <i>Query</i> |
<i> Query</i> UNION [ ALL | DISTINCT ] <i>Query</i> |
-<i> <xref href="rrefselectexpression.dita#rrefselectexpression"></xref></i>
-<i> </i><xref href="rrefsqlj11277.dita#rrefsqlj11277"></xref>
+<i> <xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpression</xref></i>
+<i> </i><xref href="rrefsqlj11277.dita#rrefsqlj11277">VALUES Expression</xref>
}</b></codeblock><p>You can arbitrarily put parentheses around queries, or
use the parentheses to control the order of evaluation of the INTERSECT, EXCEPT,
or UNION operations. These operations are evaluated from left to right when
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj21583.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj21583.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj21583.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj21583.dita Tue Jun 28 15:46:15 2005
@@ -23,7 +23,7 @@
<keywords><indexterm>FROM clause</indexterm></keywords>
</metadata></prolog>
<refbody>
-<section> <p>The FROM clause is a mandatory clause in a <i><xref href="rrefselectexpression.dita#rrefselectexpression"></xref>.</i> It
+<section> <p>The FROM clause is a mandatory clause in a <i><xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpression</xref>.</i> It
specifies the tables (<xref href="rreftableexpression.dita#rreftableexpression">TableExpression</xref>)
from which the other clauses of the query can access columns for use in expressions. </p></section>
<refsyn><title>Syntax</title> <codeblock><b>FROM TableExpression [ , TableExpression ] *</b></codeblock> </refsyn>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj23075.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj23075.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj23075.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj23075.dita Tue Jun 28 15:46:15 2005
@@ -27,7 +27,7 @@
constraints. Boolean expressions in check constraints have limitations not
noted here; see <xref href="rrefsqlj13590.dita#rrefsqlj13590"></xref> for more information.
Boolean expressions in a WHERE clause have a highly liberal syntax; see <xref
-href="rrefsqlj33602.dita#rrefsqlj33602"></xref>, for example.</p></section>
+href="rrefsqlj33602.dita#rrefsqlj33602">WHERE clause</xref>, for example.</p></section>
<section><p>A boolean expression can include a boolean operator or operators.
These are listed in <xref href="rrefsqlj23075.dita#rrefsqlj23075/sqlj34517"></xref>. <table expanse="page"
frame="all" id="sqlj34517"><title><ph><indexterm>Boolean operators<indexterm>part
@@ -126,7 +126,7 @@
<entry colname="3"> <codeblock><b>{
<b><i> Expression</i></b> [ NOT ]
IN
- <b><i><xref href="rreftablesubquery.dita#rreftablesubquery"></xref></i></b> |
+ <b><i><xref href="rreftablesubquery.dita#rreftablesubquery">TableSubquery</xref></i></b> |
<b><i> Expression</i></b> [ NOT ]
IN ( <b><i>Expression</i></b>
[, <b><i>Expression</i></b> ]* )
@@ -142,7 +142,7 @@
FROM Flights
WHERE dest_airport = 'SFO'
AND orig_airport = 'GRU')</b></codeblock></entry>
-<entry colname="3"> <codeblock><b>[NOT] EXISTS <b><i><xref href="rreftablesubquery.dita#rreftablesubquery"></xref></i></b></b></codeblock></entry>
+<entry colname="3"> <codeblock><b>[NOT] EXISTS <b><i><xref href="rreftablesubquery.dita#rreftablesubquery">TableSubquery</xref></i></b></b></codeblock></entry>
</row>
<row>
<entry colname="1">Quantified comparison<indexterm>Quantified comparison boolean
@@ -162,7 +162,7 @@
ANY |
SOME
}
- <b><i><xref href="rreftablesubquery.dita#rreftablesubquery"></xref></i></b></b></codeblock></entry>
+ <b><i><xref href="rreftablesubquery.dita#rreftablesubquery">TableSubquery</xref></i></b></b></codeblock></entry>
</row>
</tbody>
</tgroup>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj24513.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj24513.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj24513.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj24513.dita Tue Jun 28 15:46:15 2005
@@ -34,11 +34,11 @@
can specify storage properties such as page size for a table by calling the <codeph>SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY</codeph> system
procedure.</p><p>If a qualified table name is specified, the schema name cannot
begin with <i>SYS</i>.</p></section>
-<refsyn><title>Syntax</title><codeblock><b>CREATE TABLE <i><xref href="rreftablename.dita#rreftablename"></xref></i>
- ( {<i><xref href="rrefsqlj30540.dita#rrefsqlj30540"></xref></i> | <i><xref
-href="rrefsqlj42154.dita#rrefsqlj42154"></xref></i>}
- [ , {<i><xref href="rrefsqlj30540.dita#rrefsqlj30540"></xref></i> | <i><xref
-href="rrefsqlj42154.dita#rrefsqlj42154"></xref></i>} ] * )</b></codeblock> </refsyn>
+<refsyn><title>Syntax</title><codeblock><b>CREATE TABLE <i><xref href="rreftablename.dita#rreftablename">table-Name</xref></i>
+ ( {<i><xref href="rrefsqlj30540.dita#rrefsqlj30540">column-definition</xref></i> | <i><xref
+href="rrefsqlj42154.dita#rrefsqlj42154">Table-level constraint</xref></i>}
+ [ , {<i><xref href="rrefsqlj30540.dita#rrefsqlj30540">column-definition</xref></i> | <i><xref
+href="rrefsqlj42154.dita#rrefsqlj42154">Table-level constraint</xref></i>} ] * )</b></codeblock> </refsyn>
<example><title>Example</title><codeblock><b>CREATE TABLE HOTELAVAILABILITY
(HOTEL_ID INT NOT NULL, BOOKING_DATE DATE NOT NULL,
ROOMS_TAKEN INT DEFAULT 0, PRIMARY KEY (HOTEL_ID, BOOKING_DATE));
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj25228.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj25228.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj25228.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj25228.dita Tue Jun 28 15:46:15 2005
@@ -25,7 +25,7 @@
<refbody>
<section> <p>SESSION_USER returns the authorization identifier or name of
the current user. If there is no current user, it returns <i>APP.</i></p> <p><xref
-href="rrefsqlj42476.dita#rrefsqlj42476"></xref>, <xref href="rrefsqlj42324.dita#rrefsqlj42324"></xref>,
+href="rrefsqlj42476.dita#rrefsqlj42476">USER</xref>, <xref href="rrefsqlj42324.dita#rrefsqlj42324">CURRENT_USER</xref>,
and SESSION_USER are synonyms.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>SESSION_USER</b></codeblock> </refsyn>
<example> <codeblock><b>VALUES SESSION_USER</b></codeblock> </example>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj26498.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj26498.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj26498.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj26498.dita Tue Jun 28 15:46:15 2005
@@ -28,23 +28,23 @@
row, or if the current row no longer satisfies the cursor's query, an exception
is raised.</p></section>
<refsyn><title>Syntax</title> <codeblock><b>{
- UPDATE <i><xref href="rreftablename.dita#rreftablename"></xref></i>
- SET <i><xref href="rrefcolumnname.dita#rrefcolumnname"></xref></i> = <i><xref
-href="rrefsqlj76354.dita#rrefsqlj76354"></xref></i>
- [ , <i><xref href="rrefcolumnname.dita#rrefcolumnname"></xref></i> = <i><xref
-href="rrefsqlj76354.dita#rrefsqlj76354"></xref></i>} ]*
- [<i><xref href="rrefsqlj33602.dita#rrefsqlj33602"></xref></i>] |
- UPDATE <i><xref href="rreftablename.dita#rreftablename"></xref></i>
- SET <i><xref href="rrefcolumnname.dita#rrefcolumnname"></xref></i> = <i><xref
-href="rrefsqlj76354.dita#rrefsqlj76354"></xref></i>
- [ , <i><xref href="rrefcolumnname.dita#rrefcolumnname"></xref></i> = <i><xref
-href="rrefsqlj76354.dita#rrefsqlj76354"></xref></i> ]*
+ UPDATE <i><xref href="rreftablename.dita#rreftablename">table-Name</xref></i>
+ SET <i><xref href="rrefcolumnname.dita#rrefcolumnname">column-Name</xref></i> = <i><xref
+href="rrefsqlj76354.dita#rrefsqlj76354">Value</xref></i>
+ [ , <i><xref href="rrefcolumnname.dita#rrefcolumnname">column-Name</xref></i> = <i><xref
+href="rrefsqlj76354.dita#rrefsqlj76354">Value</xref></i>} ]*
+ [<i><xref href="rrefsqlj33602.dita#rrefsqlj33602">WHERE clause</xref></i>] |
+ UPDATE <i><xref href="rreftablename.dita#rreftablename">table-Name</xref></i>
+ SET <i><xref href="rrefcolumnname.dita#rrefcolumnname">column-Name</xref></i> = <i><xref
+href="rrefsqlj76354.dita#rrefsqlj76354">Value</xref></i>
+ [ , <i><xref href="rrefcolumnname.dita#rrefcolumnname">column-Name</xref></i> = <i><xref
+href="rrefsqlj76354.dita#rrefsqlj76354">Value</xref></i> ]*
<i><xref href="rrefsqlj15309.dita#rrefsqlj15309">WHERE CURRENT OF</xref></i>
}</b></codeblock> <p>The first syntactical form is called a searched update.
The second syntactical form is called a positioned update.</p> <p>For searched
updates, you update all rows of the table for which the WHERE clause evaluates
to TRUE.</p> <p>For positioned updates, you can update only columns that were
-included in the <xref href="rrefsqlj31783.dita#rrefsqlj31783"></xref> of the SELECT
+included in the <xref href="rrefsqlj31783.dita#rrefsqlj31783">FOR UPDATE clause</xref> of the SELECT
statement that created the cursor. If the SELECT statement did not include
a FOR UPDATE clause, the cursor is read-only and cannot be used to update.</p> <p>Specifying
DEFAULT for the update value sets the value of the column to the default defined
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj27781.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj27781.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj27781.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj27781.dita Tue Jun 28 15:46:15 2005
@@ -30,7 +30,7 @@
<refsyn><title>Syntax</title> <codeblock><b>MAX ( [ DISTINCT | ALL ] <i>Expression</i> )</b></codeblock> <p>The
DISTINCT qualifier eliminates duplicates. The ALL qualifier retains duplicates.
These qualifiers have no effect in a MAX expression. Only one DISTINCT aggregate
-expression per <i><xref href="rrefselectexpression.dita#rrefselectexpression"></xref></i> is
+expression per <i><xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpression</xref></i> is
allowed. For example, the following query is not allowed: <codeblock><b>SELECT COUNT (DISTINCT flying_time), MAX (DISTINCT miles)
FROM Flights</b></codeblock></p> <p>The <i>Expression</i> can contain multiple
column references or expressions, but it cannot contain another aggregate
@@ -38,7 +38,7 @@
methods that evaluate to built-in data types. (For example, a method that
returns a <i>java.lang.Integer</i> or <i>int</i> evaluates to an INTEGER.)
If an expression evaluates to NULL, the aggregate skips that value.</p> <p>For
-CHAR, VARCHAR, and <xref href="rrefsqlj15147.dita#rrefsqlj15147"></xref>,
+CHAR, VARCHAR, and <xref href="rrefsqlj15147.dita#rrefsqlj15147">LONG VARCHAR</xref>,
the number of blank spaces at the end of the value can affect how MAX is evaluated.
For example, if the values 'z' and 'z ' are both stored in a column, you cannot
control which one will be returned as the maximum, because a blank space has
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj28468.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj28468.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj28468.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj28468.dita Tue Jun 28 15:46:15 2005
@@ -60,7 +60,7 @@
<li>SQL-92-style identifiers are case-insensitive (see <i><xref href="crefsqlj34834.dita#crefsqlj34834"></xref></i>),
unless they are delimited.</li>
<li>Java-style identifiers are always case-sensitive.</li>
-<li>* is a wildcard within a <i><xref href="rrefselectexpression.dita#rrefselectexpression"></xref>.</i> See <xref
+<li>* is a wildcard within a <i><xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpression</xref>.</i> See <xref
href="rrefselectexpression.dita#rrefselectexpression/sqlj38441"></xref>. It
can also be the multiplication operator. In all other cases, it is a syntactical
metasymbol that flags items you can repeat 0 or more times.</li>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj29026.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj29026.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj29026.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj29026.dita Tue Jun 28 15:46:15 2005
@@ -1,5 +1,4 @@
<?xml version="1.0" encoding="utf-8"?>
-<!--Arbortext, Inc., 1988-2004, v.4002-->
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj29840.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj29840.dita?rev=202296&r1=202295&r2=202296&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj29840.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj29840.dita Tue Jun 28 15:46:15 2005
@@ -25,7 +25,7 @@
</metadata></prolog>
<refbody>
<section> <p>The JOIN operations, which are among the possible <i><xref href="rreftableexpression.dita#rreftableexpression">TableExpression</xref
->s</i> in a <xref href="rrefsqlj21583.dita#rrefsqlj21583"></xref>, perform
+>s</i> in a <xref href="rrefsqlj21583.dita#rrefsqlj21583">FROM clause</xref>, perform
joins between two tables. (You can also perform a join between two tables
using an explicit equality test in a WHERE clause, such as "WHERE t1.col1
= t2.col2".)</p></section>
@@ -40,7 +40,7 @@
two tables with an explicit join clause, preserving unmatched rows from the
second table. See <xref href="rrefsqlj57522.dita#rrefsqlj57522"></xref>.</p></li>
</ul></p> <p>In all cases, you can specify additional restrictions on one
-or both of the tables being joined in outer join clauses or in the <xref href="rrefsqlj33602.dita#rrefsqlj33602"></xref>.</p> </refsyn>
+or both of the tables being joined in outer join clauses or in the <xref href="rrefsqlj33602.dita#rrefsqlj33602">WHERE clause</xref>.</p> </refsyn>
<section><title>JOIN expressions and query optimization</title> <p>For
information on which types of joins are optimized, see <cite><ph conref="refconrefs.dita#pub/cittuning"></ph></cite>.</p> </section>
</refbody>