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 18:36:18 UTC
svn commit: r1097878 - in /db/derby/docs/branches/10.8/src/tools:
rtoolsdrvrnmeurl.dita rtoolsijlocale.dita rtoolsijpropref97949.dita
rtoolsimportcodeset.dita rtoolsplanexpxmlformat.dita ttoolsexporting.dita
ttoolsimporting.dita
Author: chaase3
Date: Fri Apr 29 16:36:18 2011
New Revision: 1097878
URL: http://svn.apache.org/viewvc?rev=1097878&view=rev
Log:
DERBY-5184 Tables in documentation need introductions and formatting fixes
Merged DERBY-5184-tools.diff to 10.8 code branch from trunk revision 1097872.
Modified:
db/derby/docs/branches/10.8/src/tools/rtoolsdrvrnmeurl.dita
db/derby/docs/branches/10.8/src/tools/rtoolsijlocale.dita
db/derby/docs/branches/10.8/src/tools/rtoolsijpropref97949.dita
db/derby/docs/branches/10.8/src/tools/rtoolsimportcodeset.dita
db/derby/docs/branches/10.8/src/tools/rtoolsplanexpxmlformat.dita
db/derby/docs/branches/10.8/src/tools/ttoolsexporting.dita
db/derby/docs/branches/10.8/src/tools/ttoolsimporting.dita
Modified: db/derby/docs/branches/10.8/src/tools/rtoolsdrvrnmeurl.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/tools/rtoolsdrvrnmeurl.dita?rev=1097878&r1=1097877&r2=1097878&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/tools/rtoolsdrvrnmeurl.dita (original)
+++ db/derby/docs/branches/10.8/src/tools/rtoolsdrvrnmeurl.dita Fri Apr 29 16:36:18 2011
@@ -21,15 +21,17 @@ limitations under the License.
<title>The ij Driver name and connection URL</title>
<prolog></prolog>
<refbody>
-<section><p><xref href="rtoolsdrvrnmeurl.dita#rtoolsdrvrnmeurl/rtoolsij16268"></xref>
-summarizes the different ways to specify the driver name and database connection
-URL. <table frame="all" id="rtoolsij16268" pgwide="1"><title>Specifying
-the driver name and database connection URL</title>
-<tgroup cols="4" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="31*"/>
-<colspec colname="2" colnum="2" colwidth="19*"/><colspec colname="3" colnum="3"
-colwidth="29*"/><colspec colname="4" colnum="4" colwidth="20*"/>
+<section><p>The following table summarizes the different ways to specify the
+driver name and database connection URL.</p>
+<table frame="all">
+<title>Specifying the driver name and database connection URL</title>
+<tgroup cols="4" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="20*"/>
+<colspec colname="2" colnum="2" colwidth="15*"/>
+<colspec colname="3" colnum="3" colwidth="45*"/>
+<colspec colname="4" colnum="4" colwidth="20*"/>
<thead>
-<row>
+<row valign="bottom">
<entry colname="1">Action</entry>
<entry colname="2">System Property</entry>
<entry colname="3"><codeph>ij</codeph> Property</entry>
@@ -41,13 +43,13 @@ colwidth="29*"/><colspec colname="4" col
<entry colname="1">Loading the driver implicitly</entry>
<entry colname="2">None</entry>
<entry colname="3"><i><xref href="rtoolsijpropref10135.dita#rtoolsijpropref10135">ij.connection.connectionName</xref></i> (plus
-full URL) <i><xref href="rtoolsijpropref28146.dita#rtoolsijpropref28146">ij.database</xref></i> (plus
-full URL) <i><xref href="rtoolsijpropref35032.dita#rtoolsijpropref35032">ij.protocol</xref></i><i><xref
+full URL), <i><xref href="rtoolsijpropref28146.dita#rtoolsijpropref28146">ij.database</xref></i> (plus
+full URL), <i><xref href="rtoolsijpropref35032.dita#rtoolsijpropref35032">ij.protocol</xref></i>, <i><xref
href="rtoolsijpropref12236.dita#rtoolsijpropref12236">ij.protocol.protocolName</xref></i> (plus
protocol clause in Connect command)</entry>
-<entry colname="4"><i><xref href="rtoolsijcomref27997.dita#rtoolsijcomref27997">Protocol</xref></i> <i><xref
-href="rtoolsijcomref22318.dita#rtoolsijcomref22318">Connect</xref></i> (plus
-full URL)</entry>
+<entry colname="4"><i><xref href="rtoolsijcomref27997.dita#rtoolsijcomref27997">Protocol</xref></i>,
+<i><xref href="rtoolsijcomref22318.dita#rtoolsijcomref22318">Connect</xref></i>
+(plus full URL)</entry>
</row>
<row>
<entry colname="1">Loading the driver explicitly</entry>
@@ -58,12 +60,12 @@ full URL)</entry>
<row>
<entry colname="1">Specifying the database connection URL</entry>
<entry colname="2">None</entry>
-<entry colname="3"><i><xref href="rtoolsijpropref10135.dita#rtoolsijpropref10135">ij.connection.connectionName</xref> <xref
-href="rtoolsijpropref28146.dita#rtoolsijpropref28146">ij.database</xref></i></entry>
+<entry colname="3"><i><xref href="rtoolsijpropref10135.dita#rtoolsijpropref10135">ij.connection.connectionName</xref>,
+<xref href="rtoolsijpropref28146.dita#rtoolsijpropref28146">ij.database</xref></i></entry>
<entry colname="4"><i><xref href="rtoolsijcomref22318.dita#rtoolsijcomref22318">Connect</xref></i></entry>
</row>
</tbody>
</tgroup>
-</table></p></section>
+</table></section>
</refbody>
</reference>
Modified: db/derby/docs/branches/10.8/src/tools/rtoolsijlocale.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/tools/rtoolsijlocale.dita?rev=1097878&r1=1097877&r2=1097878&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/tools/rtoolsijlocale.dita (original)
+++ db/derby/docs/branches/10.8/src/tools/rtoolsijlocale.dita Fri Apr 29 16:36:18 2011
@@ -48,15 +48,16 @@ Kanji mixed encoding (<i>codeset=Cp939</
-Dij.protocol=jdbc:derby:
org.apache.derby.tools.ij</b></codeblock>
<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*"/>
+ 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>
@@ -78,17 +79,20 @@ Kanji mixed encoding (<i>codeset=Cp939</
</row>
</tbody>
</tgroup>
-</table></p> <p>To see a full list of ISO-639 codes, go to <xref format="html"
+</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.
- <table frame="all"><title>Sample Country Codes</title>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="50*"/>
+<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>
@@ -114,7 +118,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>
</example>
</refbody>
Modified: db/derby/docs/branches/10.8/src/tools/rtoolsijpropref97949.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/tools/rtoolsijpropref97949.dita?rev=1097878&r1=1097877&r2=1097878&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/tools/rtoolsijpropref97949.dita (original)
+++ db/derby/docs/branches/10.8/src/tools/rtoolsijpropref97949.dita Fri Apr 29 16:36:18 2011
@@ -29,8 +29,9 @@ features<indexterm>codeset</indexterm></
encoding value when using one of the <ph conref="../conrefs.dita#prod/productshortname"></ph> tools
with a language not supported by your default system.</p> </section>
<refsyn><title>Syntax</title> <codeblock><b>derby.ui.codeset=<b><i>derbyval</i></b></b></codeblock> <p>where <i>derbyval</i> is
-a supported character encoding value, for example, UTF8 (see <xref href="rtoolsijpropref97949.dita#rtoolsijpropref97949/rtoolsijpropref62163"></xref
->).</p> </refsyn>
+a supported character encoding value, for example, UTF8 (see the table later
+in this topic).</p>
+</refsyn>
<example><title>Example</title> <p>The following command specifies to run <codeph>ij</codeph> using
the Japanese territory (<i>derby.ui.locale=ja_JP</i>) using Japanese Latin
Kanji mixed encoding (<i>codeset=Cp939</i>): </p><codeblock><b>java -Dderby.ui.locale=ja_JP -Dderby.ui.codeset=Cp939
@@ -40,13 +41,14 @@ a sampling of character encodings. Suppo
product. For example, to see the full list of the character encodings that
are supported by the Java Platform, Standard Edition 6 Software Development Kit,
go to <xref format="html" href="http://download.oracle.com/javase/6/docs/technotes/guides/intl/encoding.doc.html"
-scope="external">http://download.oracle.com/javase/6/docs/technotes/guides/intl/encoding.doc.html</xref>.
- <table frame="all" id="rtoolsijpropref62163" pgwide="0"><title>Sample Character
-Encodings</title>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="36*"/>
-<colspec colname="2" colnum="2" colwidth="64*"/>
+scope="external">http://download.oracle.com/javase/6/docs/technotes/guides/intl/encoding.doc.html</xref>.</p>
+<table frame="all">
+<title>Sample character encodings</title>
+<tgroup cols="2" colsep="1" rowsep="1">
+<colspec colname="1" colnum="1" colwidth="50*"/>
+<colspec colname="2" colnum="2" colwidth="50*"/>
<thead>
-<row>
+<row valign="bottom">
<entry colname="1">Character Encoding</entry>
<entry colname="2">Explanation</entry>
</row>
@@ -110,6 +112,6 @@ Encodings</title>
</row>
</tbody>
</tgroup>
-</table></p> </example>
+</table></example>
</refbody>
</reference>
Modified: db/derby/docs/branches/10.8/src/tools/rtoolsimportcodeset.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/tools/rtoolsimportcodeset.dita?rev=1097878&r1=1097877&r2=1097878&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/tools/rtoolsimportcodeset.dita (original)
+++ db/derby/docs/branches/10.8/src/tools/rtoolsimportcodeset.dita Fri Apr 29 16:36:18 2011
@@ -29,79 +29,11 @@ procedures to override the system defaul
</keywords>
</metadata></prolog>
<refbody>
-<section><p>The following table contains a sample of the character encoding
-that is supported by JDK 1.x. To review the complete list of character encodings,
-refer to your Java documentation. </p><table frame="all"><title>Sample character
-encodings</title><desc>This table contains sample character encodings supported
-by JDK1.x.</desc>
-<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="colspec0" colwidth="228*"/>
-<colspec colname="colspec1" colwidth="228*"/>
-<thead>
-<row>
-<entry align="left" valign="top">Character Encoding</entry>
-<entry align="left" valign="top">Explanation</entry>
-</row>
-</thead>
-<tbody>
-<row>
-<entry colname="colspec0">8859_1</entry>
-<entry colname="colspec1">ISO Latin-1</entry>
-</row>
-<row>
-<entry colname="colspec0">8859_2</entry>
-<entry colname="colspec1">ISO Latin-2</entry>
-</row>
-<row>
-<entry colname="colspec0">8859_7</entry>
-<entry colname="colspec1">ISO Latin/Greek</entry>
-</row>
-<row>
-<entry colname="colspec0">Cp1257</entry>
-<entry colname="colspec1">Windows Baltic</entry>
-</row>
-<row>
-<entry colname="colspec0">Cp1258</entry>
-<entry colname="colspec1">Windows Vietnamese</entry>
-</row>
-<row>
-<entry colname="colspec0">Cp437</entry>
-<entry colname="colspec1">PC Original</entry>
-</row>
-<row>
-<entry colname="colspec0">EUCJIS</entry>
-<entry colname="colspec1">Japanese EUC</entry>
-</row>
-<row>
-<entry colname="colspec0">GB2312</entry>
-<entry colname="colspec1">GB2312-80 Simplified Chinese</entry>
-</row>
-<row>
-<entry colname="colspec0">JIS</entry>
-<entry colname="colspec1">JIS</entry>
-</row>
-<row>
-<entry colname="colspec0">KSC5601</entry>
-<entry colname="colspec1">KSC5601 Korean</entry>
-</row>
-<row>
-<entry colname="colspec0">MacCroatian</entry>
-<entry colname="colspec1">Macintosh Croatian</entry>
-</row>
-<row>
-<entry colname="colspec0">MacCyrillic</entry>
-<entry colname="colspec1">Macintosh Cyrillic</entry>
-</row>
-<row>
-<entry colname="colspec0">SJIS</entry>
-<entry colname="colspec1">PC and Windows Japanese</entry>
-</row>
-<row>
-<entry colname="colspec0">UTF-8</entry>
-<entry colname="colspec1">Standard UTF-8</entry>
-</row>
-</tbody>
-</tgroup>
-</table></section>
+<section><p>For a table that shows a sample of the character encodings supported
+by the Java Development Kit, see
+<xref href="rtoolsijpropref97949.dita#rtoolsijpropref97949"></xref>. To review
+the complete list of character encodings, refer to your Java documentation.</p>
+</section>
<section><title>Examples of specifying the codeset in import and export procedures</title><p>
The following example shows how to specify UTF-8 encoding to export to the <codeph>staff.dat</codeph> table: <codeblock>CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE
(NULL,'STAFF','staff.dat',NULL,NULL,'UTF-8')
Modified: db/derby/docs/branches/10.8/src/tools/rtoolsplanexpxmlformat.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/tools/rtoolsplanexpxmlformat.dita?rev=1097878&r1=1097877&r2=1097878&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/tools/rtoolsplanexpxmlformat.dita (original)
+++ db/derby/docs/branches/10.8/src/tools/rtoolsplanexpxmlformat.dita Fri Apr 29 16:36:18 2011
@@ -37,17 +37,16 @@ has the following structure.</p></sectio
<section>
<ul>
<li><b>The basic tree structure:</b>
-<codeblock>
-plan - (The root of the XML tree)
-|
-|-- statement - (first child - The query executed)
-|
-|-- time - (second child - The time that this query executed
-|
-|-- stmt_id - (Third Child - The STMT_ID of the query)
-|
-|-- details - (fourth child - Contains the query plan)
-</codeblock>
+<ul>
+<li><codeph>plan</codeph>: The root of the XML tree
+<ul>
+<li><codeph>statement</codeph>: First child, the query executed</li>
+<li><codeph>time</codeph>: Second child, the time that this query executed</li>
+<li><codeph>stmt_id </codeph>: Third child, the STMT_ID of the query</li>
+<li><codeph>details</codeph>: Fourth child, containing the query plan</li>
+</ul>
+</li>
+</ul>
</li>
<li><b>The <codeph>statement</codeph> element:</b>
<p>This element has only its value. That value implies the
@@ -80,67 +79,76 @@ This element can contain zero or many ch
same type (<codeph>node</codeph> elements). </p>
<p>This element contains one or more attributes, given that
they are not null. The possible attributes and
-their meanings are as follows.</p>
-<simpletable relcolwidth="1* 4*">
-<sthead>
-<stentry>Attribute Name</stentry>
-<stentry>Meaning</stentry>
-</sthead>
-<strow>
-<stentry><codeph>name</codeph></stentry>
-<stentry>Name of the plan node</stentry>
-</strow>
-<strow>
-<stentry><codeph>input_rows</codeph></stentry>
-<stentry>Retrieved from the INPUT_ROWS row of the SYSXPLAIN_RESULTSETS system
-table</stentry>
-</strow>
-<strow>
-<stentry><codeph>returned_rows</codeph></stentry>
-<stentry>Retrieved from the RETURNED_ROWS row of the SYSXPLAIN_RESULTSETS system
-table</stentry>
-</strow>
-<strow>
-<stentry><codeph>no_opens</codeph></stentry>
-<stentry>Retrieved from the NO_OPENS row of the SYSXPLAIN_RESULTSETS system
-table</stentry>
-</strow>
-<strow>
-<stentry><codeph>visited_pages</codeph></stentry>
-<stentry>Retrieved from the NO_VISITED_PAGES row of the SYSXPLAIN_SCAN_PROPS
-system table</stentry>
-</strow>
-<strow>
-<stentry><codeph>scan_qualifiers</codeph></stentry>
-<stentry>Retrieved from the SCAN_QUALIFIERS row of the SYSXPLAIN_SCAN_PROPS
-system table</stentry>
-</strow>
-<strow>
-<stentry><codeph>next_qualifiers</codeph></stentry>
-<stentry>Retrieved from the NEXT_QUALIFIERS row of the SYSXPLAIN_SCAN_PROPS
-system table</stentry>
-</strow>
-<strow>
-<stentry><codeph>scanned_object</codeph></stentry>
-<stentry>Retrieved from the SCAN_OBJECT_NAME row of the SYSXPLAIN_SCAN_PROPS
-system table</stentry>
-</strow>
-<strow>
-<stentry><codeph>scan_type</codeph></stentry>
-<stentry>Retrieved from the SCAN_TYPE row of the SYSXPLAIN_SCAN_PROPS
-system table</stentry>
-</strow>
-<strow>
-<stentry><codeph>sort_type</codeph></stentry>
-<stentry>Retrieved from the SORT_TYPE row of the SYSXPLAIN_SORT_PROPS system
-table</stentry>
-</strow>
-<strow>
-<stentry><codeph>sorter_output</codeph></stentry>
-<stentry>Retrieved from the NO_OUTPUT_ROWS row of the SYSXPLAIN_SORT_PROPS
-system table</stentry>
-</strow>
-</simpletable>
+their meanings are shown in the following table.</p>
+<table>
+<title>Attributes of the <codeph>node</codeph> element</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="30*"/>
+<colspec colname="col2" colnum="2" colwidth="70*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Attribute Name</entry>
+<entry colname="col2">Meaning</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1"><codeph>name</codeph></entry>
+<entry colname="col2">Name of the plan node</entry>
+</row>
+<row>
+<entry colname="col1"><codeph>input_rows</codeph></entry>
+<entry colname="col2">Retrieved from the INPUT_ROWS row of the
+SYSXPLAIN_RESULTSETS system table</entry>
+</row>
+<row>
+<entry colname="col1"><codeph>returned_rows</codeph></entry>
+<entry colname="col2">Retrieved from the RETURNED_ROWS row of the
+SYSXPLAIN_RESULTSETS system table</entry>
+</row>
+<row>
+<entry colname="col1"><codeph>no_opens</codeph></entry>
+<entry colname="col2">Retrieved from the NO_OPENS row of the
+SYSXPLAIN_RESULTSETS system table</entry>
+</row>
+<row>
+<entry colname="col1"><codeph>visited_pages</codeph></entry>
+<entry colname="col2">Retrieved from the NO_VISITED_PAGES row of the
+SYSXPLAIN_SCAN_PROPS system table</entry>
+</row>
+<row>
+<entry colname="col1"><codeph>scan_qualifiers</codeph></entry>
+<entry colname="col2">Retrieved from the SCAN_QUALIFIERS row of the
+SYSXPLAIN_SCAN_PROPS system table</entry>
+</row>
+<row>
+<entry colname="col1"><codeph>next_qualifiers</codeph></entry>
+<entry colname="col2">Retrieved from the NEXT_QUALIFIERS row of the
+SYSXPLAIN_SCAN_PROPS system table</entry>
+</row>
+<row>
+<entry colname="col1"><codeph>scanned_object</codeph></entry>
+<entry colname="col2">Retrieved from the SCAN_OBJECT_NAME row of the
+SYSXPLAIN_SCAN_PROPS system table</entry>
+</row>
+<row>
+<entry colname="col1"><codeph>scan_type</codeph></entry>
+<entry colname="col2">Retrieved from the SCAN_TYPE row of the
+SYSXPLAIN_SCAN_PROPS system table</entry>
+</row>
+<row>
+<entry colname="col1"><codeph>sort_type</codeph></entry>
+<entry colname="col2">Retrieved from the SORT_TYPE row of the
+SYSXPLAIN_SORT_PROPS system table</entry>
+</row>
+<row>
+<entry colname="col1"><codeph>sorter_output</codeph></entry>
+<entry colname="col2">Retrieved from the NO_OUTPUT_ROWS row of the
+SYSXPLAIN_SORT_PROPS system table</entry>
+</row>
+</tbody>
+</tgroup>
+</table>
<p>For example:
<codeblock><node name="TABLESCAN" returned_rows="100000" no_opens="1"
visited_pages="2165" scan_qualifiers="None" scanned_object="USERS"
Modified: db/derby/docs/branches/10.8/src/tools/ttoolsexporting.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/tools/ttoolsexporting.dita?rev=1097878&r1=1097877&r2=1097878&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/tools/ttoolsexporting.dita (original)
+++ db/derby/docs/branches/10.8/src/tools/ttoolsexporting.dita Fri Apr 29 16:36:18 2011
@@ -32,26 +32,37 @@ using</indexterm></indexterm></keywords>
<taskbody>
<context></context>
<steps>
-<step><cmd>Choose the correct procedure for the type of export that you want
-to perform. For examples of these procedures, see
+<step><cmd>Use the following table to choose the correct procedure for the type
+of export that you want to perform. For examples of these procedures, see
<xref href="rtoolsimport91458.dita#rtoolsimport91458"></xref>.</cmd>
-<info><simpletable relcolwidth="1* 2*">
-<sthead>
-<stentry>Type of export</stentry>
-<stentry>Procedure to use</stentry>
-</sthead>
-<strow><stentry>To export all the data from a table to a single export file,
-including the LOB data </stentry>
-<stentry> <codeblock>SYSCS_UTIL.SYSCS_EXPORT_TABLE
+<info>
+<table>
+<title>Using the built-in export procedures</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="33*"/>
+<colspec colname="col2" colnum="2" colwidth="67*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Type of Export</entry>
+<entry colname="col2">Procedure to Use</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">To export all the data from a table to a single export
+file, including the LOB data</entry>
+<entry colname="col2"><codeblock>SYSCS_UTIL.SYSCS_EXPORT_TABLE
(IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportschemaname">SCHEMANAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexporttablename">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportfilename">FILENAME</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcolumndelimiter">COLUMNDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
- IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128))</codeblock></stentry>
-</strow>
-<strow><stentry>To export all the data from a table, and place the LOB data
-into a separate export file</stentry><stentry><codeblock>SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE
+ IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128))</codeblock></entry>
+</row>
+<row>
+<entry colname="col1">To export all the data from a table, and place the LOB
+data into a separate export file</entry>
+<entry colname="col2"><codeblock>SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE
(IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportschemaname">SCHEMANAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexporttablename">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportfilename">FILENAME</xref> VARCHAR(32672),
@@ -59,29 +70,35 @@ into a separate export file</stentry><st
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportlobsfilename">LOBSFILNAME</xref> VARCHAR(32672))</codeblock>
- <p>A
-reference to the location of the LOB data is placed in the LOB column in the
-main export file.</p> </stentry></strow>
-<strow><stentry>To export the result of a SELECT statement to a single file,
-including the LOB data</stentry><stentry><codeblock>SYSCS_UTIL.SYSCS_EXPORT_QUERY
+<p>A reference to the location of the LOB data is placed in the LOB column in
+the main export file.</p></entry>
+</row>
+<row>
+<entry colname="col1">To export the result of a SELECT statement to a single file,
+including the LOB data</entry>
+<entry colname="col2"><codeblock>SYSCS_UTIL.SYSCS_EXPORT_QUERY
(IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportselectstatement">SELECTSTATEMENT</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportfilename">FILENAME</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcolumndelimiter">COLUMNDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
- IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128))</codeblock></stentry>
-</strow>
-<strow><stentry>To export the result of a SELECT statement to a main export
-file, and place the LOB data into a separate export file</stentry><stentry><codeblock>SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
+ IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128))</codeblock></entry>
+</row>
+<row>
+<entry colname="col1">To export the result of a SELECT statement to a main
+export file, and place the LOB data into a separate export file</entry>
+<entry colname="col2"><codeblock>SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
(IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportselectstatement">SELECTSTATEMENT</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportfilename">FILENAME</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcolumndelimiter">COLUMNDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportlobsfilename">LOBSFILENAME</xref> VARCHAR(32672))</codeblock>
- <p>A
-reference to the LOB data is written to the main export file.</p></stentry>
-</strow>
-</simpletable></info>
+<p>A reference to the LOB data is written to the main export file.</p></entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+</info>
</step>
</steps>
</taskbody>
Modified: db/derby/docs/branches/10.8/src/tools/ttoolsimporting.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/tools/ttoolsimporting.dita?rev=1097878&r1=1097877&r2=1097878&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/tools/ttoolsimporting.dita (original)
+++ db/derby/docs/branches/10.8/src/tools/ttoolsimporting.dita Fri Apr 29 16:36:18 2011
@@ -32,31 +32,39 @@ using</indexterm></indexterm></keywords>
<taskbody>
<context></context>
<steps>
-<step><cmd>Choose the correct procedure for the type of import that you want
-to perform. For examples of these procedures, see
+<step><cmd>Use the following table to choose the correct procedure for the type
+of import that you want to perform. For examples of these procedures, see
<xref href="rtoolsimport91458.dita#rtoolsimport91458"></xref>.</cmd>
-<info><simpletable relcolwidth="1* 2*">
-<sthead>
-<stentry>Type of import</stentry>
-<stentry>Procedure to use</stentry>
-</sthead>
-<strow>
-<stentry>To import all the data to a table, where the import file contains
-the LOB data</stentry>
-<stentry><codeblock>SYSCS_UTIL.SYSCS_IMPORT_TABLE
+<info>
+<table>
+<title>Using the built-in import procedures</title>
+<tgroup cols="3" colsep="1" rowsep="1">
+<colspec colname="col1" colnum="1" colwidth="33*"/>
+<colspec colname="col2" colnum="2" colwidth="67*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">Type of Import</entry>
+<entry colname="col2">Procedure to Use</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">To import all the data to a table, where the import file
+contains the LOB data</entry>
+<entry colname="col2"><codeblock>SYSCS_UTIL.SYSCS_IMPORT_TABLE
(IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportschemaname">SCHEMANAME</xref> VARCHAR(128),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimport27122">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportfilename">FILENAME</xref> VARCHAR(32672),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportcolumndelimiter">COLUMNDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportcodesetarg">CODESET</xref> VARCHAR(128),
- IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportreplace">REPLACE</xref> SMALLINT)</codeblock></stentry>
-</strow>
-<strow>
-<stentry>To import the data to a table, where the LOB data is stored in a
-separate file and the main import file contains all of the other data with
-a reference to the LOB data</stentry>
-<stentry><codeblock>SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE
+ IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportreplace">REPLACE</xref> SMALLINT)</codeblock></entry>
+</row>
+<row>
+<entry colname="col1">To import the data to a table, where the LOB data is
+stored in a separate file and the main import file contains all of the other
+data with a reference to the LOB data</entry>
+<entry colname="col2"><codeblock>SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE
(IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportschemaname">SCHEMANAME</xref> VARCHAR(128),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimport27122">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportfilename">FILENAME</xref> VARCHAR(32672),
@@ -64,15 +72,14 @@ a reference to the LOB data</stentry>
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportcodesetarg">CODESET</xref> VARCHAR(128),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportreplace">REPLACE</xref> SMALLINT)</codeblock>
- <p>The
-import utility looks in the main import file for a reference to the location
-of the LOB data. The format of the reference to the LOB stored in the main
-import file must be <codeph>lobsFileName.Offset.length/</codeph>.</p></stentry>
-</strow>
-<strow>
-<stentry>To import data from a file to a subset of columns in a table, where
-the import file contains the LOB data</stentry>
-<stentry><codeblock>SYSCS_UTIL.SYSCS_IMPORT_DATA
+<p>The import utility looks in the main import file for a reference to the
+location of the LOB data. The format of the reference to the LOB stored in the
+main import file must be <codeph>lobsFileName.Offset.length/</codeph>.</p></entry>
+</row>
+<row>
+<entry colname="col1">To import data from a file to a subset of columns in a
+table, where the import file contains the LOB data</entry>
+<entry colname="col2"><codeblock>SYSCS_UTIL.SYSCS_IMPORT_DATA
(IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportschemaname">SCHEMANAME</xref> VARCHAR(128),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimport27122">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportinsertcolumns">INSERTCOLUMNS</xref> VARCHAR(32672),
@@ -82,16 +89,15 @@ the import file contains the LOB data</s
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportcodesetarg">CODESET</xref> VARCHAR(128),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportreplace">REPLACE</xref> SMALLINT)</codeblock>
- <p>You
-must specify the insertColumns parameter on the table into which data will
-be imported. You must specify the columnIndex parameter to import data fields
-from a file to column in a table.</p></stentry>
-</strow>
-<strow>
-<stentry>To import data to a subset of columns in a table, where the LOB data
-is stored in a separate file and the main import file contains all of the
-other data with a reference to the LOB data</stentry>
-<stentry><codeblock>SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE
+<p>You must specify the INSERTCOLUMNS parameter on the table into which data
+will be imported. You must specify the COLUMNINDEXES parameter to import data
+fields from a file to column in a table.</p></entry>
+</row>
+<row>
+<entry colname="col1">To import data to a subset of columns in a table, where
+the LOB data is stored in a separate file and the main import file contains all
+of the other data with a reference to the LOB data</entry>
+<entry colname="col2"><codeblock>SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE
(IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportschemaname">SCHEMANAME</xref> VARCHAR(128),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimport27122">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportinsertcolumns">INSERTCOLUMNS</xref> VARCHAR(32672),
@@ -101,12 +107,14 @@ other data with a reference to the LOB d
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportcodesetarg">CODESET</xref> VARCHAR(128),
IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportreplace">REPLACE</xref> SMALLINT)</codeblock>
- <p>The
-import utility looks in the main import file for a reference to the location
-of the LOB data. The format of the reference to the LOB stored in the main
-import file must be <codeph>lobsFileName.Offset.length/</codeph>.</p></stentry>
-</strow>
-</simpletable></info></step>
+<p>The import utility looks in the main import file for a reference to the
+location of the LOB data. The format of the reference to the LOB stored in the
+main import file must be <codeph>lobsFileName.Offset.length/</codeph>.</p></entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+</info></step>
</steps>
</taskbody>
</task>