db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1129870 - in /db/derby/docs/branches/10.8/src: getstart/ ref/ tuning/
Date Tue, 31 May 2011 19:33:13 GMT
Author: chaase3
Date: Tue May 31 19:33:13 2011
New Revision: 1129870

URL: http://svn.apache.org/viewvc?rev=1129870&view=rev
Log:
DERBY-1780  Document all supplied system procedures in the Server and Administration Guide
(e.g. class loading utils and import/export)

Merged DERBY-1780-3.diff to 10.8 code branch from trunk revision 1129857.

Modified:
    db/derby/docs/branches/10.8/src/getstart/cgsusingtoolsutils.dita
    db/derby/docs/branches/10.8/src/getstart/rgsdocs17307.dita
    db/derby/docs/branches/10.8/src/ref/rrefexportproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefexportproctablelobs.dita
    db/derby/docs/branches/10.8/src/ref/rrefexportselectionproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefexportselectionproclobs.dita
    db/derby/docs/branches/10.8/src/ref/rrefimportdataproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefimportdataproclobs.dita
    db/derby/docs/branches/10.8/src/ref/rrefimportproc.dita
    db/derby/docs/branches/10.8/src/ref/rrefimporttableproclobs.dita
    db/derby/docs/branches/10.8/src/tuning/ctunperf16800.dita

Modified: db/derby/docs/branches/10.8/src/getstart/cgsusingtoolsutils.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/getstart/cgsusingtoolsutils.dita?rev=1129870&r1=1129869&r2=1129870&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/getstart/cgsusingtoolsutils.dita (original)
+++ db/derby/docs/branches/10.8/src/getstart/cgsusingtoolsutils.dita Tue May 31 19:33:13 2011
@@ -60,7 +60,8 @@ and the full connection URL to the Netwo
 addition, there are Derby utilities that are system procedures that you can
 call by using the <codeph>ij</codeph> tool. For example, there are system
 procedures that you can use to import and export external files. Instructions
-on how to use these system procedures are included in the <cite><ph conref="../conrefs.dita#pub/citutilities"></ph></cite>
and
-the <cite><ph conref="../conrefs.dita#pub/citref"></ph></cite>.</p></section>
+on how to use these system procedures are included in the 
+<ph conref="../conrefs.dita#pub/citadmin"></ph> and the
+<ph conref="../conrefs.dita#pub/citref"></ph>.</p></section>
 </conbody>
 </concept>

Modified: db/derby/docs/branches/10.8/src/getstart/rgsdocs17307.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/getstart/rgsdocs17307.dita?rev=1129870&r1=1129869&r2=1129870&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/getstart/rgsdocs17307.dita (original)
+++ db/derby/docs/branches/10.8/src/getstart/rgsdocs17307.dita Tue May 31 19:33:13 2011
@@ -56,17 +56,17 @@ about the <ph conref="../conrefs.dita#pr
 </dlentry><dlentry>
 <dt><ph conref="../conrefs.dita#pub/citutilities"></ph></dt>
 <dd>Describes how to use the <ph conref="../conrefs.dita#prod/productshortname"></ph>
tools
-such as <codeph>dblook</codeph>, <codeph>ij</codeph>, and <codeph>sysinfo</codeph>,
-and how to use the system procedures to import and export data, and how to
-store Java code in the database.</dd>
+such as <codeph>dblook</codeph>, <codeph>ij</codeph>, and
+<codeph>sysinfo</codeph>.</dd>
 </dlentry><dlentry>
 <dt><ph conref="../conrefs.dita#pub/citadmin"></ph></dt>
 <dd>Part One of this guide discusses configuring servers, how to program client
 applications, and database administration. In addition, some systems might
 require administrative tasks such as backing up databases. These tasks are
 independent of any server framework but are unique to multi-user or large
