db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From scotsmat...@apache.org
Subject svn commit: r521089 - /db/derby/docs/trunk/src/ref/rrefsql9241891.dita
Date Thu, 22 Mar 2007 02:36:49 GMT
Author: scotsmatrix
Date: Wed Mar 21 19:36:48 2007
New Revision: 521089

URL: http://svn.apache.org/viewvc?view=rev&rev=521089
Log:
DERBY-1928: Updated the tables to show support for grant and revoke, and for alter table drop
column. Fixed the organization and formats of the table and text. Patch was contributed by
me.

Modified:
    db/derby/docs/trunk/src/ref/rrefsql9241891.dita

Modified: db/derby/docs/trunk/src/ref/rrefsql9241891.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsql9241891.dita?view=diff&rev=521089&r1=521088&r2=521089
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsql9241891.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsql9241891.dita Wed Mar 21 19:36:48 2007
@@ -1,4 +1,5 @@
 <?xml version="1.0" encoding="utf-8"?>
+<!--Arbortext, Inc., 1988-2006, v.4002-->
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
  "../dtd/reference.dtd">
 <!-- 
@@ -30,7 +31,10 @@
 FIPS 127-2</p></li>
 <li>SQL92I   <p>Intermediate</p></li>
 <li>SQL92F   <p>Full</p></li>
-</ul>  <table><title>Support for SQL-92 Features: Basic types</title>
+</ul>  </p></section>
+<section><title>Basic data types</title><p>The following table shows
Derby
+support for the SQL-92 basic data types.<table pgwide="0"><title>Support for
+SQL-92 Features: Basic data types</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -44,46 +48,48 @@
 <row>
 <entry colname="col1">SMALLINT</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">INTEGER</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">DECIMAL(p,s)</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">NUMERIC(p,s)</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">REAL</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">FLOAT(p)</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">DOUBLE PRECISION</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">CHAR(n)</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Basic math operations</title>
+</table></p></section>
+<section><title>Basic math operations</title><table><title>Support
for SQL-92
+Features: Basic math operations</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -97,11 +103,13 @@
 <row>
 <entry colname="col1">+, *, -, /, unary +, unary -</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Basic comparisons</title>
+</table></section>
+<section><title>Basic comparisons</title><table><title>Support
for SQL-92
+Features: Basic comparisons</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -115,11 +123,13 @@
 <row>
 <entry colname="col1">&lt;, &gt;, &lt;= ,&gt;=, &lt;&gt;, =</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Basic predicates</title>
+</table></section>
+<section><title>Basic predicates</title><table><title>Support
for SQL-92 Features:
+Basic predicates</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -133,11 +143,13 @@
 <row>
 <entry colname="col1">BETWEEN, LIKE, NULL</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Quantified predicates</title>
+</table></section>
+<section><title>Quantified predicates</title><table><title>Support
for SQL-92
+Features: Quantified predicates</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -151,11 +163,13 @@
 <row>
 <entry colname="col1">IN, ALL/SOME, EXISTS</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: schema definition</title>
+</table></section>
+<section><title>Schema definition</title><table><title>Support
for SQL-92
+Features: schema definition</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -167,23 +181,25 @@
 </thead>
 <tbody>
 <row>
-<entry colname="col1">tables</entry>
+<entry colname="col1">Tables</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
-<entry colname="col1">views</entry>
+<entry colname="col1">Views</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
-<entry colname="col1">privileges</entry>
+<entry colname="col1">Privileges</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: column attributes</title>
+</table></section>
+<section><title>Column attributes</title><table><title>Support
for SQL-92
+Features: column attributes</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -195,18 +211,20 @@
 </thead>
 <tbody>
 <row>
-<entry colname="col1">default values</entry>
+<entry colname="col1">Default values</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
-<entry colname="col1">nullability</entry>
+<entry colname="col1">Nullability</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: constraints (non-deferrable)</title>
+</table></section>
+<section><title>Constraints (non-deferrable)</title><table><title>Support
+for SQL-92 Features: constraints (non-deferrable)</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -220,31 +238,33 @@
 <row>
 <entry colname="col1">NOT NULL</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes (not stored in SYSCONSTRAINTS)</entry>
+<entry colname="col3">Yes (not stored in SYSCONSTRAINTS)</entry>
 </row>
 <row>
 <entry colname="col1">UNIQUE/PRIMARY KEY</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">FOREIGN KEY</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">CHECK</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">View WITH CHECK OPTION</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">no, since views are not updatable</entry>
