Usage

Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 82902 invoked by uid 99); 31 May 2011 19:09:11 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 May 2011 19:09:11 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 May 2011 19:09:07 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id C4F01238896F; Tue, 31 May 2011 19:08:45 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1129857 - in /db/derby/docs/trunk/src: getstart/ ref/ tuning/ Date: Tue, 31 May 2011 19:08:45 -0000 To: derby-commits@db.apache.org From: chaase3@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20110531190845.C4F01238896F@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Author: chaase3 Date: Tue May 31 19:08:45 2011 New Revision: 1129857 URL: http://svn.apache.org/viewvc?rev=1129857&view=rev Log: DERBY-1780 Document all supplied system procedures in the Server and Administration Guide (e.g. class loading utils and import/export) This patch modifies 8 topics in the Reference Manual, 2 in Getting Started, and 1 in the Tuning Guide. Patches: DERBY-1780-3.diff Modified: db/derby/docs/trunk/src/getstart/cgsusingtoolsutils.dita db/derby/docs/trunk/src/getstart/rgsdocs17307.dita db/derby/docs/trunk/src/ref/rrefexportproc.dita db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita db/derby/docs/trunk/src/ref/rrefimportdataproc.dita db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita db/derby/docs/trunk/src/ref/rrefimportproc.dita db/derby/docs/trunk/src/ref/rrefimporttableproclobs.dita db/derby/docs/trunk/src/tuning/ctunperf16800.dita Modified: db/derby/docs/trunk/src/getstart/cgsusingtoolsutils.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/getstart/cgsusingtoolsutils.dita?rev=1129857&r1=1129856&r2=1129857&view=diff ============================================================================== --- db/derby/docs/trunk/src/getstart/cgsusingtoolsutils.dita (original) +++ db/derby/docs/trunk/src/getstart/cgsusingtoolsutils.dita Tue May 31 19:08:45 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 ij 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 and -the .

+on how to use these system procedures are included in the + and the +.

Modified: db/derby/docs/trunk/src/getstart/rgsdocs17307.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/getstart/rgsdocs17307.dita?rev=1129857&r1=1129856&r2=1129857&view=diff ============================================================================== --- db/derby/docs/trunk/src/getstart/rgsdocs17307.dita (original) +++ db/derby/docs/trunk/src/getstart/rgsdocs17307.dita Tue May 31 19:08:45 2011 @@ -56,17 +56,17 @@ about the

Describes how to use the tools -such as dblook, ij, and sysinfo, -and how to use the system procedures to import and export data, and how to -store Java code in the database.

+such as dblook, ij, and +sysinfo.

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.

Part Two of this guide discusses administrative issues such as -backups and debugging deadlocks.

+systems.

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.

API Reference

An API Reference that is automatically generated for all public classes. Modified: db/derby/docs/trunk/src/ref/rrefexportproc.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportproc.dita?rev=1129857&r1=1129856&r2=1129857&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefexportproc.dita (original) +++ db/derby/docs/trunk/src/ref/rrefexportproc.dita Tue May 31 19:08:45 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. -

Usage

For additional information on using this procedure -see the section "Using the bulk import and export procedures" in the .

Usage +

For additional information on using this procedure, see the section +"Importing and exporting data" in the +.

Example

The following example shows how to export information from the STAFF table in a SAMPLE database to the myfile.del file.

CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'STAFF', 'myfile.del', null, null, null);

Modified: db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita?rev=1129857&r1=1129856&r2=1129857&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita (original) +++ db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita Tue May 31 19:08:45 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.

Usage

For additional information on using this procedure -see the section "Using the bulk import and export procedures" in the .

Usage +

For additional information on using this procedure, see the section +"Importing and exporting data" in the +.

Example exporting all data from a table, using a separate export file for the LOB data

The following example shows how to export data from the STAFF table in a sample database to the main file staff.del and Modified: db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita?rev=1129857&r1=1129856&r2=1129857&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita (original) +++ db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita Tue May 31 19:08:45 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.

Usage

For additional information on using this procedure -see the section "Using the bulk import and export procedures" in the .

Usage +

For additional information on using this procedure, see the section +"Importing and exporting data" in the +.

Example

The following example shows how to export the information about employees in Department 20 from the STAFF table in the SAMPLE database to the myfile.del file.

CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from staff where dept =20', Modified: db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita?rev=1129857&r1=1129856&r2=1129857&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita (original) +++ db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita Tue May 31 19:08:45 2011 @@ -87,8 +87,10 @@ If you are using the Network Server, the Specifying a NULL value results in an error. The LOBSFILENAME parameter takes an input argument that is a VARCHAR (32672) data type.

Usage

For additional information on using this procedure -see the section "Using the bulk import and export procedures" in the .

Usage +

For additional information on using this procedure, see the section +"Importing and exporting data" in the +.

Example exporting data from a query using a separate export file for the LOB dataThe 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/trunk/src/ref/rrefimportdataproc.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimportdataproc.dita?rev=1129857&r1=1129856&r2=1129857&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefimportdataproc.dita (original) +++ db/derby/docs/trunk/src/ref/rrefimportdataproc.dita Tue May 31 19:08:45 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.

Usage

For additional information on using this procedure -see the section "Using the bulk import and export procedures" in the .

Usage +

For additional information on using this procedure, see the section +"Importing and exporting data" in the +.

Example

The following example imports some of the data fields from a delimited data file called data.del into the STAFF table: CALL SYSCS_UTIL.SYSCS_IMPORT_DATA Modified: db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita?rev=1129857&r1=1129856&r2=1129857&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita (original) +++ db/derby/docs/trunk/src/ref/rrefimportdataproclobs.dita Tue May 31 19:08:45 2011 @@ -108,8 +108,9 @@ the reference that is stored in the main to the LOB stored in the main import file must be lobsFileName.Offset.length/.

Offset is position in the external file in bytes
length is the size of the LOB column data in bytes

For additional information on using this procedure see the section -"Using the bulk import and export procedures" in the .

For additional information on using this procedure, see the section +"Importing and exporting data" in the +.

Example importing data into specific columns, using a separate import file for the LOB dataThe following example shows how to import data into several columns of the STAFF table. The STAFF table includes a LOB Modified: db/derby/docs/trunk/src/ref/rrefimportproc.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimportproc.dita?rev=1129857&r1=1129856&r2=1129857&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefimportproc.dita (original) +++ db/derby/docs/trunk/src/ref/rrefimportproc.dita Tue May 31 19:08:45 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.

Usage

For additional information on using this procedure -see the section "Using the bulk import and export procedures" in the .

Usage +

For additional information on using this procedure, see the section +"Importing and exporting data" in the +.

Example

The following example imports data into the STAFF table from a delimited data file called myfile.del with the percentage character (%) as the string delimiter, and a semicolon (;) Modified: db/derby/docs/trunk/src/ref/rrefimporttableproclobs.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefimporttableproclobs.dita?rev=1129857&r1=1129856&r2=1129857&view=diff ============================================================================== --- db/derby/docs/trunk/src/ref/rrefimporttableproclobs.dita (original) +++ db/derby/docs/trunk/src/ref/rrefimporttableproclobs.dita Tue May 31 19:08:45 2011 @@ -94,8 +94,9 @@ from a non-Derby source, the format of t the main import file must be lobsFileName.Offset.length/.

Offset is position in the external file in bytes
length is the size of the LOB column data in bytes

For additional information on using this procedure see the section -"Using the bulk import and export procedures" in the .

For additional information on using this procedure, see the section +"Importing and exporting data" in the +.

Example importing data from a main import file that contains references which point to a separate file that contains LOB data

The following example shows how to import data into the STAFF table in Modified: db/derby/docs/trunk/src/tuning/ctunperf16800.dita URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/ctunperf16800.dita?rev=1129857&r1=1129856&r2=1129857&view=diff ============================================================================== --- db/derby/docs/trunk/src/tuning/ctunperf16800.dita (original) +++ db/derby/docs/trunk/src/tuning/ctunperf16800.dita Tue May 31 19:08:45 2011 @@ -29,9 +29,11 @@ not return until a physical disk write i

Run in autocommit false mode, execute a number of inserts in one transaction, and then explicitly issue a commit.

If your application allows an initial load into the table, you can use -the import procedures to insert data into a table. will +the import procedures to insert data into a table. + will not log the individual inserts when loading into an empty table using these -interfaces. See the Guide for +interfaces. See the and the + for more information on the import procedures.