Hi, Laura,
I've been looking at this, and the main problem is with the fact that
the codeblocks are all on one line. Rather than just remove them as Dag
suggests, you can insert line breaks. Here are some fixed-up versions.
For the exporting topic I changed the choicetable to a simpletable to
match the importing topic, but I've attached the choicetable version in
case you want to keep it, or convert the importing one to a choicetable.
HTH,
Kim
Laura Stewart wrote:
An issue was reported during 10.3 testing about the table in this file
http://db.apache.org/derby/docs/dev/tools/ttoolsimporting.html
When I looked at the tagging for the choicetable, there did not appear
to be anything wrong with the tagging. But I changed the table to a
simpletable. However the appearance did not change.
This problem also appears in the table in this file:
http://db.apache.org/derby/docs/dev/tools/ttoolsexporting.html
When I looked at other tables in the the docs, they do not appear to
have this problem.
Any ideas as to what can be causing this?
-
Laura Stewart
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE task PUBLIC "-//OASIS//DTD DITA Task//EN"
"../dtd/task.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.
-->
<!--##### DO NOT CHANGE ANYTHING ABOVE THIS LINE #####-->
<task id="ttoolsimporting" xml:lang="en-us">
<title>Importing data using the built-in procedures</title>
<shortdesc>You can use the <ph conref="../conrefs.dita#prod/productshortname"></ph> import
procedures to import all of the data from table or query, or to import LOB
data separately from the other data.</shortdesc>
<prolog><metadata>
<keywords><indexterm>import and export procedures<indexterm>bulk import</indexterm></indexterm>
<indexterm>importing data</indexterm><indexterm>system procedures<indexterm>import
using</indexterm></indexterm></keywords>
</metadata></prolog>
<taskbody>
<context></context>
<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>
<info><simpletable relcolwidth="1* 2*">
<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/rtoolsimportcodesetarg">CODESET</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/rtoolsimportcolumndelimiter">COLUMNDELIMITER</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></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/rtoolsimportcolumndelimiter">COLUMNDELIMITER</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></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/rtoolsimportcolumndelimiter">COLUMNDELIMITER</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></stentry>
</strow>
</simpletable></info></step>
</steps>
</taskbody>
</task>
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE task PUBLIC "-//OASIS//DTD DITA Task//EN"
"../dtd/task.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.
-->
<!--##### DO NOT CHANGE ANYTHING ABOVE THIS LINE #####-->
<task id="ttoolsexporting" xml:lang="en-us">
<title>Exporting data using the built-in procedures</title>
<shortdesc>You can use the <ph conref="../conrefs.dita#prod/productshortname"></ph> export
procedures to export all of the data from table or query, or to export LOB
data separately from the other data.</shortdesc>
<prolog><metadata>
<keywords><indexterm>import and export procedures<indexterm>bulk export</indexterm></indexterm>
<indexterm>exporting data</indexterm><indexterm>system procedures<indexterm>export
using</indexterm></indexterm></keywords>
</metadata></prolog>
<taskbody>
<context></context>
<steps>
<step><cmd>Choose the correct procedure for the type of export that you want
to perform. For examples of these procedures, see <xref href="rtoolsimport91458.dita#rtoolsimport91458"></xref>.</cmd>
<info><simpletable relcolwidth="1* 2*">
<sthead><stentry>Type of export</stentry><stentry>Procedure to use</stentry>
</sthead>
<strow><stentry>To export all the data from a table to a single export file,
including the LOB data </stentry><stentry> <codeblock>SYSCS_UTIL.SYSCS_EXPORT_TABLE
(IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportschemaname">SCHEMANAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexporttablename">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportfilename">FILENAME</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcolumndelimiter">COLUMNDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128))</codeblock></stentry>
</strow>
<strow><stentry>To export all the data from a table, and place the LOB data
into a separate export file</stentry><stentry><codeblock>SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE
(IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportschemaname">SCHEMANAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexporttablename">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportfilename">FILENAME</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcolumndelimiter">COLUMNDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportlobsfilename">LOBSFILNAME</xref> VARCHAR(32672))</codeblock><p>A
reference to the location of the LOB data is placed in the LOB column in the
main export file.</p> </stentry></strow>
<strow><stentry>To export the result of a SELECT statement to a single file,
including the LOB data</stentry><stentry><codeblock>SYSCS_UTIL.SYSCS_EXPORT_QUERY
(IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportselectstatement">SELECTSTATEMENT</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexporttablename">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportfilename">FILENAME</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcolumndelimiter">COLUMNDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128))</codeblock></stentry>
</strow>
<strow><stentry>To export the result of a SELECT statement to a main export
file, and place the LOB data into a separate export file</stentry><stentry><codeblock>SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
(IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportselectstatement">SELECTSTATEMENT</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexporttablename">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportfilename">FILENAME</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcolumndelimiter">COLUMNDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportlobsfilename">LOBSFILENAME</xref> VARCHAR(32672))</codeblock><p>A
reference to the LOB data is written to the main export file.</p></stentry>
</strow>
</simpletable></info>
</step>
</steps>
</taskbody>
</task>
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE task PUBLIC "-//OASIS//DTD DITA Task//EN"
"../dtd/task.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.
-->
<!--##### DO NOT CHANGE ANYTHING ABOVE THIS LINE #####-->
<task id="ttoolsexporting" xml:lang="en-us">
<title>Exporting data using the built-in procedures</title>
<shortdesc>You can use the <ph conref="../conrefs.dita#prod/productshortname"></ph> export
procedures to export all of the data from table or query, or to export LOB
data separately from the other data.</shortdesc>
<prolog><metadata>
<keywords><indexterm>import and export procedures<indexterm>bulk export</indexterm></indexterm>
<indexterm>exporting data</indexterm><indexterm>system procedures<indexterm>export
using</indexterm></indexterm></keywords>
</metadata></prolog>
<taskbody>
<context></context>
<steps>
<step><cmd>Choose the correct procedure for the type of export 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 export</choptionhd><chdeschd>Procedure to use</chdeschd>
</chhead>
<chrow><choption>To export all the data from a table to a single export file,
including the LOB data </choption><chdesc> <codeblock>SYSCS_UTIL.SYSCS_EXPORT_TABLE
(IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportschemaname">SCHEMANAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexporttablename">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportfilename">FILENAME</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcolumndelimiter">COLUMNDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128))</codeblock></chdesc>
</chrow>
<chrow><choption>To export all the data from a table, and place the LOB data
into a separate export file</choption><chdesc><codeblock>SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE
(IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportschemaname">SCHEMANAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexporttablename">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportfilename">FILENAME</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcolumndelimiter">COLUMNDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportlobsfilename">LOBSFILNAME</xref> VARCHAR(32672))</codeblock><p>A
reference to the location of the LOB data is placed in the LOB column in the
main export file.</p> </chdesc></chrow>
<chrow><choption>To export the result of a SELECT statement to a single file,
including the LOB data</choption><chdesc><codeblock>SYSCS_UTIL.SYSCS_EXPORT_QUERY
(IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportselectstatement">SELECTSTATEMENT</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexporttablename">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportfilename">FILENAME</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcolumndelimiter">COLUMNDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128))</codeblock></chdesc>
</chrow>
<chrow><choption>To export the result of a SELECT statement to a main export
file, and place the LOB data into a separate export file</choption><chdesc><codeblock>SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
(IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportselectstatement">SELECTSTATEMENT</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexporttablename">TABLENAME</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportfilename">FILENAME</xref> VARCHAR(32672),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcolumndelimiter">COLUMNDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcharacterdelimiter">CHARACTERDELIMITER</xref> CHAR(1),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportcodeset">CODESET</xref> VARCHAR(128),
IN <xref href="rtoolsexportarguements.dita#rtoolsexportarguements/rtoolsexportlobsfilename">LOBSFILENAME</xref> VARCHAR(32672))</codeblock><p>A
reference to the LOB data is written to the main export file.</p></chdesc>
</chrow>
</choicetable>
</step>
</steps>
</taskbody>
</task>
