db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1087370 [2/2] - in /db/derby/docs/trunk/src: adminguide/ devguide/ getstart/ ref/ tools/ tuning/
Date Thu, 31 Mar 2011 16:57:12 GMT
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



Mime
View raw message