-systems. <p>Part Two of this guide discusses administrative issues such as
-backups and debugging deadlocks.</p></dd>
+systems. <p>Part Two of this guide discusses administrative tasks such as
+backing up and restoring databases, importing and exporting data, storing
+Java code in the database, and debugging deadlocks.</p></dd>
 </dlentry><dlentry>
 <dt><ph conref="../conrefs.dita#prod/productshortname"></ph> API Reference</dt>
 <dd>An API Reference that is automatically generated for all public <ph conref="../conrefs.dita#prod/productshortname"></ph>
classes.

Modified: db/derby/docs/branches/10.8/src/ref/rrefexportproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefexportproc.dita?rev=1129870&r1=1129869&r2=1129870&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefexportproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefexportproc.dita Tue May 31 19:33:13 2011
@@ -79,8 +79,10 @@ you must pass the name to the export pro
 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>Usage</title><p>For additional information on using
this procedure
-see the section "Using the bulk import and export procedures" in the <ph conref="../conrefs.dita#pub/citutilities"></ph>.</p></section>
+<section><title>Usage</title>
+<p>For additional 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>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>

Modified: db/derby/docs/branches/10.8/src/ref/rrefexportproctablelobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefexportproctablelobs.dita?rev=1129870&r1=1129869&r2=1129870&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefexportproctablelobs.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefexportproctablelobs.dita Tue May 31 19:33:13 2011
@@ -99,8 +99,10 @@ identifier, you must pass the name to th
 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.</p></section>
-<section><title>Usage</title><p>For additional information on using
this procedure
-see the section "Using the bulk import and export procedures" in the <ph conref="../conrefs.dita#pub/citutilities"></ph>.</p></section>
+<section><title>Usage</title>
+<p>For additional 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>Example exporting all data from a table, using a separate
 export file for the LOB data</title><p>The following example shows how to
 export data from the STAFF table in a sample database to the main file <codeph>staff.del</codeph>
and

Modified: db/derby/docs/branches/10.8/src/ref/rrefexportselectionproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefexportselectionproc.dita?rev=1129870&r1=1129869&r2=1129870&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefexportselectionproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefexportselectionproc.dita Tue May 31 19:33:13 2011
@@ -70,8 +70,10 @@ Java-supported character encodings. Data
 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>Usage</title><p>For additional information on using
this procedure
-see the section "Using the bulk import and export procedures" in the <ph conref="../conrefs.dita#pub/citutilities"></ph>.</p></section>
+<section><title>Usage</title>
+<p>For additional 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>Example</title> <p>The following example shows how
to export
 the information about employees in Department 20 from the STAFF table in the
 SAMPLE database to the <codeph>myfile.del</codeph> file.       </p> <codeblock>CALL
SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from staff where dept =20',

Modified: db/derby/docs/branches/10.8/src/ref/rrefexportselectionproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefexportselectionproclobs.dita?rev=1129870&r1=1129869&r2=1129870&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefexportselectionproclobs.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefexportselectionproclobs.dita Tue May 31 19:33:13
2011
@@ -87,8 +87,10 @@ If you are using the Network Server, the
 Specifying a NULL value results in an error. The <parmname>LOBSFILENAME</parmname>
parameter
 takes an input argument that is a VARCHAR (32672) data type.</dd>
 </dlentry></dl></section>
-<section><title>Usage</title><p>For additional information on using
this procedure
-see the section "Using the bulk import and export procedures" in the <ph conref="../conrefs.dita#pub/citutilities"></ph>.</p></section>
+<section><title>Usage</title>
+<p>For additional 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>Example exporting data from a query using a separate export
 file for the LOB data</title>The following example shows how to export employee
 data in department 20 from the STAFF table in a sample database to the main

Modified: db/derby/docs/branches/10.8/src/ref/rrefimportdataproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefimportdataproc.dita?rev=1129870&r1=1129869&r2=1129870&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefimportdataproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefimportdataproc.dita Tue May 31 19:33:13 2011
@@ -88,8 +88,10 @@ identifier, you must pass the name to th
 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>Usage</title><p>For additional information on using
