db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fuzzylo...@apache.org
Subject svn commit: r225427 - in /incubator/derby/docs/trunk/src: ref/ tools/
Date Tue, 26 Jul 2005 23:54:04 GMT
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 <derby@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>



Mime
View raw message