db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From scotsmat...@apache.org
Subject svn commit: r553553 - in /db/derby/docs/trunk/src/tools: ctoolsimportjdbc.dita derbytools.ditamap rtoolsijproprefexceptiontrace.dita rtoolsimport91458.dita ttoolsimporting.dita
Date Thu, 05 Jul 2007 16:24:36 GMT
Author: scotsmatrix
Date: Thu Jul  5 09:24:33 2007
New Revision: 553553

URL: http://svn.apache.org/viewvc?view=rev&rev=553553
Log:
Derby-2853: Updated the examples for import and export.Patch provided by me.

Modified:
    db/derby/docs/trunk/src/tools/ctoolsimportjdbc.dita
    db/derby/docs/trunk/src/tools/derbytools.ditamap
    db/derby/docs/trunk/src/tools/rtoolsijproprefexceptiontrace.dita
    db/derby/docs/trunk/src/tools/rtoolsimport91458.dita
    db/derby/docs/trunk/src/tools/ttoolsimporting.dita

Modified: db/derby/docs/trunk/src/tools/ctoolsimportjdbc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/ctoolsimportjdbc.dita?view=diff&rev=553553&r1=553552&r2=553553
==============================================================================
--- db/derby/docs/trunk/src/tools/ctoolsimportjdbc.dita (original)
+++ db/derby/docs/trunk/src/tools/ctoolsimportjdbc.dita Thu Jul  5 09:24:33 2007
@@ -31,7 +31,7 @@
 procedure from Java. In this example, the procedure exports the data in the <codeph>staff</codeph>
table
 in the default schema to the <codeph>staff.dat</codeph> file. A percentage
 (%) character is used to specify the column delimiter. <codeblock>PreparedStatement
ps=conn.prepareStatement(
-    "CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE ?,?,?,?,?,?)");
+    "CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE (?,?,?,?,?,?)");
     ps.setString(1,null);
     ps.setString(2,"STAFF");
     ps.setString(3,"staff.dat");

Modified: db/derby/docs/trunk/src/tools/derbytools.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/derbytools.ditamap?view=diff&rev=553553&r1=553552&r2=553553
==============================================================================
--- db/derby/docs/trunk/src/tools/derbytools.ditamap (original)
+++ db/derby/docs/trunk/src/tools/derbytools.ditamap Thu Jul  5 09:24:33 2007
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="utf-8"?>
-<!--Arbortext, Inc., 1988-2006, v.4002-->
+
 <!DOCTYPE map PUBLIC "-//OASIS//DTD DITA Map//EN"
  "../dtd/map.dtd">
 <!-- 

Modified: db/derby/docs/trunk/src/tools/rtoolsijproprefexceptiontrace.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijproprefexceptiontrace.dita?view=diff&rev=553553&r1=553552&r2=553553
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijproprefexceptiontrace.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijproprefexceptiontrace.dita Thu Jul  5 09:24:33 2007
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="utf-8"?>
-<!--Arbortext, Inc., 1988-2006, v.4002-->
+
 <!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
  "../dtd/reference.dtd">
 <!-- 

Modified: db/derby/docs/trunk/src/tools/rtoolsimport91458.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsimport91458.dita?view=diff&rev=553553&r1=553552&r2=553553
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsimport91458.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsimport91458.dita Thu Jul  5 09:24:33 2007
@@ -47,7 +47,7 @@
 the main import file and contains references that point to a separate file
 which contains the LOB data. This example specifies a comma as the column
 delimiter. The data will be appended to the existing data in the table.</p><codeblock>CALL
SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE(
-    'APP','STAFF','c:\data\staff.del',',','"','UTF-8',0); </codeblock></section>
+    null,'STAFF','c:\data\staff.del',',','"','UTF-8',0); </codeblock></section>
 <section><title>Example importing data into specific columns, using a separate
 import file for the LOB data</title>The following example shows how to import
 data into several columns of the STAFF table. The STAFF table includes a LOB
@@ -72,7 +72,7 @@
 <section><title>Example exporting all data from a table, using a separate
 export file for the LOB data</title><p>The following example shows how to
 export data from the STAFF table in a sample database to the main file <codeph>staff.del</codeph>
and
-the LOB export file <codeph>pictures.dat</codeph>.</p><codeblock>CALL
SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE('APP','STAFF'
+the LOB export file <codeph>pictures.dat</codeph>.</p><codeblock>CALL
SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE(null,'STAFF'
     'c:\data\staff.del',',','"','UTF-8', 'c:\data\pictures.dat'); </codeblock></section>
 <section><title>Example exporting data from a query to a single export file</title><p>The
 following example shows how to export employee data in department 20 from

Modified: db/derby/docs/trunk/src/tools/ttoolsimporting.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/ttoolsimporting.dita?view=diff&rev=553553&r1=553552&r2=553553
==============================================================================
--- db/derby/docs/trunk/src/tools/ttoolsimporting.dita (original)
+++ db/derby/docs/trunk/src/tools/ttoolsimporting.dita Thu Jul  5 09:24:33 2007
@@ -34,65 +34,73 @@
 <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>
-<choicetable relcolwidth="1* 2*">
-<chhead><choptionhd>Type of import</choptionhd><chdeschd>Procedure
to use</chdeschd>
-</chhead>
-<chrow><choption>To import all the data to a table, where the import file
-contains the LOB data</choption><chdesc><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
+<info><simpletable>
+<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 (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/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></chdesc>
-</chrow>
-<chrow><choption>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</choption><chdesc><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/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/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/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> </chdesc>
-</chrow>
-<chrow><choption>To import data from a file to a subset of columns in a table,
-where the import file contains the LOB data</choption><chdesc><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
+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 (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/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/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></chdesc></chrow>
-<chrow><choption>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</choption><chdesc><codeblock>SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE
(IN <xref
-href="rtoolsimport64241.dita#rtoolsimport64241/rtoolsimportschemaname">SCHEMANAME</xref>
VARCHAR(128),  IN <xref
+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 (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/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/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></chdesc>
-</chrow>
-</choicetable>
-</step>
+import file must be <codeph>lobsFileName.Offset.length/</codeph>.</p></stentry>
+</strow>
+</simpletable></info></step>
 </steps>
 </taskbody>
 </task>



Mime
View raw message