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/03/31 18:57:12 UTC
svn commit: r1087370 [2/2] - in /db/derby/docs/trunk/src: adminguide/
devguide/ getstart/ ref/ tools/ tuning/
Modified: db/derby/docs/trunk/src/ref/rrefsysxplain_statement_timings.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsysxplain_statement_timings.dita?rev=1087370&r1=1087369&r2=1087370&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsysxplain_statement_timings.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsysxplain_statement_timings.dita Thu Mar 31 16:57:10 2011
@@ -79,7 +79,7 @@ to match statement timings with their co
<row>
<entry colname="1">PARSE_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3"></entry>
+<entry colname="3">19</entry>
<entry colname="4">false</entry>
<entry colname="5">The time in milliseconds that
<ph conref="../conrefs.dita#prod/productshortname"></ph> took to parse
@@ -88,7 +88,7 @@ this statement.</entry>
<row>
<entry colname="1">BIND_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3"></entry>
+<entry colname="3">19</entry>
<entry colname="4">false</entry>
<entry colname="5">The time in milliseconds that
<ph conref="../conrefs.dita#prod/productshortname"></ph> took to bind
@@ -99,7 +99,7 @@ definitions in the system catalogs.</ent
<row>
<entry colname="1">OPTIMIZE_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3"></entry>
+<entry colname="3">19</entry>
<entry colname="4">false</entry>
<entry colname="5">The time in milliseconds that
<ph conref="../conrefs.dita#prod/productshortname"></ph> took to optimize
@@ -112,7 +112,7 @@ one it thinks will be best.</entry>
<row>
<entry colname="1">GENERATE_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3"></entry>
+<entry colname="3">19</entry>
<entry colname="4">false</entry>
<entry colname="5">The time in milliseconds that
<ph conref="../conrefs.dita#prod/productshortname"></ph> took to generate
@@ -121,7 +121,7 @@ one it thinks will be best.</entry>
<row>
<entry colname="1">COMPILE_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3"></entry>
+<entry colname="3">19</entry>
<entry colname="4">false</entry>
<entry colname="5">The time in milliseconds that
<ph conref="../conrefs.dita#prod/productshortname"></ph> took to compile
@@ -132,7 +132,7 @@ optimize, and generate time.</entry>
<row>
<entry colname="1">EXECUTE_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3"></entry>
+<entry colname="3">19</entry>
<entry colname="4">false</entry>
<entry colname="5">The time in milliseconds that
<ph conref="../conrefs.dita#prod/productshortname"></ph> took to execute
@@ -141,7 +141,7 @@ this statement.</entry>
<row>
<entry colname="1">BEGIN_COMP_TIME</entry>
<entry colname="2">TIMESTAMP</entry>
-<entry colname="3"></entry>
+<entry colname="3">29</entry>
<entry colname="4">false</entry>
<entry colname="5">The time at which
<ph conref="../conrefs.dita#prod/productshortname"></ph>
@@ -150,7 +150,7 @@ this statement.</entry>
<row>
<entry colname="1">END_COMP_TIME</entry>
<entry colname="2">TIMESTAMP</entry>
-<entry colname="3"></entry>
+<entry colname="3">29</entry>
<entry colname="4">false</entry>
<entry colname="5">The time at which
<ph conref="../conrefs.dita#prod/productshortname"></ph> finished
@@ -159,7 +159,7 @@ compiling this statement.</entry>
<row>
<entry colname="1">BEGIN_EXE_TIME</entry>
<entry colname="2">TIMESTAMP</entry>
-<entry colname="3"></entry>
+<entry colname="3">29</entry>
<entry colname="4">false</entry>
<entry colname="5">The time at which
<ph conref="../conrefs.dita#prod/productshortname"></ph> began to execute
@@ -168,7 +168,7 @@ compiling this statement.</entry>
<row>
<entry colname="1">END_EXE_TIME</entry>
<entry colname="2">TIMESTAMP</entry>
-<entry colname="3"></entry>
+<entry colname="3">29</entry>
<entry colname="4">false</entry>
<entry colname="5">The time at which
<ph conref="../conrefs.dita#prod/productshortname"></ph> finished
Modified: db/derby/docs/trunk/src/ref/rrefsysxplain_statements.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsysxplain_statements.dita?rev=1087370&r1=1087369&r2=1087370&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsysxplain_statements.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsysxplain_statements.dita Thu Mar 31 16:57:10 2011
@@ -80,7 +80,7 @@ colnum="5" colwidth="29*"/>
<row>
<entry colname="1">STMT_TYPE</entry>
<entry colname="2">CHAR</entry>
-<entry colname="3">6</entry>
+<entry colname="3">3</entry>
<entry colname="4">false</entry>
<entry colname="5">A code indicating what type of statement this is:
'<i>S</i>'=SELECT, '<i>I</i>'=INSERT, '<i>U</i>'=UPDATE,
@@ -91,14 +91,14 @@ indicating the statement was a comment.<
<row>
<entry colname="1">STMT_TEXT</entry>
<entry colname="2">VARCHAR</entry>
-<entry colname="3">32672</entry>
+<entry colname="3">32,672</entry>
<entry colname="4">false</entry>
<entry colname="5">The text of the statement.</entry>
</row>
<row>
<entry colname="1">JVM_ID</entry>
-<entry colname="2">CHAR</entry>
-<entry colname="3">30</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">32,672</entry>
<entry colname="4">false</entry>
<entry colname="5">A code indicating what version of the JVM was running
when this statement was captured: '4'=J2SE_14 - JDK 1.4.0 or 1.4.1,
@@ -108,8 +108,8 @@ indicating the statement was a comment.<
</row>
<row>
<entry colname="1">OS_IDENTIFIER</entry>
-<entry colname="2">CHAR</entry>
-<entry colname="3">30</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">32,672</entry>
<entry colname="4">false</entry>
<entry colname="5">Contains information about the operating system
which was being used when this statement was captured.</entry>
@@ -125,31 +125,31 @@ which was being used when this statement
<row>
<entry colname="1">XPLAIN_TIME</entry>
<entry colname="2">TIMESTAMP</entry>
-<entry colname="3"></entry>
+<entry colname="3">29</entry>
<entry colname="4">true</entry>
<entry colname="5">Contains the date and time when this statement
was captured.</entry>
</row>
<row>
<entry colname="1">XPLAIN_THREAD_ID</entry>
-<entry colname="2">CHAR</entry>
-<entry colname="3">32</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">32,672</entry>
<entry colname="4">false</entry>
<entry colname="5">The JVM thread which was running when this statement
was captured.</entry>
</row>
<row>
<entry colname="1">TRANSACTION_ID</entry>
-<entry colname="2">CHAR</entry>
-<entry colname="3">32</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">32,672</entry>
<entry colname="4">false</entry>
<entry colname="5">An internal identifier for the transaction which was
active when this statement was captured.</entry>
</row>
<row>
<entry colname="1">SESSION_ID</entry>
-<entry colname="2">CHAR</entry>
-<entry colname="3">32</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">32,672</entry>
<entry colname="4">false</entry>
<entry colname="5">An internal identifier for the session which was
active when this statement was captured.</entry>
@@ -164,8 +164,8 @@ used when this statement was captured.</
</row>
<row>
<entry colname="1">DRDA_ID</entry>
-<entry colname="2">CHAR</entry>
-<entry colname="3">32</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">32,672</entry>
<entry colname="4">true</entry>
<entry colname="5">In a network environment, this column contains
an internal identifier for the network connection which was
Modified: db/derby/docs/trunk/src/tools/rtoolsdrvrnmeurl.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsdrvrnmeurl.dita?rev=1087370&r1=1087369&r2=1087370&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsdrvrnmeurl.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsdrvrnmeurl.dita Thu Mar 31 16:57:10 2011
@@ -21,10 +21,10 @@ 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>,
+<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>
+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*"/>
@@ -38,8 +38,8 @@ colwidth="29*"/><colspec colname="4" col
</thead>
<tbody>
<row>
-<entry colname="1">loading the driver implicitly</entry>
-<entry colname="2"></entry>
+<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
@@ -50,14 +50,14 @@ href="rtoolsijcomref22318.dita#rtoolsijc
full URL)</entry>
</row>
<row>
-<entry colname="1">loading the driver explicitly</entry>
+<entry colname="1">Loading the driver explicitly</entry>
<entry colname="2"><i>jdbc.drivers</i></entry>
<entry colname="3">-D<i><xref href="rtoolsijpropref41073.dita#rtoolsijpropref41073">ij.Driver</xref></i></entry>
<entry colname="4"><i><xref href="rtoolsijcomref39042.dita#rtoolsijcomref39042">Driver</xref></i></entry>
</row>
<row>
-<entry colname="1">specifying the database connection URL</entry>
-<entry colname="2"></entry>
+<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="4"><i><xref href="rtoolsijcomref22318.dita#rtoolsijcomref22318">Connect</xref></i></entry>
Modified: db/derby/docs/trunk/src/tools/ttoolsexporting.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/ttoolsexporting.dita?rev=1087370&r1=1087369&r2=1087370&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/ttoolsexporting.dita (original)
+++ db/derby/docs/trunk/src/tools/ttoolsexporting.dita Thu Mar 31 16:57:10 2011
@@ -33,49 +33,55 @@ using</indexterm></indexterm></keywords>
<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 <xref href="rtoolsimport91458.dita#rtoolsimport91458"></xref>.</cmd>
-<choicetable relcolwidth="1* 2*">
-<chhead><choptionhd>Type of export</choptionhd><chdeschd>Procedure to use</chdeschd>
-</chhead>
-<chrow><choption>To export all the data from a table to a single export file,
-including the LOB data </choption><chdesc> <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></chdesc>
-</chrow>
-<chrow><choption>To export all the data from a table, and place the LOB data
-into a separate export file</choption><chdesc><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), 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">LOBSFILNAME</xref> VARCHAR(32672))</codeblock><p>A
+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
+ (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/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),
+ 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> </chdesc></chrow>
-<chrow><choption>To export the result of a SELECT statement to a single file,
-including the LOB data</choption><chdesc><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></chdesc>
-</chrow>
-<chrow><choption>To export the result of a SELECT statement to a main export
-file, and place the LOB data into a separate export file</choption><chdesc><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></chdesc>
-</chrow>
-</choicetable>
+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
+ (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/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>
</step>
</steps>
</taskbody>
Modified: db/derby/docs/trunk/src/tools/ttoolsimporting.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/ttoolsimporting.dita?rev=1087370&r1=1087369&r2=1087370&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/ttoolsimporting.dita (original)
+++ db/derby/docs/trunk/src/tools/ttoolsimporting.dita Thu Mar 31 16:57:10 2011
@@ -33,8 +33,9 @@ using</indexterm></indexterm></keywords>
<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 <xref href="rtoolsimport91458.dita#rtoolsimport91458"></xref>.</cmd>
-<info><simpletable>
+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>
@@ -42,26 +43,28 @@ to perform. For examples of these proced
<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 (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>
+<stentry><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/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><p>The
+<stentry><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),
+ 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>
+ <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>
@@ -69,15 +72,17 @@ import file must be <codeph>lobsFileName
<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 (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), IN <xref
-href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportcolumnindexes">COLUMNINDEXES</xref> VARCHAR(32672), 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><p>You
+<stentry><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),
+ IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportcolumnindexes">COLUMNINDEXES</xref> VARCHAR(32672),
+ 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>
+ <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>
@@ -86,16 +91,17 @@ from a file to column in a table.</p></s
<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 (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), IN <xref
-href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportcolumnindexes">COLUMNINDEXES</xref> VARCHAR(32672), 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><p>The
+<stentry><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),
+ IN <xref href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportcolumnindexes">COLUMNINDEXES</xref> VARCHAR(32672),
+ 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>
+ <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>
Modified: db/derby/docs/trunk/src/tuning/ctuntransform36368.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/ctuntransform36368.dita?rev=1087370&r1=1087369&r2=1087370&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tuning/ctuntransform36368.dita (original)
+++ db/derby/docs/trunk/src/tuning/ctuntransform36368.dita Thu Mar 31 16:57:10 2011
@@ -29,42 +29,20 @@ limitations under the License.
and ANY. However, for each row returned in the outer row, <ph conref="../conrefs.dita#prod/productshortname"></ph> evaluates
the subquery until it returns one row; it does not evaluate the subquery for
all rows returned.</p>
-<p>For example, given two tables, <i>t1</i> and <i>t2</i>:
-<table pgwide="0" frame="all">
-<tgroup cols="1" colsep="1" rowsep="1">
-<colspec colnum="1" colname="1" colwidth="100*"/>
-<thead>
-<row>
-<entry colname="1">c1</entry></row>
-</thead>
-<tbody>
-<row>
-<entry colname="1">1</entry></row>
-<row>
-<entry colname="1">2</entry></row>
-<row>
-<entry colname="1">3</entry></row>
-</tbody>
-</tgroup>
-</table>
-<table pgwide="0" frame="all">
-<tgroup cols="1" colsep="1" rowsep="1">
-<colspec colnum="1" colname="1" colwidth="100*"/>
-<thead>
-<row>
-<entry colname="1">c1</entry></row>
-</thead>
-<tbody>
-<row>
-<entry colname="1">2</entry></row>
-<row>
-<entry colname="1">2</entry></row>
-<row>
-<entry colname="1">1</entry></row>
-</tbody>
-</tgroup>
-</table></p>
-<p>and the following query:
+<p>For example, given two tables, <i>t1</i> and <i>t2</i>:</p>
+<codeblock><b>c1</b>
+--
+ 1
+ 2
+ 3
+
+<b>c1</b>
+--
+ 2
+ 2
+ 1
+</codeblock>
+<p>and the following query:
<codeblock><b>SELECT c1 FROM t1 WHERE c1 IN (SELECT c1 FROM t2)</b></codeblock></p>
<p>the results would be
<codeblock>1