this procedure
-see the section "Using the bulk import and export procedures" in the <ph conref="../conrefs.dita#pub/citutilities"></ph>.</p></section>
+<section><title>Usage</title>
+<p>For additional 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>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

Modified: db/derby/docs/branches/10.8/src/ref/rrefimportdataproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefimportdataproclobs.dita?rev=1129870&r1=1129869&r2=1129870&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefimportdataproclobs.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefimportdataproclobs.dita Tue May 31 19:33:13 2011
@@ -108,8 +108,9 @@ the reference that is stored in the main
 to the LOB stored in the main import file must be <codeph>lobsFileName.Offset.length/</codeph>.
</p><ul>
 <li><codeph>Offset</codeph> is position in the external file in bytes</li>
 <li><codeph>length</codeph> is the size of the LOB column data in bytes</li>
-</ul><p>For additional information on using this procedure see the section
-"Using the bulk import and export procedures" in the <ph conref="../conrefs.dita#pub/citutilities"></ph>.</p></section>
+</ul><p>For additional 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>Example importing data into specific columns, using a separate
 import file for the LOB data</title>The following example shows how to import
 data into several columns of the STAFF table. The STAFF table includes a LOB

Modified: db/derby/docs/branches/10.8/src/ref/rrefimportproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefimportproc.dita?rev=1129870&r1=1129869&r2=1129870&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefimportproc.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefimportproc.dita Tue May 31 19:33:13 2011
@@ -76,8 +76,10 @@ identifier, you must pass the name to th
 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>Usage</title><p>For additional information on using
this procedure
-see the section "Using the bulk import and export procedures" in the <ph conref="../conrefs.dita#pub/citutilities"></ph>.</p></section>
+<section><title>Usage</title>
+<p>For additional 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>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 (;)

Modified: db/derby/docs/branches/10.8/src/ref/rrefimporttableproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefimporttableproclobs.dita?rev=1129870&r1=1129869&r2=1129870&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefimporttableproclobs.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefimporttableproclobs.dita Tue May 31 19:33:13 2011
@@ -94,8 +94,9 @@ from a non-Derby source, the format of t
 the main import file must be <codeph>lobsFileName.Offset.length/</codeph>. </p><ul>
 <li><codeph>Offset</codeph> is position in the external file in bytes</li>
 <li><codeph>length</codeph> is the size of the LOB column data in bytes</li>
-</ul><p>For additional information on using this procedure see the section
-"Using the bulk import and export procedures" in the <ph conref="../conrefs.dita#pub/citutilities"></ph>.</p></section>
+</ul><p>For additional 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>Example importing data from a main import file that contains
 references which point to a separate file that contains LOB data</title><p>The
 following example shows how to import data into the <i>STAFF</i> table in

Modified: db/derby/docs/branches/10.8/src/tuning/ctunperf16800.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/tuning/ctunperf16800.dita?rev=1129870&r1=1129869&r2=1129870&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/tuning/ctunperf16800.dita (original)
+++ db/derby/docs/branches/10.8/src/tuning/ctunperf16800.dita Tue May 31 19:33:13 2011
@@ -29,9 +29,11 @@ not return until a physical disk write i
 <li>Run in autocommit false mode, execute a number of inserts in one transaction,
 and then explicitly issue a commit.</li>
 <li>If your application allows an initial load into the table, you can use
-the import procedures to insert data into a table. <ph conref="../conrefs.dita#prod/productshortname"></ph>
will
+the import procedures to insert data into a table. 
+<ph conref="../conrefs.dita#prod/productshortname"></ph> will
 not log the individual inserts when loading into an empty table using these
-interfaces. See the <cite><ph conref="../conrefs.dita#pub/citutilities"></ph>
Guide</cite> for
+interfaces. See the <ph conref="../conrefs.dita#pub/citref"></ph> and the
+<ph conref="../conrefs.dita#pub/citadmin"></ph> for
 more information on the import procedures.</li>
 </ul></p>
 </conbody>



Mime
View raw message