+<entry colname="col3">No, views cannot be updated</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Cursors</title>
+</table></section>
+<section><title>Cursors</title><table><title>Support for SQL-92
Features:
+Cursors</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -258,16 +278,18 @@
 <row>
 <entry colname="col1">DECLARE, OPEN, FETCH, CLOSE</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">done through JDBC</entry>
+<entry colname="col3">Yes, by using JDBC method calls</entry>
 </row>
 <row>
 <entry colname="col1">UPDATE, DELETE CURRENT</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Dynamic SQL 1</title>
+</table></section>
+<section><title>Dynamic SQL 1</title><table><title>Support
for SQL-92 Features:
+Dynamic SQL 1</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -281,27 +303,29 @@
 <row>
 <entry colname="col1">ALLOCATE / DEALLOCATE / GET / SET DESCRIPTOR</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">done through JDBC</entry>
+<entry colname="col3">Yes, by using JDBC method calls</entry>
 </row>
 <row>
 <entry colname="col1">PREPARE / EXECUTE / EXECUTE IMMEDIATE</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">done through JDBC</entry>
+<entry colname="col3">Yes, by using JDBC method calls</entry>
 </row>
 <row>
 <entry colname="col1">DECLARE, OPEN, FETCH, CLOSE, UPDATE, DELETE dynamic
 cursor</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">done through JDBC</entry>
+<entry colname="col3">Yes, by using JDBC method calls</entry>
 </row>
 <row>
 <entry colname="col1">DESCRIBE output</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">done through JDBC</entry>
+<entry colname="col3">Yes, by using JDBC method calls</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Basic information schema</title>
+</table></section>
+<section><title>Basic information schema</title><table><title>Support
for
+SQL-92 Features: Basic information schema</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -329,7 +353,9 @@
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Basic schema manipulation</title>
+</table></section>
+<section><title>Basic schema manipulation</title><table><title>Support
for
+SQL-92 Features: Basic schema manipulation</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -343,31 +369,33 @@
 <row>
 <entry colname="col1">CREATE / DROP TABLE</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">CREATE / DROP VIEW</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">GRANT / REVOKE</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">ALTER TABLE ADD COLUMN</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">ALTER TABLE DROP COLUMN</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Joined table</title>
+</table></section>
+<section><title>Joined table</title><table><title>Support for
SQL-92 Features:
+Joined table</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -381,31 +409,33 @@
 <row>
 <entry colname="col1">INNER JOIN</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">natural join</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">LEFT, RIGHT OUTER JOIN</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">join condition</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">named columns join</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Joined table</title>
+</table></section>
+<section><title>Date and time data types</title><table><title>Support
for
+SQL-92 Features: Date and time data types</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -419,31 +449,33 @@
 <row>
 <entry colname="col1">simple DATE, TIME, TIMESTAMP, INTERVAL</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes, not INTERVAL</entry>
+<entry colname="col3">Yes, not INTERVAL</entry>
 </row>
 <row>
 <entry colname="col1">datetime constants</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">datetime math</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">can do with Java methods</entry>
+<entry colname="col3">Yes, with Java methods</entry>
 </row>
 <row>
 <entry colname="col1">datetime comparisons</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">predicates: OVERLAPS</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">can do with Java methods</entry>
+<entry colname="col3">Yes, with Java methods</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: VARCHAR</title>
+</table></section>
+<section><title>VARCHAR data type</title><table><title>Support
for SQL-92
+Features: VARCHAR</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -457,16 +489,18 @@
 <row>
 <entry colname="col1">LENGTH</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">concatenation (||)</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Transaction isolation</title>
+</table></section>
+<section><title>Transaction isolation</title><table><title>Support
for SQL-92
+Features: Transaction isolation</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -480,16 +514,18 @@
 <row>
 <entry colname="col1">READ WRITE / READ ONLY</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">through JDBC, database properties, and storage media.</entry>
+<entry colname="col3">By using JDBC, database properties, and storage media</entry>
 </row>
 <row>
 <entry colname="col1">RU, RC, RR, SER</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Multiple schemas per
user</title>
+</table></section>
+<section><title>Multiple schemas per user</title><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>
@@ -507,7 +543,9 @@
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Privilege tables</title>
+</table></section>
+<section><title>Privilege tables</title><table><title>Support
for SQL-92 Features:
+Privilege tables</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -521,21 +559,23 @@
 <row>
 <entry colname="col1">TABLE_PRIVILEGES</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">COLUMNS_PRIVILEGES</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">USAGE_PRIVILEGES</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Table operations</title>
+</table></section>
+<section><title>Table operations</title><table><title>Support
for SQL-92 Features:
+Table operations</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -549,26 +589,28 @@
 <row>
 <entry colname="col1">UNION relaxations</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">EXCEPT</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">INTERSECT</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">CORRESPONDING</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Schema definition statement</title>
+</table></section>
+<section><title>Schema definition statement</title><table><title>Support
for
+SQL-92 Features: Schema definition statement</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -582,11 +624,13 @@
 <row>
 <entry colname="col1">CREATE SCHEMA</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">yes, partially</entry>
+<entry colname="col3">Partial support</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: User authorization</title>
+</table></section>
+<section><title>User authorization</title><table><title>Support
for SQL-92
+Features: User authorization</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -600,26 +644,28 @@
 <row>
 <entry colname="col1">SET SESSION AUTHORIZATION</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">use set schema</entry>
+<entry colname="col3">Use SET SCHEMA</entry>
 </row>
 <row>
 <entry colname="col1">CURRENT_USER</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">SESSION_USER</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">SYSTEM_USER</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Constraint tables</title>
+</table></section>
+<section><title>Constraint tables</title><table><title>Support
for SQL-92
+Features: Constraint tables</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -647,7 +693,9 @@
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Documentation schema</title>
+</table></section>
+<section><title>Documentation schema</title><table><title>Support
for SQL-92
+Features: Documentation schema</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -661,16 +709,18 @@
 <row>
 <entry colname="col1">SQL_FEATURES</entry>
 <entry colname="col2">SQL92I/FIPS 127-2</entry>
-<entry colname="col3">use JDBC <i>DatabaseMetaData</i></entry>
+<entry colname="col3">Use JDBC <i>DatabaseMetaData</i></entry>
 </row>
 <row>
 <entry colname="col1">SQL_SIZING</entry>
 <entry colname="col2">SQL92I/FIPS 127-2</entry>
-<entry colname="col3">use JDBC <i>DatabaseMetaData</i></entry>
+<entry colname="col3">Use JDBC <i>DatabaseMetaData</i></entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Full DATETIME</title>
+</table></section>
+<section><title>Full DATETIME</title><table><title>Support
for SQL-92 Features:
+Full DATETIME</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -684,11 +734,13 @@
 <row>
 <entry colname="col1">precision for TIME and TIMESTAMP</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Full character functions</title>
+</table></section>
+<section><title>Full character functions</title><table><title>Support
for
+SQL-92 Features: Full character functions</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -702,16 +754,18 @@
 <row>
 <entry colname="col1">POSITION expression</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">use Java methods or LOCATE</entry>
+<entry colname="col3">Use Java methods or LOCATE</entry>
 </row>
 <row>
 <entry colname="col1">UPPER/LOWER functions</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 </tbody>
 </tgroup>
-</table><table><title>Support for SQL-92 Features: Miscellaneous</title>
+</table></section>
+<section><title>Miscellaneous features</title><table><title>Support
for SQL-92
+Features: Miscellaneous</title>
 <tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
 colname="col3"/>
 <thead>
@@ -725,162 +779,162 @@
 <row>
 <entry colname="col1">Delimited identifiers</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Correlated subqueries</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Insert, Update, Delete statements</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Joins</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Where qualifications</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Group by</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Having</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Aggregate functions</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Order by</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Select expressions</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Select *</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">SQLCODE</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">no, deprecated in SQL-92</entry>
+<entry colname="col3">No, deprecated in SQL-92</entry>
 </row>
 <row>
 <entry colname="col1">SQLSTATE</entry>
 <entry colname="col2">SQL92E</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">UNION, INTERSECT, and EXCEPT in views</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Implicit numeric casting</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Implicit character casting</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Get diagnostics</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">use JDBC <i>SQLExceptions</i></entry>
+<entry colname="col3">Use JDBC <i>SQLExceptions</i></entry>
 </row>
 <row>
 <entry colname="col1">Grouped operations</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Qualified * in select list</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Lowercase identifiers</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">nullable PRIMARY KEYs</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Multiple module support</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">no (not required and not part of JDBC)</entry>
+<entry colname="col3">No (not required and not part of JDBC)</entry>
 </row>
 <row>
 <entry colname="col1">Referential delete actions</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">CASCADE, SET NULL, RESTRICT, and NO ACTION.</entry>
