db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From scotsmat...@apache.org
Subject svn commit: r568710 - in /db/derby/docs/trunk/src/ref: rrefexportproc.dita rrefexportproctablelobs.dita rrefexportselectionproc.dita rrefexportselectionproclobs.dita
Date Wed, 22 Aug 2007 17:38:41 GMT
Author: scotsmatrix
Date: Wed Aug 22 10:38:40 2007
New Revision: 568710

URL: http://svn.apache.org/viewvc?rev=568710&view=rev
Log:
Derby-3007: Clarified that EXPORT does not write to an existing file.

Modified:
    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

Modified: db/derby/docs/trunk/src/ref/rrefexportproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportproc.dita?rev=568710&r1=568709&r2=568710&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefexportproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefexportproc.dita Wed Aug 22 10:38:40 2007
@@ -20,10 +20,19 @@
 -->
 <reference id="rrefexportproc" xml:lang="en-us">
 <title>SYSCS_UTIL.SYSCS_EXPORT_TABLE system procedure</title>
+<shortdesc>The <codeph>SYSCS_UTIL.SYSCS_EXPORT_TABLE</codeph> system procedure
+exports all of the data from a table to an operating system file. </shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system procedures<indexterm>SYSCS_UTIL.SYSCS_EXPORT_TABLE</indexterm></indexterm>
+<indexterm>SYSCS_UTIL.SYSCS_EXPORT_TABLE<indexterm>system procedures</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
 <refbody>
