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 sc...@apache.org on 2007/07/05 18:30:37 UTC
svn commit: r553554 - in /db/derby/docs/branches/10.3/src/tools:
ctoolsimportjdbc.dita derbytools.ditamap rtoolsijproprefexceptiontrace.dita
rtoolsimport91458.dita ttoolsimporting.dita
Author: scotsmatrix
Date: Thu Jul 5 09:30:35 2007
New Revision: 553554
URL: http://svn.apache.org/viewvc?view=rev&rev=553554
Log:
Derby-2853: Updated examples for import and export. Adding to 10.3 branch. Patch contributed by me.
Modified:
db/derby/docs/branches/10.3/src/tools/ctoolsimportjdbc.dita
db/derby/docs/branches/10.3/src/tools/derbytools.ditamap
db/derby/docs/branches/10.3/src/tools/rtoolsijproprefexceptiontrace.dita
db/derby/docs/branches/10.3/src/tools/rtoolsimport91458.dita
db/derby/docs/branches/10.3/src/tools/ttoolsimporting.dita
Modified: db/derby/docs/branches/10.3/src/tools/ctoolsimportjdbc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.3/src/tools/ctoolsimportjdbc.dita?view=diff&rev=553554&r1=553553&r2=553554
==============================================================================
--- db/derby/docs/branches/10.3/src/tools/ctoolsimportjdbc.dita (original)
+++ db/derby/docs/branches/10.3/src/tools/ctoolsimportjdbc.dita Thu Jul 5 09:30:35 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/branches/10.3/src/tools/derbytools.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.3/src/tools/derbytools.ditamap?view=diff&rev=553554&r1=553553&r2=553554
==============================================================================
--- db/derby/docs/branches/10.3/src/tools/derbytools.ditamap (original)
+++ db/derby/docs/branches/10.3/src/tools/derbytools.ditamap Thu Jul 5 09:30:35 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/branches/10.3/src/tools/rtoolsijproprefexceptiontrace.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.3/src/tools/rtoolsijproprefexceptiontrace.dita?view=diff&rev=553554&r1=553553&r2=553554
==============================================================================
--- db/derby/docs/branches/10.3/src/tools/rtoolsijproprefexceptiontrace.dita (original)
+++ db/derby/docs/branches/10.3/src/tools/rtoolsijproprefexceptiontrace.dita Thu Jul 5 09:30:35 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/branches/10.3/src/tools/rtoolsimport91458.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.3/src/tools/rtoolsimport91458.dita?view=diff&rev=553554&r1=553553&r2=553554
==============================================================================
--- db/derby/docs/branches/10.3/src/tools/rtoolsimport91458.dita (original)
+++ db/derby/docs/branches/10.3/src/tools/rtoolsimport91458.dita Thu Jul 5 09:30:35 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/branches/10.3/src/tools/ttoolsimporting.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.3/src/tools/ttoolsimporting.dita?view=diff&rev=553554&r1=553553&r2=553554
==============================================================================
--- db/derby/docs/branches/10.3/src/tools/ttoolsimporting.dita (original)
+++ db/derby/docs/branches/10.3/src/tools/ttoolsimporting.dita Thu Jul 5 09:30:35 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>