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 fu...@apache.org on 2005/07/27 01:54:04 UTC
svn commit: r225427 - in /incubator/derby/docs/trunk/src: ref/ tools/
Author: fuzzylogic
Date: Tue Jul 26 16:53:55 2005
New Revision: 225427
URL: http://svn.apache.org/viewcvs?rev=225427&view=rev
Log:
DERBY-426: Document fix for DERBY-390
Committed for Jeff Levitt <de...@mylevita.com>
Modified:
incubator/derby/docs/trunk/src/ref/rrefexportproc.dita
incubator/derby/docs/trunk/src/ref/rrefimportdataproc.dita
incubator/derby/docs/trunk/src/ref/rrefimportproc.dita
incubator/derby/docs/trunk/src/tools/ctoolsimportidentitycol.dita
incubator/derby/docs/trunk/src/tools/ctoolsimportjdbc.dita
incubator/derby/docs/trunk/src/tools/rtoolsexportarguements.dita
incubator/derby/docs/trunk/src/tools/rtoolsimport64241.dita
incubator/derby/docs/trunk/src/tools/rtoolsimport91458.dita
incubator/derby/docs/trunk/src/tools/rtoolsimportcodeset.dita
Modified: incubator/derby/docs/trunk/src/ref/rrefexportproc.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefexportproc.dita?rev=225427&r1=225426&r2=225427&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefexportproc.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefexportproc.dita Tue Jul 26 16:53:55 2005
@@ -1,4 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
<!--
Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
@@ -14,9 +16,6 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
<reference id="rrefexportproc" xml:lang="en-us">
<title>SYSCS_UTIL.SYSCS_EXPORT_TABLE</title>
<refbody>
@@ -63,11 +62,14 @@
Java-supported character encodings. Data is converted from the database code
set to the specified code set before writing to the file. Passing a NULL value
will write the data in the same code set as the JVM in which it is being executed.</dd>
-</dlentry></dl></section>
-<section><title>Example</title> <p>The following example shows how to export
+</dlentry></dl>If you create a schema or table name as a non-delimited
+identifier, you must pass the name to the export procedure using all upper-case
+characters. If you created a schema, table, or column name as a delimited
+identifier, you must pass the name to the export procedure using the same
+case that was used when it was created.</section>
+<section><title>Example</title><p>The following example shows how to export
information from the STAFF table in a SAMPLE database to the <codeph>myfile.del</codeph> file.
- </p> <codeblock>CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'staff', 'myfile.del', null, null, null);</codeblock></section>
+ </p><codeblock>CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'STAFF', 'myfile.del', null, null, null);</codeblock></section>
<section><p>For more information on exporting, see the <i><ph conref="refconrefs.dita#pub/citutilities"></ph></i>.</p></section>
</refbody>
</reference>
-
Modified: incubator/derby/docs/trunk/src/ref/rrefimportdataproc.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefimportdataproc.dita?rev=225427&r1=225426&r2=225427&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefimportdataproc.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefimportdataproc.dita Tue Jul 26 16:53:55 2005
@@ -1,4 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
<!--
Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
@@ -14,17 +16,14 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
<reference id="rrefimportdataproc" xml:lang="en-us">
<title>SYSCS_UTIL.SYSCS_IMPORT_DATA</title>
<refbody>
-<section><p>The <codeph>SYSCS_UTIL.SYSCS_IMPORT_DATA</codeph> system
-procedure imports data to a subset of columns in a table. You choose the subset
-of columns by specifying insert columns. This procedure is also used to import
-a subset of column data from a file by specifying column indexes.</p></section>
-<section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_IMPORT_DATA (IN SCHEMANAME VARCHAR(128),
+<section><p>The <codeph>SYSCS_UTIL.SYSCS_IMPORT_DATA</codeph> system procedure
+imports data to a subset of columns in a table. You choose the subset of columns
+by specifying insert columns. This procedure is also used to import a subset
+of column data from a file by specifying column indexes.</p></section>
+<section><title>Syntax</title><codeblock>SYSCS_UTIL.SYSCS_IMPORT_DATA (IN SCHEMANAME VARCHAR(128),
IN TABLENAME VARCHAR(128), IN INSERTCOLUMNS VARCHAR(32672),
IN COLUMNINDEXES VARCHAR(32672), IN FILENAME VARCHAR(32672),
IN COLUMNDELIMITER CHAR(1), IN CHARACTERDELIMITER CHAR(1),
@@ -82,12 +81,15 @@
changed. You can only use the REPLACE mode if the table exists. INSERT mode
adds the imported data to the table without changing the existing table data.
Passing a NULL will result in an error.</dd>
-</dlentry></dl></section>
-<section><title>Example</title> <p>The following example imports some of the
+</dlentry></dl>If you create a schema, table, or column name as a non-delimited
+identifier, you must pass the name to the import procedure using all upper-case
+characters. If you created a schema, table, or column name as a delimited
+identifier, you must pass the name to the import procedure using the same
+case that was used when it was created.</section>
+<section><title>Example</title><p>The following example imports some of the
data fields from a delimited data file called <codeph>data.del</codeph> into
the <codeph>staff</codeph> table: <codeblock>CALL SYSCS_UTIL.SYSCS_IMPORT_DATA
-(NULL, 'staff', null, '1,3,4', 'data.del', null, null, null,0)</codeblock></p></section>
+(NULL, 'STAFF', null, '1,3,4', 'data.del', null, null, null,0)</codeblock></p></section>
<section><p>For more information on importing, see the <i><ph conref="refconrefs.dita#pub/citutilities"></ph></i>.</p></section>
</refbody>
</reference>
-
Modified: incubator/derby/docs/trunk/src/ref/rrefimportproc.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefimportproc.dita?rev=225427&r1=225426&r2=225427&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefimportproc.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefimportproc.dita Tue Jul 26 16:53:55 2005
@@ -1,4 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
<!--
Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
@@ -14,9 +16,6 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
<reference id="rrefimportproc" xml:lang="en-us">
<title>SYSCS_UTIL.SYSCS_IMPORT_TABLE</title>
<refbody>
@@ -70,13 +69,16 @@
the imported data. The table definition and the index definitions are not
changed. INSERT mode adds the imported data to the table without changing
the existing table data. Passing a NULL will result in an error.</dd>
-</dlentry></dl></section>
-<section><title>Example</title> <p>The following example imports data into
+</dlentry></dl>If you create a schema, table, or column name as a non-delimited
+identifier, you must pass the name to the import procedure using all upper-case
+characters. If you created a schema, table, or column name as a delimited
+identifier, you must pass the name to the import procedure using the same
+case that was used when it was created.</section>
+<section><title>Example</title><p>The following example imports data into
the <codeph>staff</codeph> table from a delimited data file called <codeph>myfile.del</codeph> with
the percentage character (%) as the string delimiter, and a semicolon (;)
as the column delimiter: <codeblock>CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
-(null, 'staff', 'c:/output/myfile.del', ';', '%', null,0);</codeblock></p></section>
+(null, 'STAFF', 'c:/output/myfile.del', ';', '%', null,0);</codeblock></p></section>
<section><p>For more information on importing, see the <i><ph conref="refconrefs.dita#pub/citutilities"></ph></i>.</p></section>
</refbody>
</reference>
-
Modified: incubator/derby/docs/trunk/src/tools/ctoolsimportidentitycol.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/ctoolsimportidentitycol.dita?rev=225427&r1=225426&r2=225427&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tools/ctoolsimportidentitycol.dita (original)
+++ incubator/derby/docs/trunk/src/tools/ctoolsimportidentitycol.dita Tue Jul 26 16:53:55 2005
@@ -1,4 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE concept PUBLIC "-//IBM//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
<!--
Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
@@ -14,9 +16,6 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-
-<!DOCTYPE concept PUBLIC "-//IBM//DTD DITA Concept//EN"
- "../dtd/concept.dtd">
<concept id="ctoolsimportidentitycol" xml:lang="en-us">
<title>Importing into tables with identity columns</title>
<conbody>
@@ -44,7 +43,7 @@
Leo,23.4,I</b> </codeblock> To import data from <codeph>myfile.del</codeph> into
the <i>tab1</i> table, explicitly list the column names for <i>tab1</i> without
the identity column <i>c2</i> and execute the SYSCS_UTIL.SYSCS_IMPORT_DATA
-procedure as follows: <codeblock><b>CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (NULL, 'tab1', 'c1,c3,c4' , null,
+procedure as follows: <codeblock><b>CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (NULL, 'TAB1', 'C1,C3,C4' , null,
'myfile.del',null, null,null,0)</b> </codeblock></li>
<li>Suppose you want import data into <i>tab1</i> from a file <codeph>empfile.del</codeph> that
also has identity column information and the file contains three fields with
@@ -54,9 +53,8 @@
the <i>tab1</i> table, explicitly specify an insert column list without the
identity column <i>c2</i> and specify the column indexes without identity
column data and execute the SYSCS_UTIL.SYSCS_IMPORT_DATA procedure as follows:
- <codeblock><b>CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (NULL, 'tab1', 'c1,c3,c4' , '1,3,4',
+ <codeblock><b>CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (NULL, 'TAB1', 'C1,C3,C4' , '1,3,4',
'empfile.del',null, null,null,0) </b> </codeblock></li>
</ul>
</conbody>
</concept>
-
Modified: incubator/derby/docs/trunk/src/tools/ctoolsimportjdbc.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/ctoolsimportjdbc.dita?rev=225427&r1=225426&r2=225427&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tools/ctoolsimportjdbc.dita (original)
+++ incubator/derby/docs/trunk/src/tools/ctoolsimportjdbc.dita Tue Jul 26 16:53:55 2005
@@ -30,7 +30,7 @@
<codeblock><b>PreparedStatement ps=conn.prepareStatement("CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE
(?,?,?,?,?,?)");
ps.setString(1,null);
-ps.setString(2,"staff");
+ps.setString(2,"STAFF");
ps.setString(3,"staff.dat");
ps.setString(4,"%");
ps.setString(5,null);
Modified: incubator/derby/docs/trunk/src/tools/rtoolsexportarguements.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/rtoolsexportarguements.dita?rev=225427&r1=225426&r2=225427&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tools/rtoolsexportarguements.dita (original)
+++ incubator/derby/docs/trunk/src/tools/rtoolsexportarguements.dita Tue Jul 26 16:53:55 2005
@@ -1,4 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
<!--
Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
@@ -14,48 +16,45 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtoolsexportarguements">
+<reference id="rtoolsexportarguements" xml:lang="en-us">
<title>Arguments to the export procedure</title>
<prolog><metadata>
-<keywords>
-</keywords>
-</metadata>
-</prolog>
-<refbody><section>
-<ul>
-<li><i id="rtoolsexportschemaname">schemaName</i>
-<p>Specifies the schema of the table. You can pass a NULL value to
-use the default schema name.</p></li>
-<li><i id="rtoolsexportselectstatement">selectStatement</i>
-<p>Specifies the SELECT statement query that returns
-the data to be exported. Passing a NULL value will result in an error.</p></li>
-<li><i id="rtoolsexporttablename">tableName</i>
-<p>Specifies the table name of the table or view from which the data
-is to be exported. This table cannot be a system table or a declared temporary
-table. The string must exactly match the case of the table name. Passing a null
-will result in an error.</p></li>
-<li><i id="rtoolsexportfilename">fileName</i>
-<p>Specifies the file to which the data is to be exported. If the path is omitted,
-the current working directory is used. If the name of a file that already
-exists is specified, the export utility overwrites the contents of the file;
-it does not append the information. The specified location of the file should
-refer to the server-side location if using the Network Server. Passing a null
-will result in an error.</p></li>
-<li><i id="rtoolsexportcolumndelimiter">columnDelimiter</i>
-<p>Specifies a column delimiter. The specified character
-is used in place of a comma to signify the end of a column. You can pass a
-NULL value to use the default value of a comma.</p></li>
-<li><i id="rtoolsexportcharacterdelimiter">characterDelimiter</i>
-<p>Specifies a character delimiter. The specified
-character is used in place of double quotation marks to enclose a character
-string. You can pass a NULL value to use the default value of a double quotation
-mark.</p></li>
-<li><i id="rtoolsexportcodeset">codeset</i>
-<p>Specifies the code set of the data in the export file. The code set name should
-be one of the Java-supported character encoding sets. Data is converted from
-the database code page to the specified code page before writing to the file.
-You can pass a NULL value to write the data in the same code page as the JVM
-in which it is being executed.</p></li>
-</ul></section>
-</refbody></reference>
+<keywords></keywords>
+</metadata></prolog>
+<refbody>
+<section> <ul>
+<li><i id="rtoolsexportschemaname">schemaName</i> <p>Specifies the schema
+of the table. You can pass a NULL value to use the default schema name.</p></li>
+<li><i id="rtoolsexportselectstatement">selectStatement</i> <p>Specifies
+the SELECT statement query that returns the data to be exported. Passing a
+NULL value will result in an error.</p></li>
+<li><i id="rtoolsexporttablename">tableName</i> <p>Specifies the table name
+of the table or view from which the data is to be exported. This table cannot
+be a system table or a declared temporary table. The string must exactly
+match the case of the table name. Passing a null will result in an error.</p></li>
+<li><i id="rtoolsexportfilename">fileName</i> <p>Specifies the file to which
+the data is to be exported. If the path is omitted, the current working directory
+is used. If the name of a file that already exists is specified, the export
+utility overwrites the contents of the file; it does not append the information.
+The specified location of the file should refer to the server-side location
+if using the Network Server. Passing a null will result in an error.</p></li>
+<li><i id="rtoolsexportcolumndelimiter">columnDelimiter</i> <p>Specifies
+a column delimiter. The specified character is used in place of a comma to
+signify the end of a column. You can pass a NULL value to use the default
+value of a comma.</p></li>
+<li><i id="rtoolsexportcharacterdelimiter">characterDelimiter</i> <p>Specifies
+a character delimiter. The specified character is used in place of double
+quotation marks to enclose a character string. You can pass a NULL value to
+use the default value of a double quotation mark.</p></li>
+<li><i id="rtoolsexportcodeset">codeset</i> <p>Specifies the code set of
+the data in the export file. The code set name should be one of the Java-supported
+character encoding sets. Data is converted from the database code page to
+the specified code page before writing to the file. You can pass a NULL value
+to write the data in the same code page as the JVM in which it is being executed.</p></li>
+</ul>If you create a schema, table, or column name as a non-delimited identifier,
+you must pass the name to the export procedure using all upper-case characters.
+If you created a schema or table name as a delimited identifier,
+you must pass the name to the export procedure using the same case that was
+used when it was created.</section>
+</refbody>
+</reference>
Modified: incubator/derby/docs/trunk/src/tools/rtoolsimport64241.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/rtoolsimport64241.dita?rev=225427&r1=225426&r2=225427&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tools/rtoolsimport64241.dita (original)
+++ incubator/derby/docs/trunk/src/tools/rtoolsimport64241.dita Tue Jul 26 16:53:55 2005
@@ -1,4 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
<!--
Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
@@ -14,59 +16,56 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtoolsimport64241">
+<reference id="rtoolsimport64241" xml:lang="en-us">
<title>Arguments to the import procedure</title>
<prolog><metadata>
-<keywords>
-</keywords>
-</metadata>
-</prolog>
-<refbody><section>
-<ul>
-<li><i id="rtoolsimportschemaname">schemaName</i>
-<p>Specifies the schema of the table. You can pass a NULL value to
-use the default schema name.</p></li>
-<li><i id="rtoolsimport27122">tableName</i>
-<p>Specifies the table name of the table into which the data is to
-be imported. This table cannot be a system table or a declared temporary table.
- The string must exactly match case of the table name. Passing a null will
-result in an error.</p></li>
-<li><i id="rtoolsimportinsertcolumns">insertColumns</i>
-<p>Specifies the comma separated column names of the table
-into which the data will be imported. You can pass a NULL value to import
-into all columns of the table.</p></li>
-<li><i id="rtoolsimportcolumnindexes">columnIndexes</i>
-<p>Specifies the comma separated column indexes (numbered
-from one) of the input data fields that will be imported. You can pass a NULL
-value to use all input data fields in the file.</p></li>
-<li><i id="rtoolsimportfilename">fileName</i>
-<p>Specifies the file that contains the data to be imported. If the path is omitted,
-the current working directory is used. The specified location of the file
-should refer to the server side location if using the Network Server. Passing
-a null will result in an error.</p></li>
-<li><i id="rtoolsimportcolumndelimiter">columnDelimiter</i>
-<p>Specifies a column delimiter. The specified character
-is used in place of a comma to signify the end of a column. You can pass a
-NULL value to use the default value of a comma.</p></li>
-<li><i id="rtoolsimportcharacterdelimiter">characterDelimiter</i>
-<p>Specifies a character delimiter. The specified
-character is used in place of double quotation marks to enclose a character
-string. You can pass a NULL value to use the default value of a double quotation
-mark.</p></li>
-<li><i id="rtoolsimportcodeset">codeset</i>
-<p>Specifies the code set of the data in the input file. The code set name should
-be one of the Java-supported character encoding sets. Data is converted from
-the specified code set to the database code set (<codeph>UTF-8</codeph>). You can
-pass a NULL value to interpret the data file in the same code set as the JVM
-in which it is being executed.</p></li>
-<li><i id="rtoolsimportreplace">replace</i>
-<p>A non-zero value for the <codeph>replace</codeph> parameter will import in REPLACE
-mode, while a zero value will import in INSERT mode. REPLACE mode deletes
-all existing data from the table by truncating the table and inserts the imported
-data. The table definition and the index definitions are not changed. You
-can only import with REPLACE mode if the table already exists. INSERT mode
-adds the imported data to the table without changing the existing table data.
-Passing a null value will result in an error.</p></li>
-</ul></section>
-</refbody></reference>
+<keywords></keywords>
+</metadata></prolog>
+<refbody>
+<section> <ul>
+<li><i id="rtoolsimportschemaname">schemaName</i> <p>Specifies the schema
+of the table. You can pass a NULL value to use the default schema name.</p></li>
+<li><i id="rtoolsimport27122">tableName</i> <p>Specifies the table name
+of the table into which the data is to be imported. This table cannot be a
+system table or a declared temporary table. The string must exactly match
+case of the table name. Passing a null will result in an error.</p></li>
+<li><i id="rtoolsimportinsertcolumns">insertColumns</i> <p>Specifies the
+comma separated column names of the table into which the data will be imported.
+You can pass a NULL value to import into all columns of the table.</p></li>
+<li><i id="rtoolsimportcolumnindexes">columnIndexes</i> <p>Specifies the
+comma separated column indexes (numbered from one) of the input data fields
+that will be imported. You can pass a NULL value to use all input data fields
+in the file.</p></li>
+<li><i id="rtoolsimportfilename">fileName</i> <p>Specifies the file that
+contains the data to be imported. If the path is omitted, the current working
+directory is used. The specified location of the file should refer to the
+server side location if using the Network Server. Passing a null will result
+in an error.</p></li>
+<li><i id="rtoolsimportcolumndelimiter">columnDelimiter</i> <p>Specifies
+a column delimiter. The specified character is used in place of a comma to
+signify the end of a column. You can pass a NULL value to use the default
+value of a comma.</p></li>
+<li><i id="rtoolsimportcharacterdelimiter">characterDelimiter</i> <p>Specifies
+a character delimiter. The specified character is used in place of double
+quotation marks to enclose a character string. You can pass a NULL value to
+use the default value of a double quotation mark.</p></li>
+<li><i id="rtoolsimportcodeset">codeset</i> <p>Specifies the code set of
+the data in the input file. The code set name should be one of the Java-supported
+character encoding sets. Data is converted from the specified code set to
+the database code set (<codeph>UTF-8</codeph>). You can pass a NULL value
+to interpret the data file in the same code set as the JVM in which it is
+being executed.</p></li>
+<li><i id="rtoolsimportreplace">replace</i> <p>A non-zero value for the <codeph>replace</codeph> parameter
+will import in REPLACE mode, while a zero value will import in INSERT mode.
+REPLACE mode deletes all existing data from the table by truncating the table
+and inserts the imported data. The table definition and the index definitions
+are not changed. You can only import with REPLACE mode if the table already
+exists. INSERT mode adds the imported data to the table without changing the
+existing table data. Passing a null value will result in an error.</p></li>
+</ul>If you create a schema, table, or column name as a non-delimited identifier,
+you must pass the name to the import procedure using all upper-case characters.
+If you created a schema, table, or column name as a delimited identifier,
+you must pass the name to the import procedure using the same case that was used when
+it was created.</section>
+</refbody>
+</reference>
Modified: incubator/derby/docs/trunk/src/tools/rtoolsimport91458.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/rtoolsimport91458.dita?rev=225427&r1=225426&r2=225427&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tools/rtoolsimport91458.dita (original)
+++ incubator/derby/docs/trunk/src/tools/rtoolsimport91458.dita Tue Jul 26 16:53:55 2005
@@ -1,4 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
<!--
Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
Modified: incubator/derby/docs/trunk/src/tools/rtoolsimportcodeset.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tools/rtoolsimportcodeset.dita?rev=225427&r1=225426&r2=225427&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tools/rtoolsimportcodeset.dita (original)
+++ incubator/derby/docs/trunk/src/tools/rtoolsimportcodeset.dita Tue Jul 26 16:53:55 2005
@@ -89,9 +89,9 @@
<section><p> The following example shows how to specify UTF-8 encoding to export from
the <i>staff</i> table:
<codeblock><b>CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE
-(NULL,'staff','staff.dat',NULL,NULL,'UTF-8')</b></codeblock></p></section>
+(NULL,'STAFF','staff.dat',NULL,NULL,'UTF-8')</b></codeblock></p></section>
<section><p> The following example shows how to specify UTF-8 encoding to import from
the <i>staff</i> table:
<codeblock><b>CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
-(NULL,'staff','staff.dat',NULL,NULL,'UTF-8',0)</b></codeblock></p></section>
+(NULL,'STAFF','staff.dat',NULL,NULL,'UTF-8',0)</b></codeblock></p></section>
</refbody></reference>