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:35:39 UTC
svn commit: r1097897 [1/3] - /db/derby/docs/trunk/src/ref/
Author: chaase3
Date: Fri Apr 29 17:35:37 2011
New Revision: 1097897
URL: http://svn.apache.org/viewvc?rev=1097897&view=rev
Log:
DERBY-5184 Tables in documentation need introductions and formatting fixes
Modifications to 55 Reference Manual topics.
Patches: DERBY-5184-ref.diff
Modified:
db/derby/docs/trunk/src/ref/crefproper22250.dita
db/derby/docs/trunk/src/ref/rrefattrib56769.dita
db/derby/docs/trunk/src/ref/rrefattribtracelevel.dita
db/derby/docs/trunk/src/ref/rrefdbmlimits.dita
db/derby/docs/trunk/src/ref/rrefdttlimits.dita
db/derby/docs/trunk/src/ref/rrefidlengthlimits.dita
db/derby/docs/trunk/src/ref/rrefjavsqlprst.dita
db/derby/docs/trunk/src/ref/rrefjdbc20377.dita
db/derby/docs/trunk/src/ref/rrefjdbc23502.dita
db/derby/docs/trunk/src/ref/rrefjdbc27734.dita
db/derby/docs/trunk/src/ref/rrefjdbc38274.dita
db/derby/docs/trunk/src/ref/rrefjdbc40794.dita
db/derby/docs/trunk/src/ref/rrefjdbc75719.dita
db/derby/docs/trunk/src/ref/rrefjdbc96386.dita
db/derby/docs/trunk/src/ref/rreflimitsxml.dita
db/derby/docs/trunk/src/ref/rrefnumericlimits.dita
db/derby/docs/trunk/src/ref/rrefsistabs12085.dita
db/derby/docs/trunk/src/ref/rrefsistabs12813.dita
db/derby/docs/trunk/src/ref/rrefsistabs13420.dita
db/derby/docs/trunk/src/ref/rrefsistabs22441.dita
db/derby/docs/trunk/src/ref/rrefsistabs23241.dita
db/derby/docs/trunk/src/ref/rrefsistabs24045.dita
db/derby/docs/trunk/src/ref/rrefsistabs24269.dita
db/derby/docs/trunk/src/ref/rrefsistabs26665.dita
db/derby/docs/trunk/src/ref/rrefsistabs28114.dita
db/derby/docs/trunk/src/ref/rrefsistabs33768.dita
db/derby/docs/trunk/src/ref/rrefsistabs33921.dita
db/derby/docs/trunk/src/ref/rrefsistabs39391.dita
db/derby/docs/trunk/src/ref/rrefsistabs40972.dita
db/derby/docs/trunk/src/ref/rrefsistabs79888.dita
db/derby/docs/trunk/src/ref/rrefsistabslilanguageitemsysstatistics.dita
db/derby/docs/trunk/src/ref/rrefsistabssyscolperms.dita
db/derby/docs/trunk/src/ref/rrefsistabssysperms.dita
db/derby/docs/trunk/src/ref/rrefsistabssysroles.dita
db/derby/docs/trunk/src/ref/rrefsistabssysroutineperms.dita
db/derby/docs/trunk/src/ref/rrefsistabssyssequences.dita
db/derby/docs/trunk/src/ref/rrefsistabssystableperms.dita
db/derby/docs/trunk/src/ref/rrefsql9241891.dita
db/derby/docs/trunk/src/ref/rrefsqlj19433.dita
db/derby/docs/trunk/src/ref/rrefsqlj23075.dita
db/derby/docs/trunk/src/ref/rrefsqlj27767.dita
db/derby/docs/trunk/src/ref/rrefsqlj33562.dita
db/derby/docs/trunk/src/ref/rrefsqlj33923.dita
db/derby/docs/trunk/src/ref/rrefsqlj37836.dita
db/derby/docs/trunk/src/ref/rrefsqlj58560.dita
db/derby/docs/trunk/src/ref/rrefsqlj75638.dita
db/derby/docs/trunk/src/ref/rrefsqljargmatching.dita
db/derby/docs/trunk/src/ref/rrefstringlimits.dita
db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita
db/derby/docs/trunk/src/ref/rrefsysxplain_resultset_timings.dita
db/derby/docs/trunk/src/ref/rrefsysxplain_resultsets.dita
db/derby/docs/trunk/src/ref/rrefsysxplain_scan_props.dita
db/derby/docs/trunk/src/ref/rrefsysxplain_sort_props.dita
db/derby/docs/trunk/src/ref/rrefsysxplain_statement_timings.dita
db/derby/docs/trunk/src/ref/rrefsysxplain_statements.dita
Modified: db/derby/docs/trunk/src/ref/crefproper22250.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/crefproper22250.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/crefproper22250.dita (original)
+++ db/derby/docs/trunk/src/ref/crefproper22250.dita Fri Apr 29 17:35:37 2011
@@ -28,10 +28,8 @@ such as logging statements, and monitori
</keywords>
</metadata></prolog>
<conbody>
-<p>The table
-<xref href="crefproper22250.dita#crefproper22250/rrefproper24108"></xref> lists
-all the core <ph conref="../conrefs.dita#prod/productshortname"></ph>
-properties.</p>
+<p>The table later in this topic lists all the core
+<ph conref="../conrefs.dita#prod/productshortname"></ph> properties.</p>
<p><ph conref="../conrefs.dita#prod/productshortname"></ph> also supports a
number of properties that are specific to the Network Server. For information
about these properties, see "Setting Network Server properties" in the
@@ -72,17 +70,19 @@ s.executeUpdate("CALL SYSCS_UTIL.SYSCS_S
you reboot the database. Moreover, the static property
<i><xref href="rrefpropersqlauth.dita#rrefpropersqlauth"></xref></i> cannot be
disabled after it has been enabled, even with a reboot.</p>
-<p><xref href="crefproper22250.dita#crefproper22250/rrefproper24108"></xref> summarizes
+<p>The following table summarizes
the general <ph conref="../conrefs.dita#prod/productshortname"></ph> properties.
In the Scope column of this table, S stands for system-wide, D stands for
database-wide, and C indicates the value persists with newly created
conglomerates.</p>
- <table frame="all" id="rrefproper24108" pgwide="0"><title>Derby properties</title>
-<tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="50*"/>
-<colspec colname="2" colnum="2" colwidth="12*"/><colspec colname="3" colnum="3"
-colwidth="38*"/>
+<table frame="all">
+<title>Derby properties</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="50*"/>
+<colspec colname="2" colnum="2" colwidth="12*"/>
+<colspec colname="3" colnum="3" colwidth="38*"/>
<thead>
-<row>
+<row valign="bottom">
<entry colname="1">Property</entry>
<entry colname="2">Scope</entry>
<entry colname="3">Dynamic or Static</entry>
Modified: db/derby/docs/trunk/src/ref/rrefattrib56769.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefattrib56769.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefattrib56769.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefattrib56769.dita Fri Apr 29 17:35:37 2011
@@ -33,14 +33,17 @@ Setting the <i>territory</i> attribute o
for that database. The default system territory is found using <i>java.util.Locale.getDefault()</i>.</p> <p>Specify
a territory in the form <i>ll_CC</i>, where <i>ll</i> is the two-letter language
code, and <i>CC</i> is the two-letter country code. </p> <p>Language codes
-consist of a pair of lowercase letters that conform to ISO-639. <table frame="all">
-<title>Sample Language Codes</title>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="50*"/>
+consist of a pair of lowercase letters that conform to ISO-639. The following
+table shows some examples.</p>
+<table frame="all">
+<title>Sample language codes</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="50*"/>
<colspec colname="2" colnum="2" colwidth="50*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Language Code </entry>
-<entry align="left" colname="2" valign="bottom">Description </entry>
+<row valign="bottom">
+<entry colname="1">Language Code </entry>
+<entry colname="2">Description </entry>
</row>
</thead>
<tbody>
@@ -62,16 +65,20 @@ consist of a pair of lowercase letters t
</row>
</tbody>
</tgroup>
-</table></p> <p>To see a full list of ISO-639 codes, go to <xref format="html"
-href="http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt" scope="external"><i>http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt</i></xref
->.</p> <p>Country codes consist of two uppercase letters that conform to ISO-3166.
- <table frame="all"><title>Sample Country Codes</title>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="50*"/>
+</table>
+<p>To see a full list of ISO-639 codes, go to <xref format="html"
+href="http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt" scope="external"><i>http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt</i></xref>.</p>
+<p>Country codes consist of two uppercase letters that conform to ISO-3166. The
+following table shows some examples.</p>
+<table frame="all">
+<title>Sample country codes</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="50*"/>
<colspec colname="2" colnum="2" colwidth="50*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Country Code</entry>
-<entry align="left" colname="2" valign="bottom">Description </entry>
+<row valign="bottom">
+<entry colname="1">Country Code</entry>
+<entry colname="2">Description </entry>
</row>
</thead>
<tbody>
@@ -97,7 +104,7 @@ href="http://www.ics.uci.edu/pub/ietf/ht
</row>
</tbody>
</tgroup>
-</table></p> <p>A copy of ISO-3166 can be found at <xref format="html" href="http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html"
+</table> <p>A copy of ISO-3166 can be found at <xref format="html" href="http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html"
scope="external"><i>http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html</i></xref>.</p> </section>
<section><title>Combining with other attributes</title> <p>The <i>territory</i> attribute
is used only when creating a database.</p><p>In the following example, the
Modified: db/derby/docs/trunk/src/ref/rrefattribtracelevel.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefattribtracelevel.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefattribtracelevel.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefattribtracelevel.dita Fri Apr 29 17:35:37 2011
@@ -25,15 +25,17 @@ for other attributes related to tracing.
</p></section>
<section><title>Tracing levels</title>
<p>The following table shows the available tracing levels and their values.</p>
-<table frame="all" pgwide="1"><title>Available tracing levels and values</title>
-<tgroup cols="3"><colspec colname="col1" colwidth="136*"/>
-<colspec colname="col2" colwidth="15*"/>
-<colspec colname="col3" colwidth="15*"/>
+<table frame="all">
+<title>Available tracing levels and values</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="136*"/>
+<colspec colname="col2" colnum="2" colwidth="15*"/>
+<colspec colname="col3" colnum="3" colwidth="15*"/>
<thead>
<row valign="bottom">
-<entry colname="col1">Trace level</entry>
-<entry colname="col2">Hex value</entry>
-<entry colname="col3">Decimal value</entry>
+<entry colname="col1">Trace Level</entry>
+<entry colname="col2">Hex Value</entry>
+<entry colname="col3">Decimal Value</entry>
</row>
</thead>
<tbody>
Modified: db/derby/docs/trunk/src/ref/rrefdbmlimits.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefdbmlimits.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefdbmlimits.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefdbmlimits.dita Fri Apr 29 17:35:37 2011
@@ -19,16 +19,24 @@ limitations under the License.
<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<reference id="rrefdbmlimits" xml:lang="en-us">
-<title>Limitations for database manager values</title>
+<title>Limitations for database values</title>
+<prolog><metadata>
+<keywords><indexterm>limitations<indexterm>database values</indexterm></indexterm>
+<indexterm>database<indexterm>limitations</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
<refbody>
-<table frame="all"><title>Database manager limitations</title><desc>The following
-table lists limitations on various Database Manager values in <ph conref="../conrefs.dita#prod/productshortname"></ph>.</desc>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="colspec0" colwidth="228*"/>
-<colspec colname="colspec1" colwidth="228*"/>
+<section><p>The following table lists limitations on various database
+values in <ph conref="../conrefs.dita#prod/productshortname"></ph>.</p>
+<table frame="all">
+<title>Database limitations</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="colspec0" colnum="1" colwidth="50*"/>
+<colspec colname="colspec1" colnum="2" colwidth="50*"/>
<thead>
-<row>
-<entry align="left" valign="top">Value</entry>
-<entry align="left" colname="colspec1" valign="top">Limit</entry>
+<row valign="bottom">
+<entry colname="colspec0">Value</entry>
+<entry colname="colspec1">Limit</entry>
</row>
</thead>
<tbody>
@@ -51,7 +59,7 @@ table lists limitations on various Datab
<row>
<entry colname="colspec0">Maximum tables referenced in an SQL statement or a
view</entry>
-<entry colname="colspec1">storage capacity</entry>
+<entry colname="colspec1">Storage capacity</entry>
</row>
<row>
<entry colname="colspec0">Maximum elements in a select list</entry>
@@ -59,7 +67,7 @@ view</entry>
</row>
<row>
<entry colname="colspec0">Maximum predicates in a WHERE or HAVING clause</entry>
-<entry colname="colspec1">storage capacity</entry>
+<entry colname="colspec1">Storage capacity</entry>
</row>
<row>
<entry colname="colspec0">Maximum number of columns in a GROUP BY clause</entry>
@@ -71,35 +79,35 @@ view</entry>
</row>
<row>
<entry colname="colspec0">Maximum number of prepared statements</entry>
-<entry colname="colspec1">storage capacity</entry>
+<entry colname="colspec1">Storage capacity</entry>
</row>
<row>
<entry colname="colspec0">Maximum declared cursors in a program</entry>
-<entry colname="colspec1">storage capacity</entry>
+<entry colname="colspec1">Storage capacity</entry>
</row>
<row>
<entry colname="colspec0">Maximum number of cursors opened at one time</entry>
-<entry colname="colspec1">storage capacity</entry>
+<entry colname="colspec1">Storage capacity</entry>
</row>
<row>
<entry colname="colspec0">Maximum number of constraints on a table</entry>
-<entry colname="colspec1">storage capacity</entry>
+<entry colname="colspec1">Storage capacity</entry>
</row>
<row>
<entry colname="colspec0">Maximum level of subquery nesting</entry>
-<entry colname="colspec1">storage capacity</entry>
+<entry colname="colspec1">Storage capacity</entry>
</row>
<row>
<entry colname="colspec0">Maximum number of subqueries in a single statement</entry>
-<entry colname="colspec1">storage capacity</entry>
+<entry colname="colspec1">Storage capacity</entry>
</row>
<row>
<entry colname="colspec0">Maximum number of rows changed in a unit of work</entry>
-<entry colname="colspec1">storage capacity</entry>
+<entry colname="colspec1">Storage capacity</entry>
</row>
<row>
<entry colname="colspec0">Maximum constants in a statement</entry>
-<entry colname="colspec1">storage capacity</entry>
+<entry colname="colspec1">Storage capacity</entry>
</row>
<row>
<entry colname="colspec0">Maximum depth of cascaded triggers </entry>
@@ -108,6 +116,7 @@ view</entry>
</tbody>
</tgroup>
</table>
+</section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefdttlimits.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefdttlimits.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefdttlimits.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefdttlimits.dita Fri Apr 29 17:35:37 2011
@@ -20,21 +20,30 @@ limitations under the License.
-->
<reference id="rrefdttlimits" xml:lang="en-us">
<title>DATE, TIME, and TIMESTAMP limitations</title>
+<prolog><metadata>
+<keywords><indexterm>limitations<indexterm>DATE, TIME, and TIMESTAMP values</indexterm></indexterm>
+<indexterm>DATE values<indexterm>limitations</indexterm></indexterm>
+<indexterm>TIME values<indexterm>limitations</indexterm></indexterm>
+<indexterm>TIMESTAMP values<indexterm>limitations</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
<refbody>
-<section>The following table lists limitations on date, time, and timestamp
-values in <ph conref="../conrefs.dita#prod/productshortname"></ph>.<table
-frame="all"><title>DATE, TIME, and TIMESTAMP limitations</title>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="colspec0" colwidth="228*"/>
-<colspec colname="colspec1" colwidth="228*"/>
+<section><p>The following table lists limitations on date, time, and timestamp
+values in <ph conref="../conrefs.dita#prod/productshortname"></ph>.</p>
+<table frame="all">
+<title>DATE, TIME, and TIMESTAMP limitations</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="colspec0" colnum="1" colwidth="50*"/>
+<colspec colname="colspec1" colnum="2" colwidth="50*"/>
<thead>
-<row>
-<entry align="left" valign="top">Value</entry>
-<entry align="left" colname="colspec1" valign="top">Limit</entry>
+<row valign="bottom">
+<entry colname="colspec0">Value</entry>
+<entry colname="colspec1">Limit</entry>
</row>
</thead>
<tbody>
<row>
-<entry colname="colspec0">Smallest DATE value </entry>
+<entry colname="colspec0">Smallest DATE value</entry>
<entry colname="colspec1">0001-01-01</entry>
</row>
<row>
Modified: db/derby/docs/trunk/src/ref/rrefidlengthlimits.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefidlengthlimits.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefidlengthlimits.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefidlengthlimits.dita Fri Apr 29 17:35:37 2011
@@ -19,82 +19,90 @@ limitations under the License.
-->
<reference id="rrefidlengthlimits" xml:lang="en-us">
<title>Limitations on identifier length </title>
+<prolog><metadata>
+<keywords><indexterm>limitations<indexterm>identifier lengths</indexterm></indexterm>
+<indexterm>identifiers<indexterm>length limitations</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
<refbody>
-<table frame="all"><title>Identifier length limitations</title><desc>The following
-table lists limitations on identifier lengths in <ph conref="../conrefs.dita#prod/productshortname"></ph>.</desc>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="colspec0" colwidth="228*"/>
-<colspec colname="colspec1" colwidth="228*"/>
+<section><p>The following table lists limitations on identifier lengths in
+<ph conref="../conrefs.dita#prod/productshortname"></ph>.</p>
+<table frame="all">
+<title>Identifier length limitations</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="colspec0" colnum="1" colwidth="50*"/>
+<colspec colname="colspec1" colnum="2" colwidth="50*"/>
<thead>
-<row>
-<entry align="left" valign="top">Identifier</entry>
-<entry align="left" colname="colspec1" valign="top">Maximum number of characters
-allowed</entry>
+<row valign="bottom">
+<entry colname="colspec0">Identifier</entry>
+<entry colname="colspec1">Maximum Number of Characters Allowed</entry>
</row>
</thead>
<tbody>
<row>
-<entry colname="colspec0">constraint name </entry>
+<entry colname="colspec0">Constraint name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">correlation name</entry>
+<entry colname="colspec0">Correlation name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">cursor name</entry>
+<entry colname="colspec0">Cursor name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">data source column name</entry>
+<entry colname="colspec0">Data source column name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">data source index name</entry>
+<entry colname="colspec0">Data source index name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">data source name</entry>
+<entry colname="colspec0">Data source name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">savepoint name</entry>
+<entry colname="colspec0">Savepoint name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">schema name</entry>
+<entry colname="colspec0">Schema name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">unqualified column name</entry>
+<entry colname="colspec0">Unqualified column name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">unqualified function name</entry>
+<entry colname="colspec0">Unqualified function name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">unqualified index name</entry>
+<entry colname="colspec0">Unqualified index name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">unqualified procedure name</entry>
+<entry colname="colspec0">Unqualified procedure name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">parameter name</entry>
+<entry colname="colspec0">Parameter name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">unqualified trigger name</entry>
+<entry colname="colspec0">Unqualified trigger name</entry>
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">unqualified table name, view name, stored procedure
-name </entry>
+<entry colname="colspec0">Unqualified table name, view name, stored procedure
+name</entry>
<entry colname="colspec1">128</entry>
</row>
</tbody>
</tgroup>
</table>
+</section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefjavsqlprst.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjavsqlprst.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjavsqlprst.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjavsqlprst.dita Fri Apr 29 17:35:37 2011
@@ -59,13 +59,16 @@ stream object or the user's own subclass
the data types shown in the following table. The word "Preferred" indicates the
preferred target data type for the type of stream. See
<xref href="rrefjdbc20377.dita#rrefjdbc20377/jdbc31241"></xref>.</p>
-<table frame="all" id="jdbc25312"><title>Streamable JDBC Data Types</title>
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="22*"/>
-<colspec colname="colspec0" colnum="2" colwidth="22*"/><colspec colname="2"
-colnum="3" colwidth="15*"/><colspec colname="3" colnum="4" colwidth="18*"/>
-<colspec colname="4" colnum="5" colwidth="20*"/>
+<table frame="all" id="jdbc25312">
+<title>Streamable JDBC data types</title>
+<tgroup cols="5" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="24*"/>
+<colspec colname="colspec0" colnum="2" colwidth="21*"/>
+<colspec colname="2" colnum="3" colwidth="18*"/>
+<colspec colname="3" colnum="4" colwidth="19*"/>
+<colspec colname="4" colnum="5" colwidth="18*"/>
<thead>
-<row>
+<row valign="bottom">
<entry colname="1">Column Data Type </entry>
<entry colname="colspec0">Corresponding Java Type</entry>
<entry colname="2">AsciiStream</entry>
@@ -90,7 +93,7 @@ colnum="3" colwidth="15*"/><colspec coln
</row>
<row>
<entry colname="1">VARCHAR</entry>
-<entry colname="colspec0"> </entry>
+<entry colname="colspec0">None</entry>
<entry colname="2">Yes</entry>
<entry colname="3">Yes</entry>
<entry colname="4">No</entry>
Modified: db/derby/docs/trunk/src/ref/rrefjdbc20377.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc20377.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc20377.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc20377.dita Fri Apr 29 17:35:37 2011
@@ -32,14 +32,16 @@ data type</indexterm></indexterm></keywo
</metadata></prolog>
<refbody>
<section><p>The following table shows the mapping of <i>java.sql.Types</i> to
-SQL types. <table frame="all" id="jdbc31241"><title>Mapping of java.sql.Types
-to SQL Types</title>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="30*"/>
+SQL types.</p>
+<table frame="all" id="jdbc31241"><title>Mapping of <i>java.sql.Types</i>
+to SQL types</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="30*"/>
<colspec colname="2" colnum="2" colwidth="70*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom"><b><i>java.sql.Types</i></b></entry>
-<entry align="left" colname="2" valign="bottom">SQL Types</entry>
+<row valign="bottom">
+<entry colname="1"><b><i>java.sql.Types</i></b></entry>
+<entry colname="2">SQL Types</entry>
</row>
</thead>
<tbody>
@@ -52,12 +54,12 @@ to SQL Types</title>
<entry colname="2">CHAR FOR BIT DATA</entry>
</row>
<row>
-<entry colname="1">BIT<sup><xref href="rrefjdbc20377.dita#rrefjdbc20377/chdhcccj">1</xref></sup></entry>
-<entry colname="2">CHAR FOR BIT DATA</entry>
+<entry colname="1">BLOB</entry>
+<entry colname="2">BLOB</entry>
</row>
<row>
-<entry colname="1">BLOB</entry>
-<entry colname="2">BLOB (JDBC 2.0 and up)</entry>
+<entry colname="1">BOOLEAN</entry>
+<entry colname="2">BOOLEAN</entry>
</row>
<row>
<entry colname="1">CHAR</entry>
@@ -65,7 +67,7 @@ to SQL Types</title>
</row>
<row>
<entry colname="1">CLOB</entry>
-<entry colname="2">CLOB (JDBC 2.0 and up)</entry>
+<entry colname="2">CLOB</entry>
</row>
<row>
<entry colname="1">DATE</entry>
@@ -81,7 +83,7 @@ to SQL Types</title>
</row>
<row>
<entry colname="1">FLOAT</entry>
-<entry colname="2">DOUBLE PRECISION<sup><xref href="rrefjdbc20377.dita#rrefjdbc20377/chdbdbhh">2</xref></sup></entry>
+<entry colname="2">DOUBLE PRECISION<sup><xref href="rrefjdbc20377.dita#rrefjdbc20377/chdbdbhh">1</xref></sup></entry>
</row>
<row>
<entry colname="1">INTEGER</entry>
@@ -112,7 +114,7 @@ to SQL Types</title>
<entry colname="2">SMALLINT</entry>
</row>
<row>
-<entry colname="1">SQLXML<sup><xref href="rrefjdbc20377.dita#rrefjdbc20377/sqlxml">3</xref></sup></entry>
+<entry colname="1">SQLXML<sup><xref href="rrefjdbc20377.dita#rrefjdbc20377/sqlxml">2</xref></sup></entry>
<entry colname="2">XML</entry>
</row>
<row>
@@ -134,7 +136,6 @@ to SQL Types</title>
</tbody>
</tgroup>
</table> <note othertype="Notes" type="other"><ol>
-<li id="chdhcccj">BIT is only valid in JDBC 2.0 and earlier environments.</li>
<li id="chdbdbhh">Values can be passed in using the FLOAT type code; however,
these are stored as DOUBLE PRECISION values, and so always have the type code
DOUBLE when retrieved.</li>
@@ -145,6 +146,6 @@ recognize the java.sql.Types.SQLXML data
operations for the XML data type. Support for XML and the related operators
is implemented only at the SQL layer. See <xref href="rrefsqljtypexml.dita#rrefsqljtypexml">XML
data types</xref> for more. </li>
-</ol> </note></p></section>
+</ol> </note></section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefjdbc23502.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc23502.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc23502.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc23502.dita Fri Apr 29 17:35:37 2011
@@ -32,15 +32,20 @@ is on, and not the current row of the <i
affecting</indexterm></indexterm></p></section>
<section><p>JDBC does not define the sort of rounding to use for <i>ResultSet.getBigDecimal</i>. <ph
conref="../conrefs.dita#prod/productshortname"></ph> uses <i>java.math.BigDecimal.ROUND_HALF_DOWN</i>.</p></section>
-<table frame="all"><title>Implementation Notes on <i>ResultSet</i> Methods</title>
-<tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="13*"/>
-<colspec colname="2" colnum="2" colwidth="36*"/><colspec colname="3" colnum="3"
-colwidth="51*"/>
+<section>
+<p>The following table describes features of <i>ResultSet</i> methods that are
+specific to <ph conref="../conrefs.dita#prod/productshortname"></ph>.</p>
+<table frame="all">
+<title>Implementation notes on <i>ResultSet</i> methods</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="13*"/>
+<colspec colname="2" colnum="2" colwidth="36*"/>
+<colspec colname="3" colnum="3" colwidth="51*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Returns</entry>
-<entry align="left" colname="2" valign="bottom">Signature</entry>
-<entry align="left" colname="3" valign="bottom">Implementation Notes</entry>
+<row valign="bottom">
+<entry colname="1">Returns</entry>
+<entry colname="2">Signature</entry>
+<entry colname="3">Implementation Notes</entry>
</row>
</thead>
<tbody>
@@ -91,6 +96,7 @@ object.</entry>
</tbody>
</tgroup>
</table>
+</section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefjdbc27734.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc27734.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc27734.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc27734.dita Fri Apr 29 17:35:37 2011
@@ -26,7 +26,7 @@ exceptions closing</indexterm><indexterm
</keywords>
</metadata></prolog>
<refbody>
-<section><p>A <ph conref="../conrefs.dita#prod/productshortname"></ph> <i>Connection</i> object
+<section><p>A <ph conref="../conrefs.dita#prod/productshortname"></ph> <i>Connection</i> object
is not garbage-collected until all other JDBC objects created from that connection
are explicitly closed or are themselves garbage-collected. Once the connection
is closed, no further JDBC requests can be made against objects created from
@@ -38,17 +38,20 @@ close and all other JDBC objects against
exceptions cause the <ph conref="../conrefs.dita#prod/productshortname"></ph> system
to shut down, which not only closes the connection but means that no new connections
should be created in the current JVM.</p></section>
-<section><p>
-<table pgwide="1" frame="all"><title>Implementation Notes on Connection
-Methods</title>
-<tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="11*"/>
-<colspec colname="2" colnum="2" colwidth="40*"/><colspec colname="3" colnum="3"
-colwidth="49*"/>
+<section>
+<p>The following table describes features of <i>Connection</i> methods that are
+specific to <ph conref="../conrefs.dita#prod/productshortname"></ph>.</p>
+<table>
+<title>Implementation notes on <i>Connection</i> methods</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="30*"/>
+<colspec colname="2" colnum="2" colwidth="40*"/>
+<colspec colname="3" colnum="3" colwidth="30*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Returns</entry>
-<entry align="left" colname="2" valign="bottom">Signature</entry>
-<entry align="left" colname="3" valign="bottom">Implementation Notes</entry>
+<row valign="bottom">
+<entry colname="1">Returns</entry>
+<entry colname="2">Signature</entry>
+<entry colname="3">Implementation Notes</entry>
</row>
</thead>
<tbody>
@@ -69,7 +72,6 @@ column within the target table of the IN
</tbody>
</tgroup>
</table>
-</p>
<p>See <xref href="crefjavstateautogen.dita#crefjavstateautogen"></xref> for
details on the use of the two forms of the <i>Connection.prepareStatement</i>
method shown in this table.</p>
Modified: db/derby/docs/trunk/src/ref/rrefjdbc38274.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc38274.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc38274.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc38274.dita Fri Apr 29 17:35:37 2011
@@ -25,14 +25,17 @@ limitations under the License.
<refbody>
<section><p><ph conref="../conrefs.dita#prod/productshortname"></ph> does
not track the source or updatability of columns in <i>ResultSets</i>, and
-so always returns the following constants for the following methods: <table
-pgwide="0" frame="all">
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="40*"/>
-<colspec colname="2" colnum="2" colwidth="60*"/>
+so always returns the constants shown for the methods listed in the
+following table.</p>
+<table frame="all">
+<title>Implementation notes on <i>ResultSet</i> methods</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="50*"/>
+<colspec colname="2" colnum="2" colwidth="50*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Method Name</entry>
-<entry align="left" colname="2" valign="bottom">Value</entry>
+<row valign="bottom">
+<entry colname="1">Method Name</entry>
+<entry colname="2">Value</entry>
</row>
</thead>
<tbody>
@@ -50,6 +53,6 @@ pgwide="0" frame="all">
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefjdbc40794.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc40794.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc40794.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc40794.dita Fri Apr 29 17:35:37 2011
@@ -27,15 +27,19 @@ limitations under the License.
not implement the <i>setEscapeProcessing</i> method of <i>java.sql.Statement</i>.
In addition, the <i>cancel</i> method raises a "Feature not supported"
exception.</p>
-<table frame="all"><title>Implementation Notes on Statement Methods</title>
-<tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="25*"/>
-<colspec colname="2" colnum="2" colwidth="31*"/><colspec colname="3" colnum="3"
-colwidth="44*"/>
+<p>The following table describes features of <i>Statement</i> methods that are
+specific to <ph conref="../conrefs.dita#prod/productshortname"></ph>.</p>
+<table frame="all">
+<title>Implementation notes on <i>Statement</i> methods</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="20*"/>
+<colspec colname="2" colnum="2" colwidth="40*"/>
+<colspec colname="3" colnum="3" colwidth="40*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Returns</entry>
-<entry align="left" colname="2" valign="bottom">Signature</entry>
-<entry align="left" colname="3" valign="bottom">Implementation Notes</entry>
+<row valign="bottom">
+<entry colname="1">Returns</entry>
+<entry colname="2">Signature</entry>
+<entry colname="3">Implementation Notes</entry>
</row>
</thead>
<tbody>
Modified: db/derby/docs/trunk/src/ref/rrefjdbc75719.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc75719.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc75719.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc75719.dita Fri Apr 29 17:35:37 2011
@@ -19,14 +19,14 @@ limitations under the License.
<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<reference id="rrefjdbc75719" xml:lang="en-us">
-<title>CallableStatements and INOUT Parameters </title>
+<title>CallableStatements and INOUT parameters </title>
<prolog><metadata>
<keywords><indexterm>java.sql.CallableStatement<indexterm>and INOUT parameters</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
<section><p>INOUT parameters map to an <i>array</i> of the parameter type
-in Java. (The method must take an array as its parameter.) This conforms to
+in the Java programming language. (The method must take an array as its parameter.) This conforms to
the recommendations of the SQL standard.</p></section>
<section><p>Given the following example: <codeblock expanse="column"><b>CallableStatement call = conn.prepareCall(
"{CALL doubleMyInt(?)}");
@@ -41,34 +41,48 @@ of <codeph>ints</codeph>. Here is sample
expanse="column"><b>public static void doubleMyInt(int[] i) {
i[0] *=2;
<ph>/* <ph conref="../conrefs.dita#prod/productshortname"></ph> returns the first element of the array.*/</ph>
-}</b></codeblock> <note>The return value is <i>not</i> wrapped in an array
-even though the parameter to the method is.</note> <table frame="all"><title>INOUT
-Parameter Type Correspondence</title>
-<tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="39*"/>
-<colspec colname="2" colnum="2" colwidth="27*"/><colspec colname="3" colnum="3"
-colwidth="33*"/>
+}</b></codeblock></p> <note>The return value is <i>not</i> wrapped in an array
+even though the parameter to the method is.</note>
+<p>The following table shows the parameter array types and return types that
+correspond to JDBC types.</p>
+<table frame="all">
+<title>INOUT parameter type correspondence</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="34*"/>
+<colspec colname="2" colnum="2" colwidth="33*"/>
+<colspec colname="3" colnum="3" colwidth="33*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">JDBC Type</entry>
-<entry align="left" colname="2" valign="bottom">Array Type for Method Parameter</entry>
-<entry align="left" colname="3" valign="bottom">Value and Return Type</entry>
+<row valign="bottom">
+<entry colname="1">JDBC Type</entry>
+<entry colname="2">Array Type for Method Parameter</entry>
+<entry colname="3">Value and Return Type</entry>
</row>
</thead>
<tbody>
<row>
<entry colname="1">BIGINT</entry>
-<entry colname="2">long[]</entry>
-<entry colname="3">long</entry>
+<entry colname="2"><i>long[]</i></entry>
+<entry colname="3"><i>long</i></entry>
</row>
<row>
<entry colname="1">BINARY</entry>
-<entry colname="2">byte[][]</entry>
-<entry colname="3">byte[]</entry>
+<entry colname="2"><i>byte[][]</i></entry>
+<entry colname="3"><i>byte[]</i></entry>
+</row>
+<row>
+<entry colname="1">BLOB</entry>
+<entry colname="2"><i>java.sql.Blob[]</i></entry>
+<entry colname="3"><i>java.sql.Blob</i></entry>
+</row>
+<row>
+<entry colname="1">BOOLEAN</entry>
+<entry colname="2"><i>boolean[]</i></entry>
+<entry colname="3"><i>boolean</i></entry>
</row>
<row>
-<entry colname="1">BIT</entry>
-<entry colname="2">boolean[]</entry>
-<entry colname="3">boolean</entry>
+<entry colname="1">CLOB</entry>
+<entry colname="2"><i>java.sql.Clob[]</i></entry>
+<entry colname="3"><i>java.sql.Clob</i></entry>
</row>
<row>
<entry colname="1">DATE</entry>
@@ -77,33 +91,33 @@ colwidth="33*"/>
</row>
<row>
<entry colname="1">DOUBLE</entry>
-<entry colname="2">double[]</entry>
-<entry colname="3">double</entry>
+<entry colname="2"><i>double[]</i></entry>
+<entry colname="3"><i>double</i></entry>
</row>
<row>
<entry colname="1">FLOAT</entry>
-<entry colname="2">double[]</entry>
-<entry colname="3">double</entry>
+<entry colname="2"><i>double[]</i></entry>
+<entry colname="3"><i>double</i></entry>
</row>
<row>
<entry colname="1">INTEGER</entry>
-<entry colname="2">int[]</entry>
-<entry colname="3">int</entry>
+<entry colname="2"><i>int[]</i></entry>
+<entry colname="3"><i>int</i></entry>
</row>
<row>
<entry colname="1">LONGVARBINARY</entry>
-<entry colname="2">byte[][]</entry>
-<entry colname="3">byte[]</entry>
+<entry colname="2"><i>byte[][]</i></entry>
+<entry colname="3"><i>byte[]</i></entry>
</row>
<row>
<entry colname="1">REAL</entry>
-<entry colname="2">float[]</entry>
-<entry colname="3">float</entry>
+<entry colname="2"><i>float[]</i></entry>
+<entry colname="3"><i>float</i></entry>
</row>
<row>
<entry colname="1">SMALLINT</entry>
-<entry colname="2">short[]</entry>
-<entry colname="3">short</entry>
+<entry colname="2"><i>short[]</i></entry>
+<entry colname="3"><i>short</i></entry>
</row>
<row>
<entry colname="1">TIME</entry>
@@ -117,8 +131,8 @@ colwidth="33*"/>
</row>
<row>
<entry colname="1">VARBINARY</entry>
-<entry colname="2">byte[][]</entry>
-<entry colname="3">byte[]</entry>
+<entry colname="2"><i>byte[][]</i></entry>
+<entry colname="3"><i>byte[]</i></entry>
</row>
<row>
<entry colname="1">OTHER</entry>
@@ -126,13 +140,13 @@ colwidth="33*"/>
<entry colname="3"><i>yourType</i></entry>
</row>
<row>
-<entry colname="1">JAVA_OBJECT (only valid in Java2/JDBC 2.0 environments)</entry>
+<entry colname="1">JAVA_OBJECT</entry>
<entry colname="2"><i>yourType[]</i></entry>
<entry colname="3"><i>yourType</i></entry>
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
<section><p>Register the output type of the parameter before executing the
call. For INOUT parameters, it is good practice to register the output parameter
before setting its input value.</p></section>
Modified: db/derby/docs/trunk/src/ref/rrefjdbc96386.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc96386.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc96386.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc96386.dita Fri Apr 29 17:35:37 2011
@@ -68,15 +68,20 @@ are not supported.</li>
</ul></p></section>
<section><p><b>Recommendation:</b> Because the lifespan of a <i>java.sql.Blob</i> or <i>java.sql.Clob</i> ends
when the transaction commits, turn off auto-commit with the <i>java.sql.Blob</i> or <i>java.sql.Clob</i> features.</p></section>
-<table frame="all"><title>Implementation Notes on <i>java.sql.Blob</i> Methods</title>
-<tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="13*"/>
-<colspec colname="2" colnum="2" colwidth="32*"/><colspec colname="3" colnum="3"
-colwidth="55*"/>
+<section>
+<p>The following table describes features of <i>java.sql.Blob</i> methods that
+are specific to <ph conref="../conrefs.dita#prod/productshortname"></ph>.</p>
+<table frame="all">
+<title>Implementation notes on <i>java.sql.Blob</i> methods</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="14*"/>
+<colspec colname="2" colnum="2" colwidth="36*"/>
+<colspec colname="3" colnum="3" colwidth="50*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Returns</entry>
-<entry align="left" colname="2" valign="bottom">Signature</entry>
-<entry align="left" colname="3" valign="bottom">Implementation Notes</entry>
+<row valign="bottom">
+<entry colname="1">Returns</entry>
+<entry colname="2">Signature</entry>
+<entry colname="3">Implementation Notes</entry>
</row>
</thead>
<tbody>
@@ -102,15 +107,19 @@ to read the first byte of <i>pattern</i>
</tbody>
</tgroup>
</table>
-<table frame="all"><title>Implementation Notes on <i>java.sql.Clob</i> Methods</title>
-<tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="14*"/>
-<colspec colname="2" colnum="2" colwidth="36*"/><colspec colname="3" colnum="3"
-colwidth="50*"/>
+<p>The following table describes features of <i>java.sql.Clob</i> methods that
+are specific to <ph conref="../conrefs.dita#prod/productshortname"></ph>.</p>
+<table frame="all">
+<title>Implementation notes on <i>java.sql.Clob</i> methods</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="14*"/>
+<colspec colname="2" colnum="2" colwidth="36*"/>
+<colspec colname="3" colnum="3" colwidth="50*"/>
<thead>
-<row>
-<entry align="left" colname="1" valign="bottom">Returns</entry>
-<entry align="left" colname="2" valign="bottom">Signature</entry>
-<entry align="left" colname="3" valign="bottom">Implementation Notes</entry>
+<row valign="bottom">
+<entry colname="1">Returns</entry>
+<entry colname="2">Signature</entry>
+<entry colname="3">Implementation Notes</entry>
</row>
</thead>
<tbody>
@@ -136,5 +145,6 @@ to read the first char of <i>searchStr.<
</tbody>
</tgroup>
</table>
+</section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rreflimitsxml.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreflimitsxml.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rreflimitsxml.dita (original)
+++ db/derby/docs/trunk/src/ref/rreflimitsxml.dita Fri Apr 29 17:35:37 2011
@@ -21,19 +21,22 @@ limitations under the License.
<reference id="rreflimitsxml" xml:lang="en-us">
<title>XML limitations</title>
<prolog><metadata>
-<keywords><indexterm>XML data type<indexterm>limitations</indexterm></indexterm>
+<keywords><indexterm>limitations<indexterm>XML data type</indexterm></indexterm>
+<indexterm>XML data type<indexterm>limitations</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<section><p>The following table lists the limitations on XML data types in <ph
-conref="../conrefs.dita#prod/productshortname"></ph>.</p></section>
-<table frame="all"><title>XML limitations</title>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="colspec0" colwidth="228*"/>
-<colspec colname="colspec1" colwidth="228*"/>
+<section><p>The following table lists limitations on XML data types in <ph
+conref="../conrefs.dita#prod/productshortname"></ph>.</p>
+<table frame="all">
+<title>XML limitations</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="colspec0" colnum="1" colwidth="50*"/>
+<colspec colname="colspec1" colnum="2" colwidth="50*"/>
<thead>
-<row>
-<entry align="left" valign="top">Issue</entry>
-<entry align="left" colname="colspec1" valign="top">Limitation</entry>
+<row valign="bottom">
+<entry colname="colspec0">Issue</entry>
+<entry colname="colspec1">Limitation</entry>
</row>
</thead>
<tbody>
@@ -53,5 +56,6 @@ your classpath. See "XML data types and
</tbody>
</tgroup>
</table>
+</section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefnumericlimits.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefnumericlimits.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefnumericlimits.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefnumericlimits.dita Fri Apr 29 17:35:37 2011
@@ -20,20 +20,23 @@ limitations under the License.
-->
<reference id="rrefnumericlimits" xml:lang="en-us">
<title>Numeric limitations</title>
-<shortdesc>There are limitations on the numeric values in <ph conref="../conrefs.dita#prod/productshortname"></ph>.</shortdesc>
<prolog><metadata>
<keywords><indexterm>limitations<indexterm>numeric values</indexterm></indexterm>
<indexterm>data types<indexterm>numeric limitations</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
-<table frame="all"><title>Numeric limitations</title>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="colspec0" colwidth="228*"/>
-<colspec colname="colspec1" colwidth="228*"/>
+<section><p>The following lists limitations on the numeric values in
+<ph conref="../conrefs.dita#prod/productshortname"></ph>.</p>
+<table frame="all">
+<title>Numeric limitations</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="colspec0" colnum="1" colwidth="50*"/>
+<colspec colname="colspec1" colnum="2" colwidth="50*"/>
<thead>
-<row>
-<entry align="left" valign="top">Value</entry>
-<entry align="left" colname="colspec1" valign="top">Limit</entry>
+<row valign="bottom">
+<entry colname="colspec0">Value</entry>
+<entry colname="colspec1">Limit</entry>
</row>
</thead>
<tbody>
@@ -100,5 +103,6 @@ limitations under the License.
</tbody>
</tgroup>
</table>
+</section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsistabs12085.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs12085.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs12085.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs12085.dita Fri Apr 29 17:35:37 2011
@@ -20,20 +20,31 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsistabs12085" xml:lang="en-us">
<title>SYSSCHEMAS system table</title>
+<shortdesc>The SYSSCHEMAS table describes the schemas within the current
+database.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system tables<indexterm>SYSSCHEMAS</indexterm></indexterm>
+<indexterm>schemas<indexterm>SYSSCHEMAS system table</indexterm></indexterm>
+<indexterm>SYSSCHEMAS system table</indexterm></keywords>
+</metadata></prolog>
<refbody>
-<section><p>Describes the schemas within the current database.
-<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 SYSSCHEMAS system table.</p>
+<table>
+<title>SYSSCHEMAS 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,25 +53,25 @@ colnum="5" colwidth="35*"/>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">unique identifier for the schema</entry>
+<entry colname="5">Unique identifier for the schema</entry>
</row>
<row>
<entry colname="1">SCHEMANAME</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
<entry colname="4">false</entry>
-<entry colname="5">schema name</entry>
+<entry colname="5">Schema name</entry>
</row>
<row>
<entry colname="1">AUTHORIZATIONID</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
<entry colname="4">false</entry>
-<entry colname="5">the authorization identifier of the owner of the schema</entry>
+<entry colname="5">The authorization identifier of the owner of the schema</entry>
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsistabs12813.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs12813.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs12813.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs12813.dita Fri Apr 29 17:35:37 2011
@@ -22,24 +22,35 @@ limitations under the License.
<title>SYSDEPENDS system table</title>
<shortdesc>The SYSDEPENDS table stores the dependency relationships between
persistent objects in the database.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system tables<indexterm>SYSDEPENDS</indexterm></indexterm>
+<indexterm>dependency relationships<indexterm>SYSDEPENDS system table</indexterm></indexterm>
+<indexterm>SYSDEPENDS system table</indexterm></keywords>
+</metadata></prolog>
<refbody>
<section><p>Persistent objects can be dependents or providers. Dependents
are objects that depend on other objects. Providers are objects that other
-objects depend on. <ul>
+objects depend on.</p>
+<ul>
<li>Dependents are views, constraints, or triggers.</li>
<li>Providers are tables, conglomerates, constraints, or privileges.</li>
-</ul></p><p><table frame="all" pgwide="1">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="28*"/>
-<colspec colname="2" colnum="2" colwidth="24*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="13*"/><colspec colname="5"
-colnum="5" colwidth="24*"/>
+</ul>
+<p>The following table shows the contents of the SYSDEPENDS system table.</p>
+<table>
+<title>SYSDEPENDS 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>
@@ -52,7 +63,9 @@ colnum="5" colwidth="24*"/>
</row>
<row>
<entry colname="1">DEPENDENTFINDER</entry>
-<entry colname="2"><i>org.apache.derby.catalog. DependableFinder</i> <p>This class
+<entry colname="2"><i>org.apache.derby.
+catalog.
+DependableFinder</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>
@@ -68,15 +81,17 @@ that is the dependent</entry>
</row>
<row>
<entry colname="1">PROVIDERFINDER</entry>
-<entry colname="2"><i>org.apache.derby.catalog. DependableFinder</i> <p>This class is
+<entry colname="2"><i>org.apache.derby.
+catalog.
+DependableFinder</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 system type that describes the table, conglomerate, constraint,
-and privilege that is the provider</entry>
+<entry colname="5">A system type that describes the table, conglomerate,
+constraint, and privilege that is the provider</entry>
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsistabs13420.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs13420.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs13420.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs13420.dita Fri Apr 29 17:35:37 2011
@@ -20,23 +20,35 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsistabs13420" xml:lang="en-us">
<title>SYSFOREIGNKEYS system table</title>
+<shortdesc>The SYSFOREIGNKEYS table describes the information specific to
+foreign key constraints in the current database.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system tables<indexterm>SYSFOREIGNKEYS</indexterm></indexterm>
+<indexterm>foreign key constraints<indexterm>SYSFOREIGNKEYS system table</indexterm></indexterm>
+<indexterm>SYSFOREIGNKEYS system table</indexterm></keywords>
+</metadata></prolog>
<refbody>
-<section><p>Describes the information specific to foreign key constraints
-in the current database.</p></section>
-<section><p><ph conref="../conrefs.dita#prod/productshortname"></ph> generates
-a backing index for each foreign key constraint; the name of this index is
-the same as SYSFOREIGNKEYS.CONGLOMERATEID. <table pgwide="1" frame="all">
-<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*"/>
+<section>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph> generates
+a backing index for each foreign key constraint. The name of this index is
+the same as SYSFOREIGNKEYS.CONGLOMERATEID.</p>
+<p>The following table shows the contents of the SYSFOREIGNKEYS system
+table.</p>
+<table>
+<title>SYSFOREIGNKEYS 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>
@@ -45,44 +57,46 @@ colnum="5" colwidth="38*"/>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">unique identifier for the foreign key constraint (join
-with <i>SYSCONSTRAINTS. CONSTRAINTID</i>)</entry>
+<entry colname="5">Unique identifier for the foreign key constraint (join
+with SYSCONSTRAINTS.CONSTRAINTID)</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 index backing up the foreign key
-constraint (join with <i>SYSCONGLOMERATES. CONGLOMERATEID</i>)</entry>
+<entry colname="5">Unique identifier for index backing up the foreign key
+constraint (join with SYSCONGLOMERATES.
+CONGLOMERATEID)</entry>
</row>
<row>
<entry colname="1">KEYCONSTRAINTID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">unique identifier for the primary key or unique constraint
-referenced by this foreign key (<i>SYSKEYS.CONSTRAINTID</i> or <i>SYSCONSTRAINTS.
-CONSTRAINTID</i>)</entry>
+<entry colname="5">Unique identifier for the primary key or unique constraint
+referenced by this foreign key (SYSKEYS.CONSTRAINTID or
+SYSCONSTRAINTS.CONSTRAINTID)</entry>
</row>
<row>
<entry colname="1">DELETERULE</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5"><i>R</i> for NO ACTION (default), <i>S</i> for RESTRICT, <i>C</i> for
-CASCADE, <i>U</i> for SET NULL</entry>
+<entry colname="5"><i>'R'</i> for NO ACTION (default), <i>'S'</i> for RESTRICT,
+<i>'C'</i> for CASCADE, <i>'U'</i> for SET NULL</entry>
</row>
<row>
<entry colname="1">UPDATERULE</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5"><i>R for NO ACTION(default), S</i> for restrict</entry>
+<entry colname="5"><i>'R'</i> for NO ACTION (default), <i>'S'</i> for
+RESTRICT</entry>
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsistabs22441.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs22441.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs22441.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs22441.dita Fri Apr 29 17:35:37 2011
@@ -28,18 +28,22 @@ current database.</shortdesc>
</metadata></prolog>
<refbody>
<section>
-<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="23*"/><colspec colname="3" colnum="3"
-colwidth="10*"/><colspec colname="4" colnum="4" colwidth="11*"/><colspec colname="5"
-colnum="5" colwidth="26*"/>
+<p>The following table shows the contents of the SYSCOLUMNS system table.</p>
+<table>
+<title>SYSCOLUMNS 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>
@@ -48,7 +52,8 @@ colnum="5" colwidth="26*"/>
<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">COLUMNNAME</entry>
@@ -66,7 +71,8 @@ colnum="5" colwidth="26*"/>
</row>
<row>
<entry colname="1">COLUMNDATATYPE</entry>
-<entry colname="2"><i>org.apache.derby.catalog.
+<entry colname="2"><i>org.apache.derby.
+catalog.
TypeDescriptor</i> <p>This class
is not part of the public API.</p></entry>
<entry colname="3">2,147,483,647</entry>
@@ -81,16 +87,17 @@ SYS.SYSALIASES.</entry>
<entry colname="2"><i>java.io.Serializable</i></entry>
<entry colname="3">2,147,483,647</entry>
<entry colname="4">true</entry>
-<entry colname="5">For tables, describes default value of the column. The <i>toString()</i> method
-on the object stored in the table returns the text of the default value as
-specified in the CREATE TABLE or ALTER TABLE statement.</entry>
+<entry colname="5">For tables, describes default value of the column. The
+<i>toString()</i> method on the object stored in the table returns the text of
+the default value as specified in the CREATE TABLE or ALTER TABLE
+statement.</entry>
</row>
<row>
<entry colname="1">COLUMNDEFAULTID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">true</entry>
-<entry colname="5">Unique identifier for the default value </entry>
+<entry colname="5">Unique identifier for the default value</entry>
</row>
<row>
<entry colname="1">AUTOINCREMENTVALUE</entry>
@@ -113,8 +120,8 @@ column</entry>
<entry colname="2">BIGINT</entry>
<entry colname="3">19</entry>
<entry colname="4">true</entry>
-<entry colname="5">Amount column value is automatically incremented (if specified),
-if the column is an identity column</entry>
+<entry colname="5">Amount column value is automatically incremented (if
+specified), if the column is an identity column</entry>
</row>
</tbody>
</tgroup>
Modified: db/derby/docs/trunk/src/ref/rrefsistabs23241.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs23241.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs23241.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs23241.dita Fri Apr 29 17:35:37 2011
@@ -20,21 +20,33 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsistabs23241" xml:lang="en-us">
<title>SYSCONSTRAINTS system table</title>
+<shortdesc>The SYSCONSTRAINTS table describes the information common to all
+types of constraints within the current database (currently, this includes
+primary key, unique, foreign key, and check constraints).</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system tables<indexterm>SYSCONSTRAINTS</indexterm></indexterm>
+<indexterm>constraints<indexterm>SYSCONSTRAINTS system table</indexterm></indexterm>
+<indexterm>SYSCONSTRAINTS system table</indexterm></keywords>
+</metadata></prolog>
<refbody>
-<section><p>Describes the information common to all types of constraints within
-the current database (currently, this includes primary key, unique, foreign
-key, and check constraints). <table pgwide="1" frame="all">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="27*"/>
-<colspec colname="2" colnum="2" colwidth="15*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="12*"/><colspec colname="5"
-colnum="5" colwidth="35*"/>
+<section>
+<p>The following table shows the contents of the SYSCONSTRAINTS system
+table.</p>
+<table>
+<title>SYSCONSTRAINTS 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>
@@ -43,21 +55,21 @@ colnum="5" colwidth="35*"/>
<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">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">CONSTRAINTNAME</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
<entry colname="4">false</entry>
-<entry colname="5">constraint name (internally generated if not specified
+<entry colname="5">Constraint name (internally generated if not specified
by user)</entry>
</row>
<row>
@@ -65,36 +77,35 @@ by user)</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5"><i>P</i> (primary key), <i>U</i> (unique), <i>C</i> (check),
-or <i>F</i> (foreign key)</entry>
+<entry colname="5"><i>'P'</i> (primary key), <i>'U'</i> (unique), <i>'C'</i>
+(check), or <i>'F'</i> (foreign key)</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">identifier for schema that the constraint belongs to (join
-with <i>SYSSCHEMAS.SCHEMAID</i>)</entry>
+<entry colname="5">Identifier for schema that the constraint belongs to (join
+with SYSSCHEMAS.SCHEMAID)</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"><i>E</i> for enabled, <i>D</i> for disabled</entry>
+<entry colname="5"><i>'E'</i> for enabled, <i>'D'</i> for disabled</entry>
</row>
<row>
<entry colname="1">REFERENCECOUNT</entry>
<entry colname="2">INTEGER</entry>
<entry colname="3">10</entry>
<entry colname="4">false</entry>
-<entry colname="5">the count of the number of foreign key constraints that
+<entry colname="5">The count of the number of foreign key constraints that
reference this constraint; this number can be greater than zero only for PRIMARY
KEY and UNIQUE constraints</entry>
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
</refbody>
</reference>
-
Modified: db/derby/docs/trunk/src/ref/rrefsistabs24045.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs24045.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs24045.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs24045.dita Fri Apr 29 17:35:37 2011
@@ -20,20 +20,31 @@ limitations under the License.
-->
<reference id="rrefsistabs24045" xml:lang="en-us">
<title>SYSVIEWS system table</title>
+<shortdesc>The SYSVIEWS table describes the view definitions within the current
+database.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system tables<indexterm>SYSVIEWS</indexterm></indexterm>
+<indexterm>views<indexterm>SYSVIEWS system table</indexterm></indexterm>
+<indexterm>SYSVIEWS system table</indexterm></keywords>
+</metadata></prolog>
<refbody>
-<section><p>Describes the view definitions within the current database. <table
-pgwide="1" frame="all">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="24*"/>
-<colspec colname="2" colnum="2" colwidth="23*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
-colnum="5" colwidth="29*"/>
+<section>
+<p>The following table shows the contents of the SYSVIEWS system table.</p>
+<table>
+<title>SYSVIEWS 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,32 +53,32 @@ colnum="5" colwidth="29*"/>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">unique identifier for the view (called TABLEID since it
-is joined with column of that name in SYSTABLES)</entry>
+<entry colname="5">Unique identifier for the view (join with
+SYSTABLES.TABLEID)</entry>
</row>
<row>
<entry colname="1">VIEWDEFINITION</entry>
<entry colname="2">LONG VARCHAR</entry>
<entry colname="3">32,700</entry>
<entry colname="4">false</entry>
-<entry colname="5">text of view definition</entry>
+<entry colname="5">Text of view definition</entry>
</row>
<row>
<entry colname="1">CHECKOPTION</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5">'<i>N</i>' (check option not supported yet)</entry>
+<entry colname="5"><i>'N'</i> (check option not supported yet)</entry>
</row>
<row>
<entry colname="1">COMPILATIONSCHEMAID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">id of the schema containing the view</entry>
+<entry colname="5">ID of the schema containing the view</entry>
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsistabs24269.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs24269.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs24269.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs24269.dita Fri Apr 29 17:35:37 2011
@@ -20,20 +20,32 @@ limitations under the License.
-->
<reference id="rrefsistabs24269" xml:lang="en-us">
<title>SYSTABLES system table</title>
+<shortdesc>The SYSTABLES table describes the tables and views within the current
+database.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system tables<indexterm>SYSTABLES</indexterm></indexterm>
+<indexterm>tables<indexterm>SYSTABLES system table</indexterm></indexterm>
+<indexterm>views<indexterm>SYSTABLES system table</indexterm></indexterm>
+<indexterm>SYSTABLES system table</indexterm></keywords>
+</metadata></prolog>
<refbody>
-<section><p>Describes the tables and views within the current database. <table
-pgwide="1" frame="all">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="19*"/>
-<colspec colname="2" colnum="2" colwidth="16*"/><colspec colname="3" colnum="3"
-colwidth="11*"/><colspec colname="4" colnum="4" colwidth="13*"/><colspec colname="5"
-colnum="5" colwidth="41*"/>
+<section>
+<p>The following table shows the contents of the SYSTABLES system table.</p>
+<table>
+<title>SYSTABLES 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>
@@ -42,45 +54,41 @@ colnum="5" colwidth="41*"/>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">unique identifier for table or view</entry>
+<entry colname="5">Unique identifier for table or view</entry>
</row>
<row>
<entry colname="1">TABLENAME</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
<entry colname="4">false</entry>
-<entry colname="5">table or view name</entry>
+<entry colname="5">Table or view name</entry>
</row>
<row>
<entry colname="1">TABLETYPE</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5">'<i>S</i>' (system table), '<i>T</i>' (user table), '<i>A</i>' (synonym), or
-'<i>V</i>' (view)</entry>
+<entry colname="5"><i>'S'</i> (system table), <i>'T'</i> (user table),
+<i>'A'</i> (synonym), or <i>'V'</i> (view)</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">schema id for the table or view</entry>
+<entry colname="5">Schema ID for the table or view</entry>
</row>
<row>
<entry colname="1">LOCKGRANULARITY</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5">Indicates the lock granularity for the table <dl><dlentry>
-<dt>'<i>T</i>'</dt>
-<dd>(table level locking)</dd>
-</dlentry><dlentry>
-<dt>'<i>R</i>' </dt>
-<dd>(row level locking, the default)</dd>
-</dlentry></dl></entry>
+<entry colname="5">Lock granularity for the table: <i>'T'</i> (table level
+locking) or <i>'R'</i> (row level locking, the default)</entry>
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table>
+</section>
</refbody>
</reference>
Modified: db/derby/docs/trunk/src/ref/rrefsistabs26665.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs26665.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs26665.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs26665.dita Fri Apr 29 17:35:37 2011
@@ -29,18 +29,22 @@ the current database.</shortdesc>
</metadata></prolog>
<refbody>
<section>
-<table pgwide="1" frame="all">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="27*"/>
-<colspec colname="2" colnum="2" colwidth="24*"/><colspec colname="3" colnum="3"
-colwidth="9*"/><colspec colname="4" colnum="4" colwidth="13*"/><colspec colname="5"
-colnum="5" colwidth="27*"/>
+<p>The following table shows the contents of the SYSCHECKS system table.</p>
+<table>
+<title>SYSCHECKS 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 +64,9 @@ colnum="5" colwidth="27*"/>
</row>
<row>
<entry colname="1">REFERENCEDCOLUMNS</entry>
-<entry colname="2"><i>org.apache.derby.catalog. ReferencedColumns</i> <p>This class
+<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>
<entry colname="4">false</entry>
Modified: db/derby/docs/trunk/src/ref/rrefsistabs28114.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs28114.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs28114.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs28114.dita Fri Apr 29 17:35:37 2011
@@ -29,18 +29,22 @@ user-defined types in the database.</sho
</metadata></prolog>
<refbody>
<section>
-<table pgwide="1" frame="all">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="18*"/>
-<colspec colname="2" colnum="2" colwidth="29*"/><colspec colname="3" colnum="3"
-colwidth="10*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
-colnum="5" colwidth="29*"/>
+<p>The following table shows the contents of the SYSALIASES system table.</p>
+<table>
+<title>SYSALIASES 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>
@@ -94,8 +98,8 @@ user-defined type)</entry>
<entry colname="2">BOOLEAN</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5"><i>true</i> (system supplied or built-in alias) <p><i>false</i> (alias
-created by a user)</p></entry>
+<entry colname="5"><i>true</i> (system supplied or built-in alias)
+<p><i>false</i> (alias created by a user)</p></entry>
</row>
<row>
<entry colname="1">ALIASINFO</entry>
Modified: db/derby/docs/trunk/src/ref/rrefsistabs33768.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsistabs33768.dita?rev=1097897&r1=1097896&r2=1097897&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsistabs33768.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsistabs33768.dita Fri Apr 29 17:35:37 2011
@@ -20,20 +20,33 @@ limitations under the License.
"../dtd/reference.dtd">
<reference id="rrefsistabs33768" xml:lang="en-us">
<title>SYSSTATEMENTS system table</title>
+<shortdesc>The SYSSTATEMENTS table describes the prepared statements in
+the database.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system tables<indexterm>SYSSTATEMENTS</indexterm></indexterm>
+<indexterm>statements<indexterm>SYSSTATEMENTS system table</indexterm></indexterm>
+<indexterm>prepared statements<indexterm>SYSSTATEMENTS system table</indexterm></indexterm>
+<indexterm>SYSSTATEMENTS system table</indexterm></keywords>
+</metadata></prolog>
<refbody>
-<section><p>Contains one row per stored prepared statement. <table pgwide="1"
-frame="all">
-<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="30*"/>
-<colspec colname="2" colnum="2" colwidth="21*"/><colspec colname="3" colnum="3"
-colwidth="9*"/><colspec colname="4" colnum="4" colwidth="13*"/><colspec colname="5"
-colnum="5" colwidth="26*"/>
+<section>
+<p>The table contains one row per stored prepared statement.</p>
+<p>The following table shows the contents of the SYSSTATEMENTS system table.</p>
+<table>
+<title>SYSSTATEMENTS 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,68 +55,68 @@ colnum="5" colwidth="26*"/>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">unique identifier for the statement</entry>
+<entry colname="5">Unique identifier for the statement</entry>
</row>
<row>
<entry colname="1">STMTNAME</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
<entry colname="4">false</entry>
-<entry colname="5">name of the statement</entry>
+<entry colname="5">Name of the statement</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">the schema in which the statement resides</entry>
+<entry colname="5">The schema in which the statement resides</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">always 'S'</entry>
+<entry colname="5">Always <i>'S'</i></entry>
</row>
<row>
<entry colname="1">VALID</entry>
<entry colname="2">BOOLEAN</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5">TRUE if valid, FALSE if invalid</entry>
+<entry colname="5">Whether or not the statement is valid</entry>
</row>
<row>
<entry colname="1">TEXT</entry>
<entry colname="2">LONG VARCHAR</entry>
<entry colname="3">32,700</entry>
<entry colname="4">false</entry>
-<entry colname="5">text of the statement</entry>
+<entry colname="5">Text of the statement</entry>
</row>
<row>
<entry colname="1">LASTCOMPILED</entry>
<entry colname="2">TIMESTAMP</entry>
<entry colname="3">29</entry>
<entry colname="4">true</entry>
-<entry colname="5">time that the statement was compiled</entry>
+<entry colname="5">Time that the statement was compiled</entry>
</row>
<row>
<entry colname="1">COMPILATIONSCHEMAID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">id of the schema containing the statement</entry>
+<entry colname="5">ID of the schema containing the statement</entry>
</row>
<row>
<entry colname="1">USINGTEXT</entry>
<entry colname="2">LONG VARCHAR</entry>
<entry colname="3">32,700</entry>
<entry colname="4">true</entry>
-<entry colname="5">text of the USING clause of the CREATE STATEMENT and ALTER
+<entry colname="5">Text of the USING clause of the CREATE STATEMENT and ALTER
STATEMENT statements</entry>
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
</refbody>
</reference>