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 bp...@apache.org on 2016/07/21 00:36:24 UTC
svn commit: r1753624 - in /db/derby/docs/trunk/src/ref: refderby.ditamap
rrefimportdatabulk.dita rrefimportdataproc.dita rrefimportdataproclobs.dita
rrefimporttablebulk.dita
Author: bpendleton
Date: Thu Jul 21 00:36:24 2016
New Revision: 1753624
URL: http://svn.apache.org/viewvc?rev=1753624&view=rev
Log:
DERBY-4555: Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines
DERBY-6895: Document new system procedures
This patch was contributed by Danoja Dias (danojadias at gmail dot com)
This patch adds two sections to the Reference Manual describing the new
SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK and SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK
system procedures.
It also makes small clarifying changes to the documentation of the
existing SYSCS_UTIL.SYSCS_IMPORT_DATA and
SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system procedures.
Added:
db/derby/docs/trunk/src/ref/rrefimportdatabulk.dita (with props)
db/derby/docs/trunk/src/ref/rrefimporttablebulk.dita (with props)
Modified:
db/derby/docs/trunk/src/ref/refderby.ditamap
db/derby/docs/trunk/src/ref/rrefimportdataproc.dita
db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita
Modified: db/derby/docs/trunk/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/refderby.ditamap?rev=1753624&r1=1753623&r2=1753624&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/refderby.ditamap (original)
+++ db/derby/docs/trunk/src/ref/refderby.ditamap Thu Jul 21 00:36:24 2016
@@ -40,8 +40,10 @@ limitations under the License.
<topicref href="rrefexportselectionproc.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure"></topicref>
<topicref href="rrefexportselectionproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system procedure"></topicref>
<topicref href="rrefimportdataproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure"></topicref>
+<topicref href="rrefimportdatabulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure"></topicref>
<topicref href="rrefimportdataproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system procedure"></topicref>
<topicref href="rrefimportproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure"></topicref>
+<topicref href="rrefimporttablebulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure"></topicref>
<topicref href="rrefimporttableproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE system procedure"></topicref>
</relcell>
</relrow>
@@ -54,8 +56,10 @@ limitations under the License.
<topicref href="rrefexportselectionproc.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure"></topicref>
<topicref href="rrefexportselectionproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system procedure"></topicref>
<topicref href="rrefimportdataproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure"></topicref>
+<topicref href="rrefimportdatabulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure"></topicref>
<topicref href="rrefimportdataproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system procedure"></topicref>
<topicref href="rrefimportproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure"></topicref>
+<topicref href="rrefimporttablebulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure"></topicref>
<topicref href="rrefimporttableproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE system procedure"></topicref>
</relcell>
</relrow>
@@ -68,8 +72,10 @@ limitations under the License.
<topicref href="rrefexportproctablelobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE system procedure"></topicref>
<topicref href="rrefexportselectionproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system procedure"></topicref>
<topicref href="rrefimportdataproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure"></topicref>
+<topicref href="rrefimportdatabulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure"></topicref>
<topicref href="rrefimportdataproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system procedure"></topicref>
<topicref href="rrefimportproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure"></topicref>
+<topicref href="rrefimporttablebulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure"></topicref>
<topicref href="rrefimporttableproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE system procedure"></topicref>
</relcell>
</relrow>
@@ -82,8 +88,10 @@ limitations under the License.
<topicref href="rrefexportproctablelobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE system procedure"></topicref>
<topicref href="rrefexportselectionproc.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure"></topicref>
<topicref href="rrefimportdataproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure"></topicref>
+<topicref href="rrefimportdatabulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure"></topicref>
<topicref href="rrefimportdataproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system procedure"></topicref>
<topicref href="rrefimportproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure"></topicref>
+<topicref href="rrefimporttablebulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure"></topicref>
<topicref href="rrefimporttableproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE system procedure"></topicref>
</relcell>
</relrow>
@@ -96,8 +104,26 @@ limitations under the License.
<topicref href="rrefexportproctablelobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE system procedure"></topicref>
<topicref href="rrefexportselectionproc.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure"></topicref>
<topicref href="rrefexportselectionproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system procedure"></topicref>
+<topicref href="rrefimportdatabulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure"></topicref>
<topicref href="rrefimportdataproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system procedure"></topicref>
<topicref href="rrefimportproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure"></topicref>
+<topicref href="rrefimporttablebulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure"></topicref>
+<topicref href="rrefimporttableproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE system procedure"></topicref>
+</relcell>
+</relrow>
+<relrow>
+<relcell>
+<topicref href="rrefimportdatabulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure"></topicref>
+</relcell>
+<relcell>
+<topicref href="rrefexportproc.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_TABLE system procedure"></topicref>
+<topicref href="rrefexportproctablelobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE system procedure"></topicref>
+<topicref href="rrefexportselectionproc.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure"></topicref>
+<topicref href="rrefexportselectionproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system procedure"></topicref>
+<topicref href="rrefimportdataproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure"></topicref>
+<topicref href="rrefimportdataproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system procedure"></topicref>
+<topicref href="rrefimportproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure"></topicref>
+<topicref href="rrefimporttablebulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure"></topicref>
<topicref href="rrefimporttableproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE system procedure"></topicref>
</relcell>
</relrow>
@@ -111,7 +137,9 @@ limitations under the License.
<topicref href="rrefexportselectionproc.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure"></topicref>
<topicref href="rrefexportselectionproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system procedure"></topicref>
<topicref href="rrefimportdataproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure"></topicref>
+<topicref href="rrefimportdatabulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure"></topicref>
<topicref href="rrefimportproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure"></topicref>
+<topicref href="rrefimporttablebulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure"></topicref>
<topicref href="rrefimporttableproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE system procedure"></topicref>
</relcell>
</relrow>
@@ -125,7 +153,25 @@ limitations under the License.
<topicref href="rrefexportselectionproc.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure"></topicref>
<topicref href="rrefexportselectionproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system procedure"></topicref>
<topicref href="rrefimportdataproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure"></topicref>
+<topicref href="rrefimportdatabulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure"></topicref>
+<topicref href="rrefimportdataproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system procedure"></topicref>
+<topicref href="rrefimporttablebulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure"></topicref>
+<topicref href="rrefimporttableproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE system procedure"></topicref>
+</relcell>
+</relrow>
+<relrow>
+<relcell>
+<topicref href="rrefimporttablebulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure"></topicref>
+</relcell>
+<relcell>
+<topicref href="rrefexportproc.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_TABLE system procedure"></topicref>
+<topicref href="rrefexportproctablelobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE system procedure"></topicref>
+<topicref href="rrefexportselectionproc.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure"></topicref>
+<topicref href="rrefexportselectionproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system procedure"></topicref>
+<topicref href="rrefimportdataproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure"></topicref>
+<topicref href="rrefimportdatabulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure"></topicref>
<topicref href="rrefimportdataproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system procedure"></topicref>
+<topicref href="rrefimportproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure"></topicref>
<topicref href="rrefimporttableproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE system procedure"></topicref>
</relcell>
</relrow>
@@ -139,8 +185,10 @@ limitations under the License.
<topicref href="rrefexportselectionproc.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure"></topicref>
<topicref href="rrefexportselectionproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system procedure"></topicref>
<topicref href="rrefimportdataproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure"></topicref>
+<topicref href="rrefimportdatabulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure"></topicref>
<topicref href="rrefimportdataproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system procedure"></topicref>
<topicref href="rrefimportproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure"></topicref>
+<topicref href="rrefimporttablebulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure"></topicref>
</relcell>
</relrow>
<relrow>
@@ -898,10 +946,14 @@ limitations under the License.
</topicref>
<topicref href="rrefimportdataproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure">
</topicref>
+<topicref href="rrefimportdatabulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure">
+</topicref>
<topicref href="rrefimportdataproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system procedure">
</topicref>
<topicref href="rrefimportproc.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure">
</topicref>
+<topicref href="rrefimporttablebulk.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure">
+</topicref>
<topicref href="rrefimporttableproclobs.dita" navtitle="SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE system procedure">
</topicref>
<topicref href="rrefproceduresinplacecompress.dita" navtitle="SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE system procedure">
Added: db/derby/docs/trunk/src/ref/rrefimportdatabulk.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimportdatabulk.dita?rev=1753624&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefimportdatabulk.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefimportdatabulk.dita Thu Jul 21 00:36:24 2016
@@ -0,0 +1,176 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<reference id="rrefimportdataprocwithheaderlines" xml:lang="en-us">
+<title>SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK system procedure</title>
+<shortdesc>The <codeph>SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK</codeph> system procedure
+supports all functionalities of <codeph>SYSCS_UTIL.SYSCS_IMPORT_DATA</codeph> with the additional
+feature to skip column headers in the input file and recognize columns in the input file by name
+that are parsed to the COLUMNINDEXES argument.</shortdesc>
+<refbody>
+<section>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph> issues a COMMIT or a
+ROLLBACK statement after each import and export procedure is run (a COMMIT if
+the procedure completes successfully, a ROLLBACK if it fails). For this reason,
+you should issue either a COMMIT or ROLLBACK statement to complete all
+transactions and release all table-level locks before you invoke an import or
+export procedure.</p>
+<p>For more information on using this procedure, see the section
+"Importing and exporting data" in the
+<ph conref="../conrefs.dita#pub/citadmin"></ph>.</p>
+</section>
+<section><title>Syntax</title><codeblock>SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK (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),
+IN CODESET VARCHAR(128), IN REPLACE SMALLINT,
+IN SKIP SMALLINT)</codeblock> <p>No result is
+returned from the procedure.</p> <dl><dlentry>
+<dt>SCHEMANAME</dt>
+<dd>An input argument of type VARCHAR(128) that specifies the schema of the
+table. Passing a NULL value will use the default schema name.</dd>
+</dlentry><dlentry>
+<dt>TABLENAME</dt>
+<dd>An input argument of type VARCHAR(128) that 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. Passing a null will result in
+an error.</dd>
+</dlentry><dlentry>
+<dt>INSERTCOLUMNS</dt>
+<dd>An input argument of type VARCHAR(32672) that specifies the column names
+(separated by commas) of the table into which the data is to be imported.
+Passing a NULL value will import the data into all of the columns of the table.</dd>
+</dlentry><dlentry>
+<dt>COLUMNINDEXES</dt>
+<dd>An input argument of type VARCHAR(32672) that specifies the indexes (numbered
+from 1 and separated by commas) and column names (double quoted, case sensitive
+and seperated by commas) of the input
+data fields to be imported. The input file columns can only be referenced
+by the column names if the SKIP argument is greater than 0. Passing a NULL
+value will use all of the input data
+fields in the file.</dd>
+</dlentry><dlentry>
+<dt>FILENAME</dt>
+<dd>An input argument of type VARCHAR(32672) that specifies the file that
+contains the data to be imported. If you do not specify a path, the current
+working directory is used. Passing a NULL value will result in an error.</dd>
+</dlentry><dlentry>
+<dt>COLUMNDELIMITER</dt>
+<dd>An input argument of type CHAR(1) that specifies a column delimiter. The
+specified character is used in place of a comma to signal the end of a column.
+Passing a NULL value will use the default value; the default value is a comma
+(,).</dd>
+</dlentry><dlentry>
+<dt>CHARACTERDELIMITER</dt>
+<dd>An input argument of type CHAR(1) that specifies a character delimiter.
+ The specified character is used in place of double quotation marks to enclose
+a character string. Passing a NULL value will use the default value; the default
+value is a double quotation mark (").</dd>
+</dlentry><dlentry>
+<dt>CODESET</dt>
+<dd>An input argument of type VARCHAR(128) that specifies the code set of
+the data in the input file. The name of the code set should be one of the
+Java-supported character encodings. Data is converted from the specified code
+set to the database code set (utf-8). Passing a NULL value will interpret
+the data file in the same code set as the JVM in which it is being executed.</dd>
+</dlentry><dlentry>
+<dt>REPLACE</dt>
+<dd>An input argument of type SMALLINT. A non-zero value will run in REPLACE
+mode, while a value of zero will run in INSERT mode. REPLACE mode deletes
+all existing data from the table by truncating the data object, and inserts
+the imported data. The table definition and the index definitions are not
+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><dlentry>
+<dt>SKIP</dt>
+<dd>An input argument of type SMALLINT.
+SKIP number of header lines will be ignored and rest
+of lines in the input file will be imported to the table</dd>
+</dlentry></dl><p>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 uppercase
+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.</p></section>
+<section><title>Execute privileges</title>
+<p>If authentication and SQL authorization are both enabled, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure by default. See "Configuring user
+authentication" and "Configuring user authorization" in the
+<ph conref="../conrefs.dita#pub/citsec"></ph> for more information. The
+database owner can grant access to other users. The user must also have INSERT
+privileges on the table.</p>
+</section>
+
+<section><title>Example</title><p>The following examples import
+data fields from a delimited data file called <codeph>petlist.del</codeph> into
+the <codeph>PET</codeph> table ignoring SKIP number of header lines and importing rest of
+the input file. This examples also show parsing column name to the COLUMNINDEXES
+argument.
+<dl><dlentry><dt>Example 1</dt><dd>
+This example shows one header line in the input file.
+Data contained in the input file petlist.del is given below.
+<codeblock>
+Pet Name,Kind of Animal,Age
+Rover,Dog,4
+Spot,cat,2
+Squawky,Parrot,37
+</codeblock>
+<codeblock>CALL SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK
+ (NULL, 'PET', NULL, '\"Pet Name\",2,3', 'petlist.del', NULL, NULL, NULL, 0, 1)</codeblock>
+This procedure identifies the column by name as given in the example.
+When data is imported from the input file, first line in the input file is ignored.
+That is the number of lines given in the SKIP argument. Rest of the lines in the input
+file are imported.
+This means that first line <codeblock>
+Pet Name,Kind of Animal,Age </codeblock>is ignored and next three lines,
+<codeblock>Rover,Dog,4
+Spot,cat,2
+Squawky,Parrot,37</codeblock> are imported.</dd></dlentry>
+<dlentry><dt>Example 2</dt>
+<dd>This example shows three header lines in the input file.
+Data contained in the input file petlist.del is given below.
+<codeblock>
+Pet,Kind,Age
+Name,of,
+,Animal,
+Rover,Dog,4
+Spot,cat,2
+Squawky,Parrot,37
+</codeblock>
+<codeblock>CALL SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK
+(NULL, 'PET', NULL, '1,\"Kind of Animal\",3', 'petlist.del', NULL, NULL, NULL, 0, 3)</codeblock>
+When data is imported from the input file, first three lines in the input file are ignored.
+That is the number of lines given in the SKIP argument. Rest of the lines in the input
+file are imported.
+This means that first three lines <codeblock>
+Pet,Kind,Age
+Name,of,
+,Animal,
+</codeblock>are ignored and next three lines,
+<codeblock>
+Rover,Dog,4
+Spot,cat,2
+Squawky,Parrot,37</codeblock>
+are imported.</dd></dlentry>
+</dl></p></section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ref/rrefimportdatabulk.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: db/derby/docs/trunk/src/ref/rrefimportdataproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimportdataproc.dita?rev=1753624&r1=1753623&r2=1753624&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefimportdataproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefimportdataproc.dita Thu Jul 21 00:36:24 2016
@@ -59,7 +59,8 @@ Passing a NULL value will import the dat
</dlentry><dlentry>
<dt>COLUMNINDEXES</dt>
<dd>An input argument of type VARCHAR(32672) that specifies the indexes (numbered
-from 1 and separated by commas) of the input data fields to be imported. Passing
+from 1 and separated by commas) of the input data fields to be imported.
+This argument cannot identify column names as in <codeph>SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK procedure</codeph>. Passing
a NULL value will use all of the input data fields in the file.</dd>
</dlentry><dlentry>
<dt>FILENAME</dt>
Modified: db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita?rev=1753624&r1=1753623&r2=1753624&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita Thu Jul 21 00:36:24 2016
@@ -71,7 +71,8 @@ argument that is a VARCHAR(32672) data t
<dd>Specifies the comma separated column indexes (numbered from one) of the
input data fields that will be imported. You can specify a NULL value to use
all input data fields in the file. The <parmname>COLUMNINDEXES</parmname> parameter
-takes an input argument that is a VARCHAR(32672) data type.</dd>
+takes an input argument that is a VARCHAR(32672) data type.
+This argument cannot identify column names as in <codeph>SYSCS_UTIL.SYSCS_IMPORT_DATA_BULK procedure</codeph>.</dd>
</dlentry><dlentry>
<dt>FILENAME</dt>
<dd>Specifies the name of the file that contains the data to be imported.
Added: db/derby/docs/trunk/src/ref/rrefimporttablebulk.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimporttablebulk.dita?rev=1753624&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefimporttablebulk.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefimporttablebulk.dita Thu Jul 21 00:36:24 2016
@@ -0,0 +1,125 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<reference id="rrefimporttableprocwithheaderlines" xml:lang="en-us">
+<title>SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK system procedure</title>
+<shortdesc>The <codeph>SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK</codeph> system procedure supports all
+functionalities of <codeph>SYSCS_UTIL.SYSCS_IMPORT_TABLE</codeph> with the additional feature to skip column headers in the input file.
+</shortdesc>
+<refbody>
+<section>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph> issues a COMMIT or a
+ROLLBACK statement after each import and export procedure is run (a COMMIT if
+the procedure completes successfully, a ROLLBACK if it fails). For this reason,
+you should issue either a COMMIT or ROLLBACK statement to complete all
+transactions and release all table-level locks before you invoke an import or
+export procedure.</p>
+<p>For more information on using this procedure, see the section
+"Importing and exporting data" in the
+<ph conref="../conrefs.dita#pub/citadmin"></ph>.</p>
+</section>
+<section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_IMPORT_TABLE_BULK (IN SCHEMANAME VARCHAR(128),
+IN TABLENAME VARCHAR(128), IN FILENAME VARCHAR(32672),
+IN COLUMNDELIMITER CHAR(1), IN CHARACTERDELIMITER CHAR(1),
+IN CODESET VARCHAR(128), IN REPLACE SMALLINT
+IN SKIP SMALLINT)</codeblock> <p>No result is
+returned from the procedure.</p> <dl><dlentry>
+<dt>SCHEMANAME</dt>
+<dd>An input argument of type VARCHAR(128) that specifies the schema of the
+table. Passing a NULL value will use the default schema name.</dd>
+</dlentry><dlentry>
+<dt>TABLENAME</dt>
+<dd>An input argument of type VARCHAR (128) that 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. Passing a null will result in
+an error.</dd>
+</dlentry><dlentry>
+<dt>FILENAME</dt>
+<dd>An input argument of type VARCHAR(32672) that specifies the file that
+contains the data to be imported. If you do not specify a path, the current
+working directory is used. Passing a NULL value will result in an error.</dd>
+</dlentry><dlentry>
+<dt>COLUMNDELIMITER</dt>
+<dd>An input argument of type CHAR(1) that specifies a column delimiter. The
+specified character is used in place of a comma to signal the end of a column.
+Passing a NULL value will use the default value; the default value is a comma
+(,).</dd>
+</dlentry><dlentry>
+<dt>CHARACTERDELIMITER</dt>
+<dd>An input argument of type CHAR(1) that specifies a character delimiter.
+ The specified character is used in place of double quotation marks to enclose
+a character string. Passing a NULL value will use the default value; the default
+value is a double quotation mark (").</dd>
+</dlentry><dlentry>
+<dt>CODESET</dt>
+<dd>An input argument of type VARCHAR(128) that specifies the code set of
+the data in the input file. The name of the code set should be one of the
+Java-supported character encodings. Data is converted from the specified code
+set to the database code set (utf-8). Passing a NULL value will interpret
+the data file in the same code set as the JVM in which it is being executed.</dd>
+</dlentry><dlentry>
+<dt>REPLACE</dt>
+<dd>An input argument of type SMALLINT. A non-zero value will run in REPLACE
+mode, while a value of zero will run in INSERT mode. REPLACE mode deletes
+all existing data from the table by truncating the data object, and inserts
+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><dlentry>
+<dt>SKIP</dt>
+<dd>An input argument of type SMALLINT.
+SKIP number of header lines will be ignored and rest
+of lines in the input file will be imported to the table</dd>
+</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 uppercase
+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>Execute privileges</title>
+<p>If authentication and SQL authorization are both enabled, only the
+<xref href="rrefattrib26867.dita#rrefattrib26867">database owner</xref> has
+execute privileges on this procedure by default. See "Configuring user
+authentication" and "Configuring user authorization" in the
+<ph conref="../conrefs.dita#pub/citsec"></ph> for more information. The
+database owner can grant access to other users. The user must also have INSERT
+privileges on the table.</p>
+</section>
+<section><title>Example</title><p>The following example imports data into
+the <codeph>PET</codeph> table from a delimited data file called <codeph>petlist.del</codeph>
+Data contained in the input file petlist.del is given below.
+<codeblock>
+Pet Name,Kind of Animal,Age
+Rover,Dog,4
+Spot,cat,2
+Squawky,Parrot,37
+</codeblock>
+
+<codeblock>CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
+(null, 'PET', 'c:/output/petlist.del', null, null, null, 0, 1);</codeblock>
+
+When data is imported from the input file, first line in the input file is ignored.
+That is the number of lines given in the SKIP argument. Rest of the lines in the input
+file is imported.
+This means that first line <codeblock>
+Pet Name,Kind of Animal,Age </codeblock>is ignored and other three lines,<codeblock>Rover,Dog,4
+Spot,cat,2
+Squawky,Parrot,37</codeblock> are imported.</p></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ref/rrefimporttablebulk.dita
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: db/derby/docs/trunk/src/ref/rrefimporttablebulk.dita
------------------------------------------------------------------------------
svn:mime-type = text/xml