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 fu...@apache.org on 2006/04/13 23:49:19 UTC
svn commit: r393952 - in /db/derby/docs/trunk/src/ref:
rrefproceduresinplacecompress.dita rrefsqljcreatesynonym.dita
rrefsqljdropsynonym.dita rrefsynonymname.dita
Author: fuzzylogic
Date: Thu Apr 13 14:49:18 2006
New Revision: 393952
URL: http://svn.apache.org/viewcvs?rev=393952&view=rev
Log:
Fix svn:eol-style for doc files with CRLF endings.
Modified:
db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita (contents, props changed)
db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita (contents, props changed)
db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita (contents, props changed)
db/derby/docs/trunk/src/ref/rrefsynonymname.dita (contents, props changed)
Modified: db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita
URL: http://svn.apache.org/viewcvs/db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita?rev=393952&r1=393951&r2=393952&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita Thu Apr 13 14:49:18 2006
@@ -1,107 +1,107 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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="rrefproceduresinplacecompress" xml:lang="en-us">
-<title>SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE</title>
-<prolog><metadata>
-<keywords><indexterm>Reclaiming unused space</indexterm><indexterm>System
-procedures<indexterm>SYSCS_INPLAC E_COMPRESS_TABLE</indexterm></indexterm>
-</keywords>
-</metadata></prolog>
-<refbody>
-<section><p>Use the <codeph>SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE</codeph> system
-procedure to reclaim unused, allocated space in a table and its indexes. Typically,
-unused allocated space exists when a large amount of data is deleted from
-a table and there has not been any subsequent inserts to use the space created
-by the deletes. By default, <ph conref="refconrefs.dita#prod/productshortname"></ph> does
-not return unused space to the operating system. For example, once a page
-has been allocated to a table or index, it is not automatically returned to
-the operating system until the table or index is destroyed. <codeph>SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE</codeph> allows
-you to return unused space to the operating system.</p><p>This system procedure
-can be used to force three levels of in-place compression of a SQL table: <codeph>PURGE_ROWS</codeph>, <codeph>DEFRAGMENT_ROWS</codeph>,
-and <codeph>TRUNCATE_END</codeph>. Unlike <codeph>SYSCS_UTIL.SYSCS_COMPRESS_TABLE()</codeph>,
-all work is done in place in the existing table/index.</p></section>
-<section><title>Syntax</title><codeblock><b>SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE(
- IN SCHEMANAME VARCHAR(128),
- IN TABLENAME VARCHAR(128),
- IN PURGE_ROWS SMALLINT,
- IN DEFRAGMENT_ROWS SMALLINT,
- IN TRUNCATE_END SMALLINT )</b></codeblock> <dl><dlentry>
-<dt>SCHEMANAME</dt>
-<dd>An input argument of type VARCHAR(128) that specifies the schema of the
-table. Passing a null will result in an error. </dd>
-</dlentry><dlentry>
-<dt>TABLENAME</dt>
-<dd>An input argument of type VARCHAR(128) that specifies the table name of
-the table. The string must exactly match the case of the table name, and the
-argument of "Fred" will be passed to SQL as the delimited identifier 'Fred'.
- Passing a null will result in an error.</dd>
-</dlentry><dlentry>
-<dt>PURGE_ROWS</dt>
-<dd>If PURGE_ROWS is set to a non-zero value, then a single pass is made through
-the table which will purge committed deleted rows from the table. This space
-is then available for future inserted rows, but remains allocated to the table.
-As this option scans every page of the table, its performance is linearly
-related to the size of the table.</dd>
-</dlentry><dlentry>
-<dt>DEFRAGMENT_ROWS</dt>
-<dd>If DEFRAGMENT_ROWS is set to a non-zero value, then a single defragment
-pass is made which will move existing rows from the end of the table towards
-the front of the table. The goal of defragmentation is to empty a set of pages
-at the end of the table which can then be returned to the operating system
-by the TRUNCATE_END option. It is recommended to only run DEFRAGMENT_ROWS
-if also specifying the TRUNCATE_END option. The DEFRAGMENT_ROWS option scans
-the whole table and needs to update index entries for every base table row
-move, so the execution time is linearly related to the size of the table.</dd>
-</dlentry><dlentry>
-<dt>TRUNCATE_END</dt>
-<dd>If TRUNCATE_END is set to a non-zero value, then all contiguous pages
-at the end of the table will be returned to the operating system. Running
-the PURGE_ROWS and/or DEFRAGMENT_ROWS options may increase the number of pages
-affected. This option by itself performs no scans of the table. </dd>
-</dlentry></dl></section>
-<section><title>SQL example</title><p>To compress a table called CUSTOMER
-in a schema called US, using all available compress options:<codeblock><b>call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('US', 'CUSTOMER', 1, 1, 1);</b
-></codeblock></p><p>To return the empty free space at the end of the same
-table, the following call will run much quicker than running all options but
-will likely return much less space:<codeblock><b>call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('US', 'CUSTOMER', 0, 0, 1);</b></codeblock></p></section>
-<section><title>Java example</title><p>To compress a table called CUSTOMER
-in a schema called US, using all available compress options:<codeblock>CallableStatement cs = conn.prepareCall
-("CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE(?, ?, ?, ?, ?)");
-cs.setString(1, "US");
-cs.setString(2, "CUSTOMER");
-cs.setShort(3, (short) 1);
-cs.setShort(4, (short) 1);
-cs.setShort(5, (short) 1);
-cs.execute();</codeblock></p><p>To return the empty free space at the end
-of the same table, the following call will run much quicker than running all
-options but will likely return much less space:<codeblock>CallableStatement cs = conn.prepareCall
-("CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE(?, ?, ?, ?, ?)");
-cs.setString(1, "US");
-cs.setString(2, "CUSTOMER");
-cs.setShort(3, (short) 0);
-cs.setShort(4, (short) 0);
-cs.setShort(5, (short) 1);
-cs.execute();</codeblock></p></section>
-<section><p>It is recommended that the SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE
-procedure be issued in autocommit mode.<note>This procedure acquires an exclusive
-table lock on the table being compressed. All statement plans dependent on
-the table or its indexes are invalidated. For information on identifying unused
-space, see the <cite><ph conref="refconrefs.dita#pub/citadmin"></ph></cite>.</note></p></section>
-</refbody>
-</reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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="rrefproceduresinplacecompress" xml:lang="en-us">
+<title>SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE</title>
+<prolog><metadata>
+<keywords><indexterm>Reclaiming unused space</indexterm><indexterm>System
+procedures<indexterm>SYSCS_INPLAC E_COMPRESS_TABLE</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section><p>Use the <codeph>SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE</codeph> system
+procedure to reclaim unused, allocated space in a table and its indexes. Typically,
+unused allocated space exists when a large amount of data is deleted from
+a table and there has not been any subsequent inserts to use the space created
+by the deletes. By default, <ph conref="refconrefs.dita#prod/productshortname"></ph> does
+not return unused space to the operating system. For example, once a page
+has been allocated to a table or index, it is not automatically returned to
+the operating system until the table or index is destroyed. <codeph>SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE</codeph> allows
+you to return unused space to the operating system.</p><p>This system procedure
+can be used to force three levels of in-place compression of a SQL table: <codeph>PURGE_ROWS</codeph>, <codeph>DEFRAGMENT_ROWS</codeph>,
+and <codeph>TRUNCATE_END</codeph>. Unlike <codeph>SYSCS_UTIL.SYSCS_COMPRESS_TABLE()</codeph>,
+all work is done in place in the existing table/index.</p></section>
+<section><title>Syntax</title><codeblock><b>SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE(
+ IN SCHEMANAME VARCHAR(128),
+ IN TABLENAME VARCHAR(128),
+ IN PURGE_ROWS SMALLINT,
+ IN DEFRAGMENT_ROWS SMALLINT,
+ IN TRUNCATE_END SMALLINT )</b></codeblock> <dl><dlentry>
+<dt>SCHEMANAME</dt>
+<dd>An input argument of type VARCHAR(128) that specifies the schema of the
+table. Passing a null will result in an error. </dd>
+</dlentry><dlentry>
+<dt>TABLENAME</dt>
+<dd>An input argument of type VARCHAR(128) that specifies the table name of
+the table. The string must exactly match the case of the table name, and the
+argument of "Fred" will be passed to SQL as the delimited identifier 'Fred'.
+ Passing a null will result in an error.</dd>
+</dlentry><dlentry>
+<dt>PURGE_ROWS</dt>
+<dd>If PURGE_ROWS is set to a non-zero value, then a single pass is made through
+the table which will purge committed deleted rows from the table. This space
+is then available for future inserted rows, but remains allocated to the table.
+As this option scans every page of the table, its performance is linearly
+related to the size of the table.</dd>
+</dlentry><dlentry>
+<dt>DEFRAGMENT_ROWS</dt>
+<dd>If DEFRAGMENT_ROWS is set to a non-zero value, then a single defragment
+pass is made which will move existing rows from the end of the table towards
+the front of the table. The goal of defragmentation is to empty a set of pages
+at the end of the table which can then be returned to the operating system
+by the TRUNCATE_END option. It is recommended to only run DEFRAGMENT_ROWS
+if also specifying the TRUNCATE_END option. The DEFRAGMENT_ROWS option scans
+the whole table and needs to update index entries for every base table row
+move, so the execution time is linearly related to the size of the table.</dd>
+</dlentry><dlentry>
+<dt>TRUNCATE_END</dt>
+<dd>If TRUNCATE_END is set to a non-zero value, then all contiguous pages
+at the end of the table will be returned to the operating system. Running
+the PURGE_ROWS and/or DEFRAGMENT_ROWS options may increase the number of pages
+affected. This option by itself performs no scans of the table. </dd>
+</dlentry></dl></section>
+<section><title>SQL example</title><p>To compress a table called CUSTOMER
+in a schema called US, using all available compress options:<codeblock><b>call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('US', 'CUSTOMER', 1, 1, 1);</b
+></codeblock></p><p>To return the empty free space at the end of the same
+table, the following call will run much quicker than running all options but
+will likely return much less space:<codeblock><b>call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('US', 'CUSTOMER', 0, 0, 1);</b></codeblock></p></section>
+<section><title>Java example</title><p>To compress a table called CUSTOMER
+in a schema called US, using all available compress options:<codeblock>CallableStatement cs = conn.prepareCall
+("CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE(?, ?, ?, ?, ?)");
+cs.setString(1, "US");
+cs.setString(2, "CUSTOMER");
+cs.setShort(3, (short) 1);
+cs.setShort(4, (short) 1);
+cs.setShort(5, (short) 1);
+cs.execute();</codeblock></p><p>To return the empty free space at the end
+of the same table, the following call will run much quicker than running all
+options but will likely return much less space:<codeblock>CallableStatement cs = conn.prepareCall
+("CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE(?, ?, ?, ?, ?)");
+cs.setString(1, "US");
+cs.setString(2, "CUSTOMER");
+cs.setShort(3, (short) 0);
+cs.setShort(4, (short) 0);
+cs.setShort(5, (short) 1);
+cs.execute();</codeblock></p></section>
+<section><p>It is recommended that the SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE
+procedure be issued in autocommit mode.<note>This procedure acquires an exclusive
+table lock on the table being compressed. All statement plans dependent on
+the table or its indexes are invalidated. For information on identifying unused
+space, see the <cite><ph conref="refconrefs.dita#pub/citadmin"></ph></cite>.</note></p></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita
URL: http://svn.apache.org/viewcvs/db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita?rev=393952&r1=393951&r2=393952&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita Thu Apr 13 14:49:18 2006
@@ -1,51 +1,51 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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="rrefsqljcreatesynonym" xml:lang="en-us">
-<title>CREATE SYNONYM statement</title>
-<prolog><metadata>
-<keywords><indexterm>CREATE SYNONYM statement</indexterm><indexterm>Synonyms<indexterm>creating</indexterm></indexterm>
-</keywords>
-</metadata></prolog>
-<refbody>
-<section><p>Use the CREATE SYNONYM statement to provide an alternate name
-for a table or a view that is present in the same schema or another schema.
-You can also create synonyms for other synonyms, resulting in nested synonyms.
-A synonym can be used instead of the original qualified table or view name
-in SELECT, INSERT, UPDATE, DELETE or LOCK TABLE statements. You can create
-a synonym for a table or a view that doesn't exist, but the target table or
-view must be present before the synonym can be used.</p><p>Synonyms share
-the same namespace as tables or views. You cannot create a synonym with the
-same name as a table that already exists in the same schema. Similarly, you
-cannot create a table or view with a name that matches a synonym already present.</p><p>A
-synonym can be defined for a table/view that does not exist when you create
-the synonym. If the table or view doesn't exist, you will receive a warning
-message (SQLSTATE 01522). The referenced object must be present when you
-use a synonym in a DML statement.</p><p>You can create a nested synonym (a
-synonym for another synonym), but any attempt to create a synonym that results
-in a circular reference will return an error message (SQLSTATE 42916).</p><p>Synonyms cannot be defined in system schemas. All schemas starting with 'SYS' are considered system schemas and are reserved by <ph conref="refconrefs.dita#prod/productshortname"></ph>.</p><p>A synonym cannot
-be defined on a temporary table. Attempting to define a synonym on a temporary
-table will return an error message (SQLSTATE XCL51).</p></section><section><title>Syntax</title><codeblock><b>CREATE SYNONYM <xref href="rrefsynonymname.dita#rrefsynonymname">synonym-Name</xref> FOR { <xref
-href="rrefviewname.dita#rrefviewname">view-Name</xref> | <xref href="rreftablename.dita#rreftablename">table-Name</xref> }</b></codeblock>The <xref
-href="rrefsynonymname.dita#rrefsynonymname">synonym-Name</xref> in the statement represents
-the synonym name you are giving the target table or view, while the <xref
-href="rrefviewname.dita#rrefviewname">view-Name</xref> or <xref href="rreftablename.dita#rreftablename">table-Name</xref> represents
-the original name of the target table or view.</section>
-<example><title>Example</title>CREATE SYNONYM SAMP.T1 FOR SAMP.TABLEWITHLONGNAME</example>
-</refbody>
-</reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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="rrefsqljcreatesynonym" xml:lang="en-us">
+<title>CREATE SYNONYM statement</title>
+<prolog><metadata>
+<keywords><indexterm>CREATE SYNONYM statement</indexterm><indexterm>Synonyms<indexterm>creating</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section><p>Use the CREATE SYNONYM statement to provide an alternate name
+for a table or a view that is present in the same schema or another schema.
+You can also create synonyms for other synonyms, resulting in nested synonyms.
+A synonym can be used instead of the original qualified table or view name
+in SELECT, INSERT, UPDATE, DELETE or LOCK TABLE statements. You can create
+a synonym for a table or a view that doesn't exist, but the target table or
+view must be present before the synonym can be used.</p><p>Synonyms share
+the same namespace as tables or views. You cannot create a synonym with the
+same name as a table that already exists in the same schema. Similarly, you
+cannot create a table or view with a name that matches a synonym already present.</p><p>A
+synonym can be defined for a table/view that does not exist when you create
+the synonym. If the table or view doesn't exist, you will receive a warning
+message (SQLSTATE 01522). The referenced object must be present when you
+use a synonym in a DML statement.</p><p>You can create a nested synonym (a
+synonym for another synonym), but any attempt to create a synonym that results
+in a circular reference will return an error message (SQLSTATE 42916).</p><p>Synonyms cannot be defined in system schemas. All schemas starting with 'SYS' are considered system schemas and are reserved by <ph conref="refconrefs.dita#prod/productshortname"></ph>.</p><p>A synonym cannot
+be defined on a temporary table. Attempting to define a synonym on a temporary
+table will return an error message (SQLSTATE XCL51).</p></section><section><title>Syntax</title><codeblock><b>CREATE SYNONYM <xref href="rrefsynonymname.dita#rrefsynonymname">synonym-Name</xref> FOR { <xref
+href="rrefviewname.dita#rrefviewname">view-Name</xref> | <xref href="rreftablename.dita#rreftablename">table-Name</xref> }</b></codeblock>The <xref
+href="rrefsynonymname.dita#rrefsynonymname">synonym-Name</xref> in the statement represents
+the synonym name you are giving the target table or view, while the <xref
+href="rrefviewname.dita#rrefviewname">view-Name</xref> or <xref href="rreftablename.dita#rreftablename">table-Name</xref> represents
+the original name of the target table or view.</section>
+<example><title>Example</title>CREATE SYNONYM SAMP.T1 FOR SAMP.TABLEWITHLONGNAME</example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ref/rrefsqljcreatesynonym.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita
URL: http://svn.apache.org/viewcvs/db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita?rev=393952&r1=393951&r2=393952&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita Thu Apr 13 14:49:18 2006
@@ -1,31 +1,31 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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.
--->
-
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
-<reference id="rrefsqljdropsynonym" xml:lang="en-us">
-<title>DROP SYNONYM statement</title>
-<prolog><metadata>
-<keywords><indexterm>DROP SYNONYM statement</indexterm><indexterm>Synonyms<indexterm>dropping</indexterm></indexterm>
-</keywords>
-</metadata></prolog>
-<refbody>
-<section> <p>Drops the specified synonym from a table or view.</p></section>
-<refsyn><title>Syntax</title> <codeblock><b>DROP SYNONYM <xref href="rrefsynonymname.dita#rrefsynonymname">synonym-Name</xref></b></codeblock> </refsyn>
-</refbody>
-</reference>
-
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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.
+-->
+
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqljdropsynonym" xml:lang="en-us">
+<title>DROP SYNONYM statement</title>
+<prolog><metadata>
+<keywords><indexterm>DROP SYNONYM statement</indexterm><indexterm>Synonyms<indexterm>dropping</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>Drops the specified synonym from a table or view.</p></section>
+<refsyn><title>Syntax</title> <codeblock><b>DROP SYNONYM <xref href="rrefsynonymname.dita#rrefsynonymname">synonym-Name</xref></b></codeblock> </refsyn>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ref/rrefsqljdropsynonym.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: db/derby/docs/trunk/src/ref/rrefsynonymname.dita
URL: http://svn.apache.org/viewcvs/db/derby/docs/trunk/src/ref/rrefsynonymname.dita?rev=393952&r1=393951&r2=393952&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsynonymname.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsynonymname.dita Thu Apr 13 14:49:18 2006
@@ -1,27 +1,27 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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="rrefsynonymname" xml:lang="en-us">
-<title>synonym-Name</title>
-<refbody>
-<section><p>A <i>synonym-Name</i> represents a synonym for a table or a view.
-You can qualify a <i>synonym-Name</i> with a <i>schema-Name</i>.</p></section>
-<section><title>Syntax</title> <codeblock><b>[ <i><xref href="rrefschemaname.dita#rrefschemaname">schemaName</xref>.</i> ] <i><xref
-href="crefsqlj34834.dita#crefsqlj34834">SQL92Identifier</xref></i></b></codeblock></section>
-</refbody>
-</reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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="rrefsynonymname" xml:lang="en-us">
+<title>synonym-Name</title>
+<refbody>
+<section><p>A <i>synonym-Name</i> represents a synonym for a table or a view.
+You can qualify a <i>synonym-Name</i> with a <i>schema-Name</i>.</p></section>
+<section><title>Syntax</title> <codeblock><b>[ <i><xref href="rrefschemaname.dita#rrefschemaname">schemaName</xref>.</i> ] <i><xref
+href="crefsqlj34834.dita#crefsqlj34834">SQL92Identifier</xref></i></b></codeblock></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ref/rrefsynonymname.dita
------------------------------------------------------------------------------
svn:eol-style = native