-<section><p>The <codeph>SYSCS_UTIL.SYSCS_EXPORT_TABLE</codeph> system
procedure
-exports all of the data from a table to an operating system file in a delimited
-data file format.</p></section>
+<section><p>For security concerns, and to avoid accidental file damage, this
+EXPORT procedure  does not export data into an existing file. You must specify
+a filename in the  EXPORT procedure that does not exist. When you run the
+procedure the file is created and the data is exported  into the new file.</p><p>The
+data is exported using a delimited file format.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_EXPORT_TABLE
(IN SCHEMANAME  VARCHAR(128),
 IN TABLENAME VARCHAR(128), IN FILENAME VARCHAR(32672),
 IN COLUMNDELIMITER CHAR(1), IN CHARACTERDELIMITER CHAR(1),
@@ -39,12 +48,13 @@
 in an error.</dd>
 </dlentry><dlentry>
 <dt>FILENAME</dt>
-<dd>An input argument of type VARCHAR(32672) that specifies the name of the
-file to which data is to be exported. If the complete path to the file is
-not specified, the export procedure uses the current directory and the default
-drive as the destination. If the name of a file that already exists is specified,
-the export procedure overwrites the contents of the file; it does not append
-the information. Passing a null will result in an error.</dd>
+<dd>Specifies the name of a new 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 procedure returns an
+error. The specified location of the file should refer to the server-side
+location if you are using the Network Server. Specifying a NULL value results
+in an error. The <parmname>FILENAME</parmname> parameter takes an input argument
+that is a VARCHAR (32672) data type.</dd>
 </dlentry><dlentry>
 <dt>COLUMNDELIMITER</dt>
 <dd>An input argument of type CHAR(1) that specifies a column delimiter. The

Modified: db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita?rev=568710&r1=568709&r2=568710&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefexportproctablelobs.dita Wed Aug 22 10:38:40 2007
@@ -24,7 +24,17 @@
 procedure to export all the data from a table, and place the LOB data into
 a separate export file. A reference to the location of the LOB data is placed
 in the LOB column in the main export file.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system procedures<indexterm>SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE</indexterm></indexterm>
+<indexterm>SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE<indexterm>system
+procedures</indexterm></indexterm></keywords>
+</metadata></prolog>
 <refbody>
+<section><p>For security concerns, and to avoid accidental file damage, this
+EXPORT procedure  does not export data into an existing file. You must specify
+a filename in the  EXPORT procedure that does not exist. When you run the
+procedure the file is created and the data is exported  into the new file.</p><p>The
+data is exported using a delimited file format.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE
(
     IN SCHEMANAME VARCHAR(128), 
     IN TABLENAME VARCHAR(128), 
@@ -48,13 +58,13 @@
 an input argument that is a VARCHAR (128) data type.</dd>
 </dlentry><dlentry>
 <dt>FILENAME</dt>
-<dd>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 you are using the Network
-Server. Specifying a NULL value results in an error. The <parmname>FILENAME</parmname>
parameter
-takes an input argument that is a VARCHAR (32672) data type.</dd>
+<dd>Specifies the name of a new 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 procedure returns an
+error. The specified location of the file should refer to the server-side
+location if you are using the Network Server. Specifying a NULL value results
+in an error. The <parmname>FILENAME</parmname> parameter takes an input argument
+that is a VARCHAR (32672) data type.</dd>
 </dlentry><dlentry>
 <dt>COLUMNDELIMITER</dt>
 <dd>Specifies a column delimiter. The specified character is used in place

Modified: db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita?rev=568710&r1=568709&r2=568710&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefexportselectionproc.dita Wed Aug 22 10:38:40 2007
@@ -20,10 +20,19 @@
 -->
 <reference id="rrefexportselectionproc" xml:lang="en-us">
 <title>SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure</title>
+<shortdesc>The <codeph>SYSCS_UTIL.SYSCS_EXPORT_QUERY</codeph> system procedure
+exports the results of a SELECT statement to an operating system file.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system procedures<indexterm>SYSCS_UTIL.SYSCS_EXPORT_QUERY</indexterm></indexterm>
+<indexterm>SYSCS_UTIL.SYSCS_EXPORT_QUERY<indexterm>system procedures</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
 <refbody>
-<section><p>The <codeph>SYSCS_UTIL.SYSCS_EXPORT_QUERY</codeph> system
procedure
-exports the results of a SELECT statement to an operating system file in a
-delimited data file format.</p></section>
+<section><p>For security concerns, and to avoid accidental file damage, this
+EXPORT procedure  does not export data into an existing file. You must specify
+a filename in the  EXPORT procedure that does not exist. When you run the
+procedure the file is created and the data is exported  into the new file.</p><p>The
+data is exported using a delimited file format.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_EXPORT_QUERY(IN
SELECTSTATEMENT VARCHAR(32672),
 IN FILENAME VARCHAR(32672), IN COLUMNDELIMITER CHAR(1),
 IN CHARACTERDELIMITER CHAR(1), IN CODESET VARCHAR(128)) </codeblock> <p>No
@@ -34,12 +43,13 @@
 result in an error.</dd>
 </dlentry><dlentry>
 <dt>FILENAME</dt>
-<dd>An input argument of type VARCHAR(32672) that specifies the name of the
-file to which data is to be exported. If the complete path to the file is
-not specified, the export procedure uses the current directory and the default
-drive as the destination. If the name of a file that already exists is specified,
-the export procedure overwrites the contents of the file; it does not append
-the information. Passing a null will result in an error.</dd>
+<dd>Specifies the name of a new 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 procedure returns an
+error. The specified location of the file should refer to the server-side
+location if you are using the Network Server. Specifying a NULL value results
+in an error. The <parmname>FILENAME</parmname> parameter takes an input argument
+that is a VARCHAR (32672) data type.</dd>
 </dlentry><dlentry>
 <dt>COLUMNDELIMITER</dt>
 <dd>An input argument of type CHAR(1) that specifies a column delimiter. The

Modified: db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita?rev=568710&r1=568709&r2=568710&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefexportselectionproclobs.dita Wed Aug 22 10:38:40 2007
@@ -24,7 +24,17 @@
 procedure to export the result of a SELECT statement to a main export file,
 and place the LOB data into a separate export file. A reference to the location
 of the LOB data is placed in the LOB column in the main export file. </shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system procedures<indexterm>SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE</indexterm></indexterm>
+<indexterm>SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE<indexterm>system
+procedures</indexterm></indexterm></keywords>
+</metadata></prolog>
 <refbody>
+<section><p>For security concerns, and to avoid accidental file damage, this
+EXPORT procedure does not export data into an existing file. You must specify
+a filename in the  EXPORT procedure that does not exist. When you run the
+procedure the file is created and the data is exported  into the new file.</p><p>The
+data is exported using a delimited file format.</p></section>
 <section><title>Syntax</title><codeblock>SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
(
     IN SELECTSTATEMENT VARCHAR(32672),
     IN FILENAME VARCHAR(32672), 
@@ -40,13 +50,13 @@
 takes an input argument that is a VARCHAR (32672) data type.</dd>
 </dlentry><dlentry>
 <dt>FILENAME</dt>
-<dd>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 you are using the Network
-Server. Specifying a NULL value results in an error. The <parmname>FILENAME</parmname>
parameter
-takes an input argument that is a VARCHAR (32672) data type.</dd>
+<dd>Specifies the name of a new 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 procedure returns an
+error. The specified location of the file should refer to the server-side
+location if you are using the Network Server. Specifying a NULL value results
+in an error. The <parmname>FILENAME</parmname> parameter takes an input argument
+that is a VARCHAR (32672) data type.</dd>
 </dlentry><dlentry>
 <dt>COLUMNDELIMITER</dt>
 <dd>Specifies a column delimiter. The specified character is used in place



Mime
View raw message