+<entry colname="col3">CASCADE, SET NULL, RESTRICT, and NO ACTION</entry>
 </row>
 <row>
 <entry colname="col1">CAST functions</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">INSERT expressions</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Explicit defaults</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Keyword relaxations</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Domain definition</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">CASE expression</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">partial support</entry>
+<entry colname="col3">Partial support</entry>
 </row>
 <row>
 <entry colname="col1">Compound character string constants</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">use concatenation</entry>
+<entry colname="col3">Use concatenation</entry>
 </row>
 <row>
 <entry colname="col1">LIKE enhancements</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">UNIQUE predicate</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Usage tables</entry>
@@ -890,154 +944,154 @@
 <row>
 <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
+<entry colname="col3">Use JDBC <i>DatabaseMetaData</i> and <ph conref="refconrefs.dita#prod/productshortname"></ph>
system
 tables</entry>
 </row>
 <row>
 <entry colname="col1">Subprogram support</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">not relevant to JDBC, which is much richer</entry>
+<entry colname="col3">Not relevant to JDBC, which is much richer</entry>
 </row>
 <row>
 <entry colname="col1">Intermediate SQL Flagging</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Schema manipulation</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Long identifiers</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Full outer join</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Time zone specification</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Scrolled cursors</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">partial (scrollable insensitive result sets through JDBC
-2.0)</entry>
+<entry colname="col3">Partial support (scrollable insensitive result sets
+through JDBC 2.0)</entry>
 </row>
 <row>
 <entry colname="col1">Intermediate set function support</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">partial</entry>
+<entry colname="col3">Partial support</entry>
 </row>
 <row>
 <entry colname="col1">Character set definition</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">supports Java locales</entry>
+<entry colname="col3">Support for Java locales</entry>
 </row>
 <row>
 <entry colname="col1">Named character sets</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">supports Java locales</entry>
+<entry colname="col3">Support for Java locales</entry>
 </row>
 <row>
 <entry colname="col1">Scalar subquery values</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Expanded null predicate</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Constraint management</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">yes (ADD/DROP CONSTRAINT)</entry>
+<entry colname="col3">Yes (ADD/DROP CONSTRAINT)</entry>
 </row>
 <row>
 <entry colname="col1">FOR BIT DATA types</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">yes </entry>
+<entry colname="col3">Yes </entry>
 </row>
 <row>
 <entry colname="col1">Assertion constraints</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Temporary tables</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">IBM specific syntax only</entry>
+<entry colname="col3">Partial support, with DECLARE GLOBAL TEMPORARY TABLE </entry>
 </row>
 <row>
 <entry colname="col1">Full dynamic SQL</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Full value expressions</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Truth value tests</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Derived tables in FROM</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Trailing underscore</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Indicator data types</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">not relevant to JDBC</entry>
+<entry colname="col3">Not relevant to JDBC</entry>
 </row>
 <row>
 <entry colname="col1">Referential name order</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Full SQL Flagging</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Row and table constructors</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Catalog name qualifiers</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Simple tables</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Subqueries in CHECK</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no, but can do with Java methods</entry>
+<entry colname="col3">No, but can with Java methods</entry>
 </row>
 <row>
 <entry colname="col1">Union join</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Collation and translation</entry>
@@ -1052,37 +1106,37 @@
 <row>
 <entry colname="col1">ALTER domain</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">nNo</entry>
 </row>
 <row>
 <entry colname="col1">INSERT column privileges</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Referential MATCH types</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">View CHECK enhancements</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no, views not updateable</entry>
+<entry colname="col3">No, views cannot be updated</entry>
 </row>
 <row>
 <entry colname="col1">Session management</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">use JDBC</entry>
+<entry colname="col3">Use JDBC</entry>
 </row>
 <row>
 <entry colname="col1">Connection management</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">use JDBC</entry>
+<entry colname="col3">Use JDBC</entry>
 </row>
 <row>
 <entry colname="col1">Self-referencing operations</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Insensitive cursors</entry>
@@ -1092,25 +1146,25 @@
 <row>
 <entry colname="col1">Full set function</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">partially</entry>
+<entry colname="col3">Partial support</entry>
 </row>
 <row>
 <entry colname="col1">Catalog flagging</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Local table references</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">Full cursor update</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">No</entry>
 </row>
 </tbody>
 </tgroup>
-</table></p></section>
+</table></section>
 </refbody>
 </reference>



Mime
View raw message