You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by ch...@apache.org on 2011/04/29 19:55:30 UTC
svn commit: r1097901 [2/3] - /db/derby/docs/branches/10.8/src/ref/
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabs33921.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabs33921.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabs33921.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabs33921.dita Fri Apr 29 17:55:29 2011
@@ -20,22 +20,34 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsistabs33921" xml:lang="en-us">
<title>SYSKEYS system table</title>
+<shortdesc>The SYSKEYS table describes the specific information for primary key
+and unique constraints within the current database.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system tables<indexterm>SYSKEYS</indexterm></indexterm>
+<indexterm>primary keys<indexterm>SYSKEYS system table</indexterm></indexterm>
+<indexterm>SYSKEYS system table</indexterm></keywords>
+</metadata></prolog>
<refbody>
-<section><p>Describes the specific information for primary key and unique
-constraints within the current database. <ph conref="../conrefs.dita#prod/productshortname"></ph> generates
+<section>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph> generates
an index on the table to back up each such constraint. The index name is the
-same as <i>SYSKEYS.CONGLOMERATEID</i>. <table pgwide="1" frame="all">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="29*"/>
-<colspec colname="2" colnum="2" colwidth="18*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="12*"/><colspec colname="5"
-colnum="5" colwidth="31*"/>
+same as SYSKEYS.CONGLOMERATEID.</p>
+<p>The following table shows the contents of the SYSKEYS system table.</p>
+<table>
+<title>SYSKEYS system table</title>
+<tgroup cols="5" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="29*"/>
+<colspec colname="2" colnum="2" colwidth="24*"/>
+<colspec colname="3" colnum="3" colwidth="11*"/>
+<colspec colname="4" colnum="4" colwidth="12*"/>
+<colspec colname="5" colnum="5" colwidth="24*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Column Name</entry>
-<entry align="left" colname="2" valign="bottom">Type</entry>
-<entry align="left" colname="3" valign="bottom">Length</entry>
-<entry align="left" colname="4" valign="bottom">Nullable</entry>
-<entry align="left" colname="5" valign="bottom">Contents</entry>
+<row valign="bottom">
+<entry colname="1">Column Name</entry>
+<entry colname="2">Type</entry>
+<entry colname="3">Length</entry>
+<entry colname="4">Nullable</entry>
+<entry colname="5">Contents</entry>
</row>
</thead>
<tbody>
@@ -44,18 +56,18 @@ colnum="5" colwidth="31*"/>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">unique identifier for constraint</entry>
+<entry colname="5">Unique identifier for constraint</entry>
</row>
<row>
<entry colname="1">CONGLOMERATEID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">unique identifier for backing index</entry>
+<entry colname="5">Unique identifier for backing index</entry>
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
</refbody>
</reference>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabs39391.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabs39391.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabs39391.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabs39391.dita Fri Apr 29 17:55:29 2011
@@ -29,18 +29,23 @@ is either a table or an index.</shortdes
</metadata></prolog>
<refbody>
<section>
-<table pgwide="1" frame="all">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="31*"/>
-<colspec colname="2" colnum="2" colwidth="22*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="12*"/><colspec colname="5"
-colnum="5" colwidth="23*"/>
+<p>The following table shows the contents of the SYSCONGLOMERATES system
+table.</p>
+<table>
+<title>SYSCONGLOMERATES system table</title>
+<tgroup cols="5" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="29*"/>
+<colspec colname="2" colnum="2" colwidth="24*"/>
+<colspec colname="3" colnum="3" colwidth="11*"/>
+<colspec colname="4" colnum="4" colwidth="12*"/>
+<colspec colname="5" colnum="5" colwidth="24*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Column Name</entry>
-<entry align="left" colname="2" valign="bottom">Type</entry>
-<entry align="left" colname="3" valign="bottom">Length</entry>
-<entry align="left" colname="4" valign="bottom">Nullable</entry>
-<entry align="left" colname="5" valign="bottom">Contents</entry>
+<row valign="bottom">
+<entry colname="1">Column Name</entry>
+<entry colname="2">Type</entry>
+<entry colname="3">Length</entry>
+<entry colname="4">Nullable</entry>
+<entry colname="5">Contents</entry>
</row>
</thead>
<tbody>
@@ -49,21 +54,21 @@ colnum="5" colwidth="23*"/>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">Schema id for the conglomerate</entry>
+<entry colname="5">Schema ID for the conglomerate</entry>
</row>
<row>
<entry colname="1">TABLEID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">Identifier for table (join with <i>SYSTABLES.TABLEID</i>)</entry>
+<entry colname="5">Identifier for table (join with SYSTABLES.TABLEID)</entry>
</row>
<row>
<entry colname="1">CONGLOMERATENUMBER</entry>
<entry colname="2">BIGINT</entry>
<entry colname="3">19</entry>
<entry colname="4">false</entry>
-<entry colname="5">Conglomerate id for the conglomerate (heap or index)</entry>
+<entry colname="5">Conglomerate ID for the conglomerate (heap or index)</entry>
</row>
<row>
<entry colname="1">CONGLOMERATENAME</entry>
@@ -82,8 +87,9 @@ table ID</entry>
</row>
<row>
<entry colname="1">DESCRIPTOR</entry>
-<entry colname="2"> <i>org.apache.derby.
-catalog.IndexDescriptor</i> <p>This class is not part of the public API.</p></entry>
+<entry colname="2"><i>org.apache.derby.
+catalog.
+IndexDescriptor</i> <p>This class is not part of the public API.</p></entry>
<entry colname="3">2,147,483,647</entry>
<entry colname="4">true</entry>
<entry colname="5">System type describing the index</entry>
@@ -93,7 +99,7 @@ catalog.IndexDescriptor</i> <p>This clas
<entry colname="2">BOOLEAN</entry>
<entry colname="3">1</entry>
<entry colname="4">true</entry>
-<entry colname="5">Whether or not conglomerate is a system-generated index
+<entry colname="5">Whether or not the conglomerate is a system-generated index
enforcing a constraint</entry>
</row>
<row>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabs40972.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabs40972.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabs40972.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabs40972.dita Fri Apr 29 17:55:29 2011
@@ -20,20 +20,31 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsistabs40972" xml:lang="en-us">
<title>SYSFILES system table</title>
+<shortdesc>The SYSFILES table describes jar files stored in the
+database.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system tables<indexterm>SYSFILES</indexterm></indexterm>
+<indexterm>jar files<indexterm>SYSFILES system table</indexterm></indexterm>
+<indexterm>SYSFILES system table</indexterm></keywords>
+</metadata></prolog>
<refbody>
-<section><p>Describes jar files stored in the database. <table pgwide="1"
-frame="all">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="28*"/>
-<colspec colname="2" colnum="2" colwidth="18*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="15*"/><colspec colname="5"
-colnum="5" colwidth="27*"/>
+<section>
+<p>The following table shows the contents of the SYSFILES system table.</p>
+<table>
+<title>SYSFILES system table</title>
+<tgroup cols="5" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="29*"/>
+<colspec colname="2" colnum="2" colwidth="24*"/>
+<colspec colname="3" colnum="3" colwidth="11*"/>
+<colspec colname="4" colnum="4" colwidth="12*"/>
+<colspec colname="5" colnum="5" colwidth="24*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Column Name</entry>
-<entry align="left" colname="2" valign="bottom">Type</entry>
-<entry align="left" colname="3" valign="bottom">Length</entry>
-<entry align="left" colname="4" valign="bottom">Nullability</entry>
-<entry align="left" colname="5" valign="bottom">Contents</entry>
+<row valign="bottom">
+<entry colname="1">Column Name</entry>
+<entry colname="2">Type</entry>
+<entry colname="3">Length</entry>
+<entry colname="4">Nullable</entry>
+<entry colname="5">Contents</entry>
</row>
</thead>
<tbody>
@@ -42,14 +53,15 @@ colnum="5" colwidth="27*"/>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">unique identifier for the jar file</entry>
+<entry colname="5">Unique identifier for the jar file</entry>
</row>
<row>
<entry colname="1">SCHEMAID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">ID of the jar file's schema (join with <i>SYSSCHEMAS. SCHEMAID</i>)</entry>
+<entry colname="5">ID of the jar file's schema (join with
+SYSSCHEMAS.SCHEMAID)</entry>
</row>
<row>
<entry colname="1">FILENAME</entry>
@@ -68,7 +80,8 @@ their generation identifiers are changed
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table>
+</section>
</refbody>
</reference>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabs79888.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabs79888.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabs79888.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabs79888.dita Fri Apr 29 17:55:29 2011
@@ -26,18 +26,23 @@ limitations under the License.
<indexterm>SYSTRIGGERS system table</indexterm></keywords>
</metadata></prolog>
<refbody>
-<section><table pgwide="1" frame="all">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="2784*"/>
-<colspec colname="2" colnum="2" colwidth="2185*"/><colspec colname="3" colnum="3"
-colwidth="814*"/><colspec colname="4" colnum="4" colwidth="1003*"/><colspec
-colname="5" colnum="5" colwidth="2902*"/>
+<section>
+<p>The following table shows the contents of the SYSTRIGGERS system table.</p>
+<table>
+<title>SYSTRIGGERS system table</title>
+<tgroup cols="5" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="29*"/>
+<colspec colname="2" colnum="2" colwidth="24*"/>
+<colspec colname="3" colnum="3" colwidth="11*"/>
+<colspec colname="4" colnum="4" colwidth="12*"/>
+<colspec colname="5" colnum="5" colwidth="24*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Column Name</entry>
-<entry align="left" colname="2" valign="bottom">Type</entry>
-<entry align="left" colname="3" valign="bottom">Length</entry>
-<entry align="left" colname="4" valign="bottom">Nullability</entry>
-<entry align="left" colname="5" valign="bottom">Contents</entry>
+<row valign="bottom">
+<entry colname="1">Column Name</entry>
+<entry colname="2">Type</entry>
+<entry colname="3">Length</entry>
+<entry colname="4">Nullable</entry>
+<entry colname="5">Contents</entry>
</row>
</thead>
<tbody>
@@ -60,7 +65,7 @@ colname="5" colnum="5" colwidth="2902*"/
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">Id of the trigger's schema (join with SYSSCHEMAS.SCHEMAID)</entry>
+<entry colname="5">ID of the trigger's schema (join with SYSSCHEMAS.SCHEMAID)</entry>
</row>
<row>
<entry colname="1">CREATIONTIMESTAMP</entry>
@@ -74,35 +79,36 @@ colname="5" colnum="5" colwidth="2902*"/
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5">'U' for update, 'D' for delete, 'I' for insert</entry>
+<entry colname="5"><i>'U'</i> for update, <i>'D'</i> for delete, <i>'I</i>' for
+insert</entry>
</row>
<row>
<entry colname="1">FIRINGTIME</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5">'B' for before, 'A' for after</entry>
+<entry colname="5"><i>'B'</i> for before, <i>'A'</i> for after</entry>
</row>
<row>
<entry colname="1">TYPE</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5">'R' for row, 'S' for statement</entry>
+<entry colname="5"><i>'R'</i> for row, <i>'S'</i> for statement</entry>
</row>
<row>
<entry colname="1">STATE</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5">'E' for enabled, 'D' for disabled</entry>
+<entry colname="5"><i>'E'</i> for enabled, <i>'D'</i> for disabled</entry>
</row>
<row>
<entry colname="1">TABLEID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">Id of the table on which the trigger is defined</entry>
+<entry colname="5">ID of the table on which the trigger is defined</entry>
</row>
<row>
<entry colname="1">WHENSTMTID</entry>
@@ -116,12 +122,13 @@ colname="5" colnum="5" colwidth="2902*"/
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">true</entry>
-<entry colname="5">Id of the stored prepared statement for the triggered-SQL-statement
+<entry colname="5">ID of the stored prepared statement for the triggered-SQL-statement
(join with SYSSTATEMENTS.STMTID)</entry>
</row>
<row>
<entry colname="1">REFERENCEDCOLUMNS</entry>
-<entry colname="2"><i>org.apache.derby.catalog.
+<entry colname="2"><i>org.apache.derby.
+catalog.
ReferencedColumns</i> <p>This class
is not part of the public API.</p></entry>
<entry colname="3">2,147,483,647</entry>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabslilanguageitemsysstatistics.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabslilanguageitemsysstatistics.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabslilanguageitemsysstatistics.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabslilanguageitemsysstatistics.dita Fri Apr 29 17:55:29 2011
@@ -27,19 +27,23 @@ database.</shortdesc>
<indexterm>SYSSTATISTICS system table</indexterm></keywords>
</metadata></prolog>
<refbody>
-<section><table pgwide="1"
-frame="all">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="26*"/>
-<colspec colname="2" colnum="2" colwidth="15*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
-colnum="5" colwidth="35*"/>
+<section>
+<p>The following table shows the contents of the SYSSTATISTICS system table.</p>
+<table>
+<title>SYSSTATISTICS system table</title>
+<tgroup cols="5" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="29*"/>
+<colspec colname="2" colnum="2" colwidth="24*"/>
+<colspec colname="3" colnum="3" colwidth="11*"/>
+<colspec colname="4" colnum="4" colwidth="12*"/>
+<colspec colname="5" colnum="5" colwidth="24*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Column Name</entry>
-<entry align="left" colname="2" valign="bottom">Type</entry>
-<entry align="left" colname="3" valign="bottom">Length</entry>
-<entry align="left" colname="4" valign="bottom">Nullability</entry>
-<entry align="left" colname="5" valign="bottom">Contents</entry>
+<row valign="bottom">
+<entry colname="1">Column Name</entry>
+<entry colname="2">Type</entry>
+<entry colname="3">Length</entry>
+<entry colname="4">Nullable</entry>
+<entry colname="5">Contents</entry>
</row>
</thead>
<tbody>
@@ -96,9 +100,8 @@ CONGLOMERATEID)</entry>
</row>
<row>
<entry colname="1">STATISTICS</entry>
-<entry colname="2"><i>org.apache.
-derby.catalog.
-Statistics</i> <p>This class is not part of the public API.</p></entry>
+<entry colname="2"><i>org.apache.derby.
+catalog.Statistics</i> <p>This class is not part of the public API.</p></entry>
<entry colname="3">2,147,483,647</entry>
<entry colname="4">true</entry>
<entry colname="5">Statistics information</entry>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabssyscolperms.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabssyscolperms.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabssyscolperms.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabssyscolperms.dita Fri Apr 29 17:55:29 2011
@@ -32,23 +32,28 @@ granted but not revoked.</shortdesc>
<refbody>
<section><p>All of the permissions for one (GRANTEE, TABLEID, TYPE, GRANTOR)
combination are specified in a single row in the SYSCOLPERMS table. The keys
-for the SYSCOLPERMS table are: <ul>
+for the SYSCOLPERMS table are:</p>
+<ul>
<li>Primary key (GRANTEE, TABLEID, TYPE, GRANTOR)</li>
<li>Unique key (COLPERMSID)</li>
<li>Foreign key (TABLEID references SYS.SYSTABLES)</li>
-</ul> </p></section>
-<table frame="all" pgwide="1">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="27*"/>
-<colspec colname="2" colnum="2" colwidth="10*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
-colnum="5" colwidth="38*"/>
+</ul>
+<p>The following table shows the contents of the SYSCOLPERMS system table.</p>
+<table>
+<title>SYSCOLPERMS system table</title>
+<tgroup cols="5" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="29*"/>
+<colspec colname="2" colnum="2" colwidth="24*"/>
+<colspec colname="3" colnum="3" colwidth="11*"/>
+<colspec colname="4" colnum="4" colwidth="12*"/>
+<colspec colname="5" colnum="5" colwidth="24*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Column Name</entry>
-<entry align="left" colname="2" valign="bottom">Type</entry>
-<entry align="left" colname="3" valign="bottom">Length</entry>
-<entry align="left" colname="4" valign="bottom">Nullability</entry>
-<entry align="left" colname="5" valign="bottom">Contents</entry>
+<row valign="bottom">
+<entry colname="1">Column Name</entry>
+<entry colname="2">Type</entry>
+<entry colname="3">Length</entry>
+<entry colname="4">Nullable</entry>
+<entry colname="5">Contents</entry>
</row>
</thead>
<tbody>
@@ -58,15 +63,15 @@ colnum="5" colwidth="38*"/>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
<entry colname="5">Used by the dependency manager to track the dependency
-of a view, trigger, or constraint on the column level permissions.</entry>
+of a view, trigger, or constraint on the column level permissions</entry>
</row>
<row>
<entry colname="1">GRANTEE</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
<entry colname="4">false</entry>
-<entry colname="5">The authorization ID of the user or role to which the privilege
-was granted. </entry>
+<entry colname="5">The authorization ID of the user or role to which the
+privilege was granted</entry>
</row>
<row>
<entry colname="1">GRANTOR</entry>
@@ -74,7 +79,7 @@ was granted. </entry>
<entry colname="3">128</entry>
<entry colname="4">false</entry>
<entry colname="5">The authorization ID of the user who granted the privilege.
-Privileges can be granted only by the object owner.</entry>
+Privileges can be granted only by the object owner</entry>
</row>
<row>
<entry colname="1">TABLEID</entry>
@@ -82,19 +87,21 @@ Privileges can be granted only by the ob
<entry colname="3">36</entry>
<entry colname="4">false</entry>
<entry colname="5">The unique identifier for the table on which the permissions
-have been granted.</entry>
+have been granted</entry>
</row>
<row>
<entry colname="1">TYPE</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5">If the privilege is non-grantable, the valid values are: <lines>'s' for SELECT
-'u' for UPDATE
-'r' for REFERENCES
-</lines>If the privilege is grantable, the valid values are: <lines>'S' for SELECT
-'U' for UPDATE
-'R' for REFERENCES</lines></entry>
+<entry colname="5">If the privilege is non-grantable, the valid values are:
+<lines><i>'s'</i> for SELECT
+<i>'u'</i> for UPDATE
+<i>'r'</i> for REFERENCES
+</lines>If the privilege is grantable, the valid values are:
+<lines><i>'S'</i> for SELECT
+<i>'U'</i> for UPDATE
+<i>'R'</i> for REFERENCES</lines></entry>
</row>
<row>
<entry colname="1">COLUMNS</entry>
@@ -104,10 +111,11 @@ FormatableBitSet</i>
<p>This class is not part of the public API.</p> </entry>
<entry colname="3">2,147,483,647</entry>
<entry colname="4">false</entry>
-<entry colname="5">A list of columns to which the privilege applies. </entry>
+<entry colname="5">A list of columns to which the privilege applies</entry>
</row>
</tbody>
</tgroup>
</table>
+</section>
</refbody>
</reference>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabssysperms.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabssysperms.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabssysperms.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabssysperms.dita Fri Apr 29 17:55:29 2011
@@ -22,7 +22,7 @@ under the License.
-->
<reference id="rrefsistabssysperms" xml:lang="en-us">
<title>SYSPERMS system table</title>
-<shortdesc>The SYSPERMS system table describes the USAGE permissions for
+<shortdesc>The SYSPERMS table describes the USAGE permissions for
sequence generators and user-defined types.</shortdesc>
<prolog><metadata>
<keywords><indexterm>system tables<indexterm>SYSPERMS</indexterm></indexterm>
@@ -32,18 +32,22 @@ sequence generators and user-defined typ
</metadata></prolog>
<refbody>
<section>
-<table frame="all" pgwide="1">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="27*"/>
-<colspec colname="2" colnum="2" colwidth="10*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
-colnum="5" colwidth="38*"/>
+<p>The following table shows the contents of the SYSPERMS system table.</p>
+<table>
+<title>SYSPERMS system table</title>
+<tgroup cols="5" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="29*"/>
+<colspec colname="2" colnum="2" colwidth="24*"/>
+<colspec colname="3" colnum="3" colwidth="11*"/>
+<colspec colname="4" colnum="4" colwidth="12*"/>
+<colspec colname="5" colnum="5" colwidth="24*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Column Name</entry>
-<entry align="left" colname="2" valign="bottom">Type</entry>
-<entry align="left" colname="3" valign="bottom">Length</entry>
-<entry align="left" colname="4" valign="bottom">Nullability</entry>
-<entry align="left" colname="5" valign="bottom">Contents</entry>
+<row valign="bottom">
+<entry colname="1">Column Name</entry>
+<entry colname="2">Type</entry>
+<entry colname="3">Length</entry>
+<entry colname="4">Nullable</entry>
+<entry colname="5">Contents</entry>
</row>
</thead>
<tbody>
@@ -51,22 +55,23 @@ colnum="5" colwidth="38*"/>
<entry colname="1">UUID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
-<entry colname="4">False</entry>
-<entry colname="5">The unique id of the permission. This is the primary key.</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The unique ID of the permission. This is the primary
+key.</entry>
</row>
<row>
<entry colname="1">OBJECTTYPE</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">36</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">The kind of object receiving the permission. The only valid
-values are 'SEQUENCE' and 'USER-DEFINED TYPE'.</entry>
+values are <i>'SEQUENCE'</i> and <i>'USER-DEFINED TYPE'</i>.</entry>
</row>
<row>
<entry colname="1">OBJECTID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">The UUID of the object receiving the permission. For
sequence generators, the only valid values are SEQUENCEIDs in the
SYS.SYSSEQUENCES table. For user-defined types, the only valid values are
@@ -77,14 +82,15 @@ user-defined type.</entry>
<entry colname="1">PERMISSION</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
-<entry colname="4">False</entry>
-<entry colname="5">The type of the permission. The only valid value is 'USAGE'.</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The type of the permission. The only valid value is
+<i>'USAGE'</i>.</entry>
</row>
<row>
<entry colname="1">GRANTOR</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">The authorization ID of the user who granted the privilege.
Privileges can be granted only by the object owner.</entry>
</row>
@@ -92,18 +98,18 @@ Privileges can be granted only by the ob
<entry colname="1">GRANTEE</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">The authorization ID of the user or role to which the
-privilege was granted.</entry>
+privilege was granted</entry>
</row>
<row>
<entry colname="1">ISGRANTABLE</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">If the GRANTEE is the owner of the sequence generator or
-user-defined type, this value is 'Y'. If the GRANTEE is not the owner of the
-sequence generator or user-defined type, this value is 'N'.</entry>
+user-defined type, this value is <i>'Y'</i>. If the GRANTEE is not the owner of
+the sequence generator or user-defined type, this value is <i>'N'</i>.</entry>
</row>
</tbody>
</tgroup>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabssysroles.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabssysroles.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabssysroles.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabssysroles.dita Fri Apr 29 17:55:29 2011
@@ -35,22 +35,27 @@ under the License.
href="rrefcreaterole.dita#rrefcreaterole">CREATE ROLE statement</xref>)</li>
<li>A role grant</li>
</ul>
-<p>The keys for the SYSROLES table are: <ul>
+<p>The keys for the SYSROLES table are:</p>
+<ul>
<li>Primary key (GRANTEE, ROLEID, GRANTOR)</li>
<li>Unique key (UUID)</li>
-</ul> </p></section>
-<table frame="all" pgwide="1">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="27*"/>
-<colspec colname="2" colnum="2" colwidth="10*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
-colnum="5" colwidth="38*"/>
+</ul>
+<p>The following table shows the contents of the SYSROLES system table.</p>
+<table>
+<title>SYSROLES system table</title>
+<tgroup cols="5" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="29*"/>
+<colspec colname="2" colnum="2" colwidth="24*"/>
+<colspec colname="3" colnum="3" colwidth="11*"/>
+<colspec colname="4" colnum="4" colwidth="12*"/>
+<colspec colname="5" colnum="5" colwidth="24*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Column Name</entry>
-<entry align="left" colname="2" valign="bottom">Type</entry>
-<entry align="left" colname="3" valign="bottom">Length</entry>
-<entry align="left" colname="4" valign="bottom">Nullability</entry>
-<entry align="left" colname="5" valign="bottom">Contents</entry>
+<row valign="bottom">
+<entry colname="1">Column Name</entry>
+<entry colname="2">Type</entry>
+<entry colname="3">Length</entry>
+<entry colname="4">Nullable</entry>
+<entry colname="5">Contents</entry>
</row>
</thead>
<tbody>
@@ -58,21 +63,21 @@ colnum="5" colwidth="38*"/>
<entry colname="1">UUID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
-<entry colname="4">False</entry>
-<entry colname="5">A unique identifier for this role.</entry>
+<entry colname="4">false</entry>
+<entry colname="5">A unique identifier for this role</entry>
</row>
<row>
<entry colname="1">ROLEID</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
-<entry colname="4">False</entry>
-<entry colname="5">The role name, after conversion to case normal form.</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The role name, after conversion to case normal form</entry>
</row>
<row>
<entry colname="1">GRANTEE</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">If the row represents a role grant, this is the authorization
identifier of a user or role to which this role is granted. If the row
represents a role definition, this is the database owner's user name.</entry>
@@ -81,7 +86,7 @@ represents a role definition, this is th
<entry colname="1">GRANTOR</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">This is the authorization identifier of the user that granted
this role. If the row represents a role definition, this is the authorization
identifier _SYSTEM. If the row represents a role grant, this is the database
@@ -92,23 +97,24 @@ owner's user name (since only the databa
<entry colname="1">WITHADMINOPTION</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">A role definition is modelled as a grant from _SYSTEM to the
database owner, so if the row represents a role definition, the value is always
-'Y'. This means that the creator (the database owner) is always allowed to grant
-the newly created role. Currently roles cannot be granted WITH ADMIN OPTION, so
-if the row represents a role grant, the value is always 'N'.</entry>
+<i>'Y'</i>. This means that the creator (the database owner) is always allowed
+to grant the newly created role. Currently roles cannot be granted WITH ADMIN
+OPTION, so if the row represents a role grant, the value is always
+<i>'N'</i>.</entry>
</row>
<row>
<entry colname="1">ISDEF</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">If the row represents a role definition, this value is
-'Y'. If the row represents a role grant, the value is 'N'.</entry>
+<i>'Y'</i>. If the row represents a role grant, the value is <i>'N'</i>.</entry>
</row>
</tbody>
</tgroup>
-</table>
+</table></section>
</refbody>
</reference>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabssysroutineperms.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabssysroutineperms.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabssysroutineperms.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabssysroutineperms.dita Fri Apr 29 17:55:29 2011
@@ -24,25 +24,37 @@ under the License.
<title>SYSROUTINEPERMS system table</title>
<shortdesc>The SYSROUTINEPERMS table stores the permissions that have been
granted to routines.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system tables<indexterm>SYSROUTINEPERMS</indexterm></indexterm>
+<indexterm>permissions<indexterm>SYSROUTINEPERMS system table</indexterm></indexterm>
+<indexterm>routine permissions<indexterm>SYSROUTINEPERMS system table</indexterm></indexterm>
+<indexterm>SYSROUTINEPERMS system table</indexterm></keywords>
+</metadata></prolog>
<refbody>
-<section><p>Each routine EXECUTE permission is specified in a row in the SYSROUTINEPERMS
-table. The keys for the SYSROUTINEPERMS table are: <ul>
+<section><p>Each routine EXECUTE permission is specified in a row in the
+SYSROUTINEPERMS table. The keys for the SYSROUTINEPERMS table are:</p>
+<ul>
<li>Primary key (GRANTEE, ALIASID, GRANTOR)</li>
<li>Unique key (ROUTINEPERMSID)</li>
<li>Foreign key (ALIASID references SYS.SYSALIASES)</li>
-</ul> </p><p>The column information for the SYSTABLEPERMS table is listed
-in the following table:</p><table frame="all" pgwide="1">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="27*"/>
-<colspec colname="2" colnum="2" colwidth="10*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
-colnum="5" colwidth="38*"/>
+</ul>
+<p>The following table shows the contents of the SYSROUTINEPERMS system
+table.</p>
+<table>
+<title>SYSROUTINEPERMS system table</title>
+<tgroup cols="5" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="29*"/>
+<colspec colname="2" colnum="2" colwidth="24*"/>
+<colspec colname="3" colnum="3" colwidth="11*"/>
+<colspec colname="4" colnum="4" colwidth="12*"/>
+<colspec colname="5" colnum="5" colwidth="24*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Column Name</entry>
-<entry align="left" colname="2" valign="bottom">Type</entry>
-<entry align="left" colname="3" valign="bottom">Length</entry>
-<entry align="left" colname="4" valign="bottom">Nullability</entry>
-<entry align="left" colname="5" valign="bottom">Contents</entry>
+<row valign="bottom">
+<entry colname="1">Column Name</entry>
+<entry colname="2">Type</entry>
+<entry colname="3">Length</entry>
+<entry colname="4">Nullable</entry>
+<entry colname="5">Contents</entry>
</row>
</thead>
<tbody>
@@ -52,7 +64,7 @@ colnum="5" colwidth="38*"/>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
<entry colname="5">Used by the dependency manager to track the dependency
-of a view, trigger, or constraint on the routine level permissions.</entry>
+of a view, trigger, or constraint on the routine level permissions</entry>
</row>
<row>
<entry colname="1">GRANTEE</entry>
@@ -60,7 +72,7 @@ of a view, trigger, or constraint on the
<entry colname="3">128</entry>
<entry colname="4">false</entry>
<entry colname="5">The authorization ID of the user or role to which the privilege
-is granted.</entry>
+is granted</entry>
</row>
<row>
<entry colname="1">GRANTOR</entry>
@@ -75,9 +87,9 @@ Privileges can be granted only by the ob
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">The ID of the object of the required permission. If PERMTYPE='E'
-the ALIASID is a reference to the SYS.SYSALIASES table. Otherwise the ALIASID
-is a reference to the SYS.SYSTABLES table.</entry>
+<entry colname="5">The ID of the object of the required permission. If
+PERMTYPE=<i>'E'</i>, the ALIASID is a reference to the SYS.SYSALIASES table.
+Otherwise, the ALIASID is a reference to the SYS.SYSTABLES table.</entry>
</row>
<row>
<entry colname="1">GRANTOPTION</entry>
@@ -85,7 +97,7 @@ is a reference to the SYS.SYSTABLES tabl
<entry colname="3">1</entry>
<entry colname="4">false</entry>
<entry colname="5">Specifies if the GRANTEE is the owner of the routine. Valid
-values are Y and N.</entry>
+values are <i>'Y'</i> and <i>'N'</i>.</entry>
</row>
</tbody>
</tgroup>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabssyssequences.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabssyssequences.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabssyssequences.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabssyssequences.dita Fri Apr 29 17:55:29 2011
@@ -22,8 +22,8 @@ under the License.
-->
<reference id="rrefsistabssyssequences" xml:lang="en-us">
<title>SYSSEQUENCES system table</title>
-<shortdesc>The SYSSEQUENCES system table describes the sequence generators in
-the database.</shortdesc>
+<shortdesc>The SYSSEQUENCES table describes the sequence generators in the
+database.</shortdesc>
<prolog><metadata>
<keywords><indexterm>system tables<indexterm>SYSSEQUENCES</indexterm></indexterm>
<indexterm>sequence generators<indexterm>SYSSEQUENCES system table</indexterm></indexterm>
@@ -31,18 +31,22 @@ the database.</shortdesc>
</metadata></prolog>
<refbody>
<section>
-<table frame="all" pgwide="1">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="27*"/>
-<colspec colname="2" colnum="2" colwidth="10*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
-colnum="5" colwidth="38*"/>
+<p>The following table shows the contents of the SYSSEQUENCES system table.</p>
+<table>
+<title>SYSSEQUENCES system table</title>
+<tgroup cols="5" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="29*"/>
+<colspec colname="2" colnum="2" colwidth="24*"/>
+<colspec colname="3" colnum="3" colwidth="11*"/>
+<colspec colname="4" colnum="4" colwidth="12*"/>
+<colspec colname="5" colnum="5" colwidth="24*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Column Name</entry>
-<entry align="left" colname="2" valign="bottom">Type</entry>
-<entry align="left" colname="3" valign="bottom">Length</entry>
-<entry align="left" colname="4" valign="bottom">Nullability</entry>
-<entry align="left" colname="5" valign="bottom">Contents</entry>
+<row valign="bottom">
+<entry colname="1">Column Name</entry>
+<entry colname="2">Type</entry>
+<entry colname="3">Length</entry>
+<entry colname="4">Nullable</entry>
+<entry colname="5">Contents</entry>
</row>
</thead>
<tbody>
@@ -51,7 +55,7 @@ colnum="5" colwidth="38*"/>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">The id of the sequence generator. This is the primary key.</entry>
+<entry colname="5">The ID of the sequence generator. This is the primary key.</entry>
</row>
<row>
<entry colname="1">SEQUENCENAME</entry>
@@ -66,18 +70,19 @@ on (SCHEMAID, SEQUENCENAME).</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">The id of the schema which holds the sequence generator.
-There is a foreign key linking this column to SYS.SYSSCHEMAS.SCHEMAID.</entry>
+<entry colname="5">The ID of the schema that holds the sequence generator.
+There is a foreign key linking this column to SYSSCHEMAS.SCHEMAID.</entry>
</row>
<row>
<entry colname="1">SEQUENCEDATATYPE</entry>
<entry colname="2"><i>org.apache.derby.
-catalog.TypeDescriptor</i>
+catalog.
+TypeDescriptor</i>
<p>This class is not part of the public API.</p></entry>
<entry colname="3">2,147,483,647</entry>
<entry colname="4">false</entry>
<entry colname="5">System type that describes the precision, length, scale,
-nullability, type name, and storage type of the data.</entry>
+nullability, type name, and storage type of the data</entry>
</row>
<row>
<entry colname="1">CURRENTVALUE</entry>
@@ -93,36 +98,36 @@ generator is exhausted and cannot issue
<entry colname="2">BIGINT</entry>
<entry colname="3">19</entry>
<entry colname="4">false</entry>
-<entry colname="5">The initial value of the sequence generator.</entry>
+<entry colname="5">The initial value of the sequence generator</entry>
</row>
<row>
<entry colname="1">MINIMUMVALUE</entry>
<entry colname="2">BIGINT</entry>
<entry colname="3">19</entry>
<entry colname="4">false</entry>
-<entry colname="5">The minimum value of the sequence generator.</entry>
+<entry colname="5">The minimum value of the sequence generator</entry>
</row>
<row>
<entry colname="1">MAXIMUMVALUE</entry>
<entry colname="2">BIGINT</entry>
<entry colname="3">19</entry>
<entry colname="4">false</entry>
-<entry colname="5">The maximum value of the sequence generator.</entry>
+<entry colname="5">The maximum value of the sequence generator</entry>
</row>
<row>
<entry colname="1">INCREMENT</entry>
<entry colname="2">BIGINT</entry>
<entry colname="3">19</entry>
<entry colname="4">false</entry>
-<entry colname="5">The step size of the sequence generator.</entry>
+<entry colname="5">The step size of the sequence generator</entry>
</row>
<row>
<entry colname="1">CYCLEOPTION</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5">If the sequence generator cycles, this value is 'Y'. If the
-sequence generator does not cycle, this value is 'N'.</entry>
+<entry colname="5">If the sequence generator cycles, this value is <i>'Y'</i>.
+If the sequence generator does not cycle, this value is <i>'N'</i>.</entry>
</row>
</tbody>
</tgroup>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabssystableperms.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabssystableperms.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabssystableperms.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabssystableperms.dita Fri Apr 29 17:55:29 2011
@@ -30,25 +30,31 @@ been granted but not revoked.</shortdesc
<indexterm>SYSTABLEPERMS system table</indexterm></keywords>
</metadata></prolog>
<refbody>
-<section><p>All of the permissions for one (GRANTEE, TABLEID, GRANTOR) combination
+<section>
+<p>All of the permissions for one (GRANTEE, TABLEID, GRANTOR) combination
are specified in a single row in the SYSTABLEPERMS table. The keys for the
-SYSTABLEPERMS table are: <ul>
+SYSTABLEPERMS table are:</p>
+<ul>
<li>Primary key (GRANTEE, TABLEID, GRANTOR)</li>
<li>Unique key (TABLEPERMSID)</li>
<li>Foreign key (TABLEID references SYS.SYSTABLES)</li>
-</ul> </p><p>The column information for the SYSTABLEPERMS table is listed
-in the following table:</p><table frame="all" pgwide="1">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="27*"/>
-<colspec colname="2" colnum="2" colwidth="10*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
-colnum="5" colwidth="38*"/>
+</ul>
+<p>The following table shows the contents of the SYSTABLEPERMS system table.</p>
+<table>
+<title>SYSTABLEPERMS system table</title>
+<tgroup cols="5" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="29*"/>
+<colspec colname="2" colnum="2" colwidth="24*"/>
+<colspec colname="3" colnum="3" colwidth="11*"/>
+<colspec colname="4" colnum="4" colwidth="12*"/>
+<colspec colname="5" colnum="5" colwidth="24*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Column Name</entry>
-<entry align="left" colname="2" valign="bottom">Type</entry>
-<entry align="left" colname="3" valign="bottom">Length</entry>
-<entry align="left" colname="4" valign="bottom">Nullability</entry>
-<entry align="left" colname="5" valign="bottom">Contents</entry>
+<row valign="bottom">
+<entry colname="1">Column Name</entry>
+<entry colname="2">Type</entry>
+<entry colname="3">Length</entry>
+<entry colname="4">Nullable</entry>
+<entry colname="5">Contents</entry>
</row>
</thead>
<tbody>
@@ -56,62 +62,63 @@ colnum="5" colwidth="38*"/>
<entry colname="1">TABLEPERMSID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">Used by the dependency manager to track the dependency
-of a view, trigger, or constraint on the table level permissions.</entry>
+of a view, trigger, or constraint on the table level permissions</entry>
</row>
<row>
<entry colname="1">GRANTEE</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
-<entry colname="4">False</entry>
-<entry colname="5">The authorization ID of the user or role to which the privilege
-is granted.</entry>
+<entry colname="4">false</entry>
+<entry colname="5">The authorization ID of the user or role to which the
+privilege is granted</entry>
</row>
<row>
<entry colname="1">GRANTOR</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">The authorization ID of the user who granted the privilege.
-Privileges can be granted only by the object owner.</entry>
+Privileges can be granted only by the object owner</entry>
</row>
<row>
<entry colname="1">TABLEID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">The unique identifier for the table on which the permissions
-have been granted.</entry>
+have been granted</entry>
</row>
<row>
<entry colname="1">SELECTPRIV</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">Specifies if the SELECT permission is granted. The valid
-values are: <lines>'y' (non-grantable privilege)
-'Y' (grantable privilege)
-'N' (no privilege)</lines></entry>
+values are: <lines><i>'y'</i> (non-grantable privilege)
+<i>'Y'</i> (grantable privilege)
+<i>'N'</i> (no privilege)</lines></entry>
</row>
<row>
<entry colname="1">DELETEPRIV</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">Specifies if the DELETE permission is granted. The valid
-values are: <lines>'y' (non-grantable privilege)
-'Y' (grantable privilege)
-'N' (no privilege)</lines></entry>
+values are: <lines><i>'y'</i> (non-grantable privilege)
+<i>'Y'</i> (grantable privilege)
+<i>'N'</i> (no privilege)</lines></entry>
</row>
<row>
<entry colname="1">INSERTPRIV</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
<entry colname="4">False</entry>
-<entry colname="5">Specifies if the INSERT permission is granted. <lines>'y' (non-grantable privilege)
-'Y' (grantable privilege)
-'N' (no privilege)</lines></entry>
+<entry colname="5">Specifies if the INSERT permission is granted. The valid
+values are: <lines><i>'y'</i> (non-grantable privilege)
+<i>'Y'</i> (grantable privilege)
+<i>'N'</i> (no privilege)</lines></entry>
</row>
<row>
<entry colname="1">UPDATEPRIV</entry>
@@ -119,29 +126,29 @@ values are: <lines>'y' (non-grantable pr
<entry colname="3">1</entry>
<entry colname="4">False</entry>
<entry colname="5">Specifies if the UPDATE permission is granted. The valid
-values are: <lines>'y' (non-grantable privilege)
-'Y' (grantable privilege)
-'N' (no privilege)</lines></entry>
+values are: <lines><i>'y'</i> (non-grantable privilege)
+<i>'Y'</i> (grantable privilege)
+<i>'N'</i> (no privilege)</lines></entry>
</row>
<row>
<entry colname="1">REFERENCESPRIV</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">Specifies if the REFERENCE permission is granted. The valid
-values are: <lines>'y' (non-grantable privilege)
-'Y' (grantable privilege)
-'N' (no privilege)</lines></entry>
+values are: <lines><i>'y'</i> (non-grantable privilege)
+<i>'Y'</i> (grantable privilege)
+<i>'N'</i> (no privilege)</lines></entry>
</row>
<row>
<entry colname="1">TRIGGERPRIV</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
-<entry colname="4">False</entry>
+<entry colname="4">false</entry>
<entry colname="5">Specifies if the TRIGGER permission is granted. The valid
-values are: <lines>'y' (non-grantable privilege)
-'Y' (grantable privilege)
-'N' (no privilege)</lines></entry>
+values are: <lines><i>'y'</i> (non-grantable privilege)
+<i>'Y'</i> (grantable privilege)
+<i>'N'</i> (no privilege)</lines></entry>
</row>
</tbody>
</tgroup>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsql9241891.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsql9241891.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsql9241891.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsql9241891.dita Fri Apr 29 17:55:29 2011
@@ -30,12 +30,14 @@ not supported by Derby</indexterm></inde
FIPS 127-2</p></li>
<li>SQL92I <p>Intermediate</p></li>
<li>SQL92F <p>Full</p></li>
-</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"/>
+</ul> </p>
+<p>The following tables show Derby support for SQL-92 features.</p>
+<table>
+<title>Support for SQL-92 features: Basic data types</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -86,11 +88,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Basic math operations</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -106,11 +110,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Basic comparisons</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -126,11 +132,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Basic predicates</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -146,11 +154,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Quantified predicates</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -166,11 +176,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: schema definition</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -196,11 +208,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: column attributes</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -221,11 +235,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: constraints (non-deferrable)</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -261,11 +277,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Cursors</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -286,11 +304,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Dynamic SQL 1</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -322,11 +342,13 @@ cursor</entry>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Basic information schema</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -352,11 +374,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Basic schema manipulation</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -392,11 +416,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Joined table</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -432,11 +458,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Date and time data types</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -472,11 +500,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: VARCHAR</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -497,11 +527,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Transaction isolation</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -522,11 +554,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Multiple schemas per user</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -542,11 +576,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Privilege tables</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -572,11 +608,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Table operations</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -607,11 +645,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Schema definition statement</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -627,11 +667,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: User authorization</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -662,11 +704,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Constraint tables</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -692,11 +736,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Documentation schema</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -717,11 +763,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Full DATETIME</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -737,11 +785,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Full character functions</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -762,11 +812,13 @@ colname="col3"/>
</row>
</tbody>
</tgroup>
-</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"/>
+</table>
+<table>
+<title>Support for SQL-92 features: Miscellaneous</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="40*"/>
+<colspec colname="col2" colnum="2" colwidth="30*"/>
+<colspec colname="col3" colnum="3" colwidth="30*"/>
<thead>
<row valign="bottom">
<entry colname="col1">Feature</entry>
@@ -1164,6 +1216,7 @@ through JDBC 2.0)</entry>
</row>
</tbody>
</tgroup>
-</table></section>
+</table>
+</section>
</refbody>
</reference>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsqlj19433.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsqlj19433.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsqlj19433.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsqlj19433.dita Fri Apr 29 17:55:29 2011
@@ -69,15 +69,18 @@ portion)</li>
blocks, and so allow expressions as part of these elements. </p><p>The following
tables list all the possible SQL expressions and indicate where the expressions
are allowed.</p></section>
-<section><title>General expressions</title><p>General expressions are expressions
-that might result in a value of any type.<table frame="all" id="sqlj18370"
-pgwide="0"><title>Table of general expressions</title>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="2" colnum="1" colwidth="30*"/>
+<section><title>General expressions</title>
+<p>General expressions are expressions that might result in a value of any type.
+The following table lists the types of general expressions.</p>
+<table frame="all" id="sqlj18370">
+<title>General expressions</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="2" colnum="1" colwidth="30*"/>
<colspec colname="3" colnum="2" colwidth="60*"/>
<thead>
-<row>
-<entry align="left" colname="2" valign="bottom">Expression Type</entry>
-<entry align="left" colname="3" valign="bottom">Explanation</entry>
+<row valign="bottom">
+<entry colname="2">Expression Type</entry>
+<entry colname="3">Explanation</entry>
</row>
</thead>
<tbody>
@@ -140,27 +143,35 @@ based on a boolean test.</entry>
</row>
</tbody>
</tgroup>
-</table></p></section>
-<section><title>Boolean expressions</title><p>Boolean expressions are expressions
-that result in boolean values. Most general expressions can result in boolean
-values. Boolean expressions commonly used in a WHERE clause are made of operands
-operated on by SQL operators. See <xref href="rrefsqlj23075.dita#rrefsqlj23075/sqlj34517"></xref>.</p></section>
-<section><title>Numeric expressions</title><p>Numeric expressions are expressions
-that result in numeric values. Most of the general expressions can result
-in numeric values. Numeric values have one of the following types: <ul>
+</table></section>
+<section><title>Boolean expressions</title>
+<p>Boolean expressions are expressions that result in boolean values. Most
+general expressions can result in boolean values. Boolean expressions commonly
+used in a WHERE clause are made of operands operated on by SQL operators (see
+<xref href="rrefsqlj23075.dita#rrefsqlj23075/sqlj34517"></xref> for a table
+of SQL operators).</p></section>
+<section><title>Numeric expressions</title>
+<p>Numeric expressions are expressions that result in numeric values. Most of
+the general expressions can result in numeric values. Numeric values have one
+of the following types:</p>
+<ul>
<li>BIGINT</li>
<li>DECIMAL</li>
<li>DOUBLE PRECISION</li>
<li>INTEGER</li>
<li>REAL</li>
<li>SMALLINT</li>
-</ul><table frame="all" pgwide="0"><title>Table of numeric expressions</title>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="2" colnum="1" colwidth="40*"/>
+</ul>
+<p>The following table lists the types of numeric expressions.</p>
+<table frame="all">
+<title>Numeric expressions</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="2" colnum="1" colwidth="40*"/>
<colspec colname="3" colnum="2" colwidth="60*"/>
<thead>
-<row>
-<entry align="left" colname="2" valign="bottom">Expression Type</entry>
-<entry align="left" colname="3" valign="bottom">Explanation</entry>
+<row valign="bottom">
+<entry colname="2">Expression Type</entry>
+<entry colname="3">Explanation</entry>
</row>
</thead>
<tbody>
@@ -198,17 +209,20 @@ href="rrefsqlj66113.dita#rrefsqlj66113">
</row>
</tbody>
</tgroup>
-</table></p></section>
-<section><title>Character expressions</title><p>Character expressions are
-expressions that result in a CHAR or VARCHAR value. Most general expressions
-can result in a CHAR or VARCHAR value.<table frame="all" pgwide="0"><title>Table
-of character expressions</title>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="2" colnum="1" colwidth="40*"/>
+</table></section>
+<section><title>Character expressions</title>
+<p>Character expressions are expressions that result in a CHAR or VARCHAR value.
+Most general expressions can result in a CHAR or VARCHAR value. The following
+table lists the types of character expressions.</p>
+<table frame="all">
+<title>Character expressions</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="2" colnum="1" colwidth="40*"/>
<colspec colname="3" colnum="2" colwidth="60*"/>
<thead>
-<row>
-<entry align="left" colname="2" valign="bottom">Expression Type</entry>
-<entry align="left" colname="3" valign="bottom">Explanation</entry>
+<row valign="bottom">
+<entry colname="2">Expression Type</entry>
+<entry colname="3">Explanation</entry>
</row>
</thead>
<tbody>
@@ -238,17 +252,20 @@ href="rrefsqlj25228.dita#rrefsqlj25228">
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
<section><title>Date and time expressions</title><p>A date or time expression
results in a DATE, TIME, or TIMESTAMP value. Most of the general expressions
-can result in a date or time value. <table frame="all" pgwide="0"><title>Table
-of date and time expressions</title>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="2" colnum="1" colwidth="30*"/>
+can result in a date or time value. The following table lists the types of date
+and time expressions.</p>
+<table frame="all">
+<title>Date and time expressions</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="2" colnum="1" colwidth="30*"/>
<colspec colname="3" colnum="2" colwidth="50*"/>
<thead>
-<row>
-<entry align="left" colname="2" valign="bottom">Expression type</entry>
-<entry align="left" colname="3" valign="bottom">Explanation</entry>
+<row valign="bottom">
+<entry colname="2">Expression Type</entry>
+<entry colname="3">Explanation</entry>
</row>
</thead>
<tbody>
@@ -266,6 +283,6 @@ of date and time expressions</title>
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
</refbody>
</reference>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsqlj23075.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsqlj23075.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsqlj23075.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsqlj23075.dita Fri Apr 29 17:55:29 2011
@@ -39,16 +39,18 @@ more information. Boolean expressions in
syntax; see <xref 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 frame="all" id="sqlj34517" pgwide="1"><title>SQL Boolean Operators</title>
-<tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="24*"/>
-<colspec colname="2" colnum="2" colwidth="45*"/><colspec colname="3" colnum="3"
-colwidth="30*"/>
+These operators are listed in the following table.</p>
+<table frame="all" id="sqlj34517">
+<title>SQL Boolean operators</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="25*"/>
+<colspec colname="2" colnum="2" colwidth="45*"/>
+<colspec colname="3" colnum="3" colwidth="30*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Operator</entry>
-<entry align="left" colname="2" valign="bottom">Explanation and Example</entry>
-<entry align="left" colname="3" valign="bottom">Syntax</entry>
+<row valign="bottom">
+<entry colname="1">Operator</entry>
+<entry colname="2">Explanation and Example</entry>
+<entry colname="3">Syntax</entry>
</row>
</thead>
<tbody>
@@ -180,7 +182,6 @@ be true for at least one value of the ta
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
</refbody>
</reference>
-<?Pub *0000008541?>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsqlj27767.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsqlj27767.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsqlj27767.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsqlj27767.dita Fri Apr 29 17:55:29 2011
@@ -24,16 +24,17 @@ limitations under the License.
<section><p>In expressions that use only integer types, <ph conref="../conrefs.dita#prod/productshortname"></ph> promotes
the type of the result to at least INTEGER. In expressions that mix integer
with non-integer types, <ph conref="../conrefs.dita#prod/productshortname"></ph> promotes
-the result of the expression to the highest type in the expression. <xref
-href="#rrefsqlj27767/sqlj39640"></xref> shows the promotion of data types in expressions.
- <table frame="all" id="sqlj39640"><title>Type Promotion in Expressions</title>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="62*"/>
+the result of the expression to the highest type in the expression. The
+following table shows the promotion of data types in expressions.</p>
+<table frame="all">
+<title>Type promotion in expressions</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="62*"/>
<colspec colname="2" colnum="2" colwidth="38*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Largest Type That Appears
-in Expression</entry>
-<entry align="left" colname="2" valign="bottom">Resulting Type of Expression</entry>
+<row valign="bottom">
+<entry colname="1">Largest Type That Appears in Expression</entry>
+<entry colname="2">Resulting Type of Expression</entry>
</row>
</thead>
<tbody>
@@ -63,7 +64,7 @@ in Expression</entry>
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
<section><p>For example: <codeblock><b><ph>-- returns a double precision</ph>
VALUES 1 + 1.0e0
<ph>-- returns a decimal</ph>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsqlj33562.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsqlj33562.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsqlj33562.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsqlj33562.dita Fri Apr 29 17:55:29 2011
@@ -41,41 +41,43 @@ The first row lists the target data type
from the source to the target is valid. For example, the first cell in the
second row lists the source data type SMALLINT. The remaining cells on the
second row indicate the whether or not you can convert SMALLINT to the target
-data types that are listed in the first row of the table.<table><title>Explicit
-conversions between source types and target types for SQL data types</title>
-<tgroup cols="20">
-<colspec colname="colspec0" colwidth="330*"/>
-<colspec colname="col_boolean" colwidth="84*"/>
-<colspec colname="col_smallint" colwidth="84*"/>
-<colspec colname="col_integer" colwidth="84*"/>
-<colspec colname="col_bigint" colwidth="84*"/>
-<colspec colname="col_decimal" colwidth="84*"/>
-<colspec colname="col_real" colwidth="81*"/>
-<colspec colname="col_double" colwidth="84*"/>
-<colspec colname="col_float" colwidth="84*"/>
-<colspec colname="col_char" colwidth="84*"/>
-<colspec colname="col_varchar" colwidth="84*"/>
-<colspec colname="col_longvarchar" colwidth="81*"/>
-<colspec colname="col_charforbitdata" colwidth="84*"/>
-<colspec colname="col_varcharforbitdata" colwidth="87*"/>
-<colspec colname="col_longvarcharforbitdata" colwidth="81*"/>
-<colspec colname="col_clob" colwidth="84*"/>
-<colspec colname="col_blob" colwidth="84*"/>
-<colspec colname="col_date" colwidth="84*"/>
-<colspec colname="col_time" colwidth="84*"/>
-<colspec colname="col_timestamp" colwidth="84*"/>
-<colspec colname="col_xml" colwidth="84*"/>
+data types that are listed in the first row of the table.</p>
+<table>
+<title>Explicit conversions between source types and target types for SQL data
+types</title>
+<tgroup cols="20" colsep="1" rowsep="1">
+<colspec colname="colspec0" colnum="1" colwidth="330*"/>
+<colspec colname="col_boolean" colnum="2" colwidth="84*"/>
+<colspec colname="col_smallint" colnum="3" colwidth="84*"/>
+<colspec colname="col_integer" colnum="4" colwidth="84*"/>
+<colspec colname="col_bigint" colnum="5" colwidth="84*"/>
+<colspec colname="col_decimal" colnum="6" colwidth="84*"/>
+<colspec colname="col_real" colnum="7" colwidth="81*"/>
+<colspec colname="col_double" colnum="8" colwidth="84*"/>
+<colspec colname="col_float" colnum="9" colwidth="84*"/>
+<colspec colname="col_char" colnum="10" colwidth="84*"/>
+<colspec colname="col_varchar" colnum="11" colwidth="84*"/>
+<colspec colname="col_longvarchar" colnum="12" colwidth="81*"/>
+<colspec colname="col_charforbitdata" colnum="13" colwidth="84*"/>
+<colspec colname="col_varcharforbitdata" colnum="14" colwidth="87*"/>
+<colspec colname="col_longvarcharforbitdata" colnum="15" colwidth="81*"/>
+<colspec colname="col_clob" colnum="16" colwidth="84*"/>
+<colspec colname="col_blob" colnum="17" colwidth="84*"/>
+<colspec colname="col_date" colnum="18" colwidth="84*"/>
+<colspec colname="col_time" colnum="19" colwidth="84*"/>
+<colspec colname="col_timestamp" colnum="20" colwidth="84*"/>
+<colspec colname="col_xml" colnum="21" colwidth="84*"/>
<thead>
-<row>
-<entry colname="colspec0" valign="top">Types</entry>
-<entry colname="col_smallint" valign="top"> <lines>B
+<row valign="bottom">
+<entry colname="colspec0">Types</entry>
+<entry colname="col_smallint"> <lines>B
O
O
L
E
A
N</lines></entry>
-<entry colname="col_smallint" valign="top"> <lines>S
+<entry colname="col_smallint"> <lines>S
M
A
L
@@ -83,53 +85,53 @@ L
I
N
T</lines></entry>
-<entry colname="col_integer" valign="top"> <lines>I
+<entry colname="col_integer"> <lines>I
N
T
E
G
E
R</lines></entry>
-<entry colname="col_bigint" valign="top"> <lines>B
+<entry colname="col_bigint"> <lines>B
I
G
I
N
T</lines></entry>
-<entry colname="col_decimal" valign="top"> <lines>D
+<entry colname="col_decimal"> <lines>D
E
C
I
M
A
L</lines></entry>
-<entry colname="col_real" valign="top"> <lines>R
+<entry colname="col_real"> <lines>R
E
A
L</lines></entry>
-<entry colname="col_double" valign="top"> <lines>D
+<entry colname="col_double"> <lines>D
O
U
B
L
E</lines></entry>
-<entry colname="col_float" valign="top"> <lines>F
+<entry colname="col_float"> <lines>F
L
O
A
T</lines></entry>
-<entry colname="col_char" valign="top"> <lines>C
+<entry colname="col_char"> <lines>C
H
A
R</lines></entry>
-<entry colname="col_varchar" valign="top"> <lines>V
+<entry colname="col_varchar"> <lines>V
A
R
C
H
A
R</lines></entry>
-<entry colname="col_longvarchar" valign="top"> <lines>L
+<entry colname="col_longvarchar"> <lines>L
O
N
G
@@ -141,7 +143,7 @@ C
H
A
R</lines></entry>
-<entry colname="col_charforbitdata" valign="top"> <lines>C
+<entry colname="col_charforbitdata"> <lines>C
H
A
R
@@ -158,7 +160,7 @@ D
A
T
A</lines></entry>
-<entry colname="col_varcharforbitdata" valign="top"> <lines>V
+<entry colname="col_varcharforbitdata"> <lines>V
A
R
C
@@ -178,7 +180,7 @@ D
A
T
A</lines></entry>
-<entry colname="col_longvarcharforbitdata" valign="top"> <lines>L
+<entry colname="col_longvarcharforbitdata"> <lines>L
O
N
G
@@ -203,23 +205,23 @@ D
A
T
A</lines></entry>
-<entry colname="col_clob" valign="top"> <lines>C
+<entry colname="col_clob"> <lines>C
L
O
B</lines></entry>
-<entry colname="col_blob" valign="top"> <lines>B
+<entry colname="col_blob"> <lines>B
L
O
B</lines></entry>
-<entry colname="col_date" valign="top"> <lines>D
+<entry colname="col_date"> <lines>D
A
T
E</lines></entry>
-<entry colname="col_time" valign="top"> <lines>T
+<entry colname="col_time"> <lines>T
I
M
E</lines></entry>
-<entry colname="col_timestamp" valign="top"> <lines>T
+<entry colname="col_timestamp"> <lines>T
I
M
E
@@ -228,7 +230,7 @@ T
A
M
P</lines></entry>
-<entry colname="col_xml" valign="top"> <lines>X
+<entry colname="col_xml"> <lines>X
M
L</lines></entry>
</row>
@@ -696,7 +698,7 @@ L</lines></entry>
</row>
</tbody>
</tgroup>
-</table></p><p>If a conversion is valid, CASTs are allowed. Size incompatibilities
+</table><p>If a conversion is valid, CASTs are allowed. Size incompatibilities
between the source and target types might cause runtime errors.</p> </section>
<section><title>Notes</title> <p>In this discussion, the <ph conref="../conrefs.dita#prod/productshortname"></ph> SQL-92
data types are categorized as follows: <ul>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsqlj33923.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsqlj33923.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsqlj33923.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsqlj33923.dita Fri Apr 29 17:55:29 2011
@@ -20,6 +20,12 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsqlj33923" xml:lang="en-us">
<title>Aggregates (set functions)</title>
+<prolog><metadata>
+<keywords>
+<indexterm>Aggregates<indexterm>and data types</indexterm></indexterm>
+<indexterm>Aggregates<indexterm>requirements for</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
<refbody>
<section><p>This section describes aggregates (also described as <i>set functions</i> in
ANSI SQL-92 and as <i>column functions</i> in some database literature). They
@@ -28,17 +34,17 @@ other built-in functions operate on a si
on a set of values and reduce them to a single scalar value. Built-in aggregates
can calculate the minimum, maximum, sum, count, and average of an expression
over a set of values as well as count rows.</p></section>
-<section><p><indexterm>Aggregates<indexterm>and data types</indexterm></indexterm>The
-built-in aggregates can operate on the data types shown in <xref href="rrefsqlj33923.dita#rrefsqlj33923/sqlj92398"></xref>.
- <table frame="all" id="sqlj92398"><title>Permitted Data Types for Built-in
-Aggregates</title>
+<section><p>The built-in aggregates can operate on the data types shown in
+the following table.</p>
+<table frame="all">
+<title>Permitted data types for built-in aggregates</title>
<tgroup cols="2" colsep="1" rowsep="1">
-<colspec colname="1" colnum="1" colwidth="20*"/>
-<colspec colname="2" colnum="2" colwidth="40*"/>
+<colspec colname="1" colnum="1" colwidth="33*"/>
+<colspec colname="2" colnum="2" colwidth="67*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Function Name</entry>
-<entry align="left" colname="2" valign="bottom">Permitted Data Types</entry>
+<row valign="bottom">
+<entry colname="1">Function Name</entry>
+<entry colname="2">Permitted Data Types</entry>
</row>
</thead>
<tbody>
@@ -64,9 +70,8 @@ Aggregates</title>
</row>
</tbody>
</tgroup>
-</table></p></section>
-<section><p><indexterm>Aggregates<indexterm>requirements for</indexterm></indexterm>Aggregates
-are permitted only in the following: <ul>
+</table></section>
+<section><p>Aggregates are permitted only in the following: <ul>
<li>A <i>SelectItem</i> in a <i><xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpression</xref>.</i></li>
<li>A <xref href="rrefsqlj14854.dita#rrefsqlj14854">HAVING clause</xref>.</li>
<li>An <xref href="rrefsqlj13658.dita#rrefsqlj13658">ORDER BY clause</xref> (using an alias
Modified: db/derby/docs/branches/10.8/src/ref/rrefsqlj37836.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsqlj37836.dita?rev=1097901&r1=1097900&r2=1097901&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsqlj37836.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsqlj37836.dita Fri Apr 29 17:55:29 2011
@@ -90,16 +90,19 @@ value with each insert. If this value is
the value with each insert. A value of 0 raises a statement exception. </p><p>The maximum and minimum values allowed in
identity columns are determined by the data type of the column. Attempting
to insert a value outside the range of values supported by the data type raises
-an exception. <table frame="all"><title>Maximum and Minimum Values for Columns
-with Generated Column Specs</title>
-<tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="16*"/>
-<colspec colname="2" colnum="2" colwidth="42*"/><colspec colname="3" colnum="3"
-colwidth="42*"/>
+an exception. The following table shows the supported ranges.</p>
+<table frame="all">
+<title>Maximum and minimum values for columns with generated column
+specs</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="16*"/>
+<colspec colname="2" colnum="2" colwidth="42*"/>
+<colspec colname="3" colnum="3" colwidth="42*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Data type</entry>
-<entry align="left" colname="2" valign="bottom">Maximum Value</entry>
-<entry align="left" colname="3" valign="bottom">Minimum Value</entry>
+<row valign="bottom">
+<entry colname="1">Data Type</entry>
+<entry colname="2">Maximum Value</entry>
+<entry colname="3">Minimum Value</entry>
</row>
</thead>
<tbody>
@@ -120,7 +123,8 @@ colwidth="42*"/>
</row>
</tbody>
</tgroup>
-</table></p><p>Automatically generated values in an identity column are unique.
+</table>
+<p>Automatically generated values in an identity column are unique.
Use a primary key or unique constraint on a column to guarantee uniqueness.
Creating an identity column <i>does not</i> create an index on the column.</p><p>The <codeph>IDENTITY_VAL_LOCAL</codeph> function
is a non-deterministic function that returns the most recently assigned value