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 2005/07/01 02:14:52 UTC
svn commit: r208698 [5/6] - /incubator/derby/docs/trunk/src/ref/
Modified: incubator/derby/docs/trunk/src/ref/rrefsimplecolumnname.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsimplecolumnname.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsimplecolumnname.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsimplecolumnname.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
@@ -23,7 +23,7 @@
<section><p>A <i>Simple-column-Name</i> is used to represent a column when
it cannot be qualified by a <i>table-Name</i> or<i> correlation-Name</i>.
This is the case when the qualification is fixed, as it is in a column definition
-within a CREATE TABLE statement, and in ORDER BY clauses.</p></section>
+within a CREATE TABLE statement.</p></section>
<section><title>Syntax</title> <codeblock><b><i><xref href="crefsqlj34834.dita#crefsqlj34834">SQL92Identifier</xref></i></b></codeblock></section>
<section><title>Example</title> <codeblock><b><ph>-- country is a Simple-column-Name</ph>
CREATE TABLE CONTINENT (COUNTRY VARCHAR(26) NOT NULL PRIMARY KEY,
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs12085.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs12085.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs12085.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs12085.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
@@ -44,7 +44,7 @@
<entry colname="5">unique identifier for the schema</entry>
</row>
<row>
-<entry colname="1">SCHEMA-NAME</entry>
+<entry colname="1">SCHEMANAME</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
<entry colname="4">false</entry>
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs12813.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs12813.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs12813.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs12813.dita Thu Jun 30 17:14:39 2005
@@ -2,7 +2,7 @@
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
@@ -23,7 +23,7 @@
in the database. Persistent objects can be dependents (they depend on other
objects) and/or providers (other objects depend on them).</p></section>
<section><p>Providers are tables, conglomerates, and constraints. Dependents
-are publications and views. <table expanse="page" frame="all">
+are views. <table expanse="page" frame="all">
<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="28*"/>
<colspec colname="2" colnum="2" colwidth="24*"/><colspec colname="3" colnum="3"
colwidth="11*"/><colspec colname="4" colnum="4" colwidth="13*"/><colspec colname="5"
@@ -51,7 +51,7 @@
is not part of the public API.</entry>
<entry colname="3">1</entry>
<entry colname="4">false</entry>
-<entry colname="5">system type describing the publication or view</entry>
+<entry colname="5">system type describing the view</entry>
</row>
<row>
<entry colname="1">PROVIDERID</entry>
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs13420.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs13420.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs13420.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs13420.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs22441.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs22441.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs22441.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs22441.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,8 @@
<?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.
+Copyright 1997, 2005 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.
@@ -14,9 +16,6 @@
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="rrefsistabs22441" xml:lang="en-us">
<title>SYSCOLUMNS</title>
<refbody>
@@ -41,11 +40,10 @@
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
<entry colname="4">false</entry>
-<entry colname="5">Identifier for table or publication (join with <i>SYSTABLES.TABLEID
-or SYSPUBS. PUBLICATIONID</i>)</entry>
+<entry colname="5">Identifier for table (join with <i>SYSTABLES.TABLEID</i>)</entry>
</row>
<row>
-<entry colname="1">COLUMN-NAME</entry>
+<entry colname="1">COLUMNNAME</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">128</entry>
<entry colname="4">false</entry>
@@ -56,8 +54,7 @@
<entry colname="2">INT</entry>
<entry colname="3">4</entry>
<entry colname="4">false</entry>
-<entry colname="5">the position of the column within the table or the position
-of the parameter within the publication</entry>
+<entry colname="5">the position of the column within the table</entry>
</row>
<row>
<entry colname="1">COLUMNDATATYPE</entry>
@@ -75,19 +72,17 @@
<entry colname="4">true</entry>
<entry colname="5">for tables, describes default value of the column. The <i>toString()</i> method
on the object stored in the table returns the text of the default value as
-specified in the CREATE TABLE or ALTER TABLE statement. <p>for publication
-parameters, defines the default value of the parameter at the source, and
-the actual value of the parameter at the target</p></entry>
+specified in the CREATE TABLE or ALTER TABLE statement.</entry>
</row>
<row>
<entry colname="1">COLUMNDEFAULTID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
-<entry colname="4">false</entry>
+<entry colname="4">true</entry>
<entry colname="5">unique identifier for the default value </entry>
</row>
<row>
-<entry colname="1">IDENTITYCOLUMNVALUE</entry>
+<entry colname="1">AUTOINCREMENTCOLUMNVALUE</entry>
<entry colname="2">BIGINT</entry>
<entry colname="3"></entry>
<entry colname="4">true</entry>
@@ -95,7 +90,7 @@
an identity column</entry>
</row>
<row>
-<entry colname="1">IDENTITYCOLUMNSTART</entry>
+<entry colname="1">AUTOINCREMENTCOLUMNSTART</entry>
<entry colname="2">BIGINT</entry>
<entry colname="3"></entry>
<entry colname="4">true</entry>
@@ -103,7 +98,7 @@
column</entry>
</row>
<row>
-<entry colname="1">IDENTITYCOLUMNINC</entry>
+<entry colname="1">AUTOINCREMENTCOLUMNINC</entry>
<entry colname="2">BIGINT</entry>
<entry colname="3"></entry>
<entry colname="4">true</entry>
@@ -115,4 +110,3 @@
</table></p></section>
</refbody>
</reference>
-
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs23241.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs23241.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs23241.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs23241.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
@@ -52,7 +52,7 @@
<entry colname="5">identifier for table (join with <i>SYSTABLES.TABLEID</i>)</entry>
</row>
<row>
-<entry colname="1">CONSTRAINT-NAME</entry>
+<entry colname="1">CONSTRAINTNAME</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
<entry colname="4">false</entry>
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs24045.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs24045.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs24045.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs24045.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs24269.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs24269.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs24269.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs24269.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
@@ -44,7 +44,7 @@
<entry colname="5">unique identifier for table or view</entry>
</row>
<row>
-<entry colname="1">TABLE-NAME</entry>
+<entry colname="1">TABLENAME</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
<entry colname="4">false</entry>
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs26665.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs26665.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs26665.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs26665.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs28114.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs28114.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs28114.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs28114.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,8 @@
<?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.
+Copyright 1997, 2005 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.
@@ -14,9 +16,6 @@
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="rrefsistabs28114" xml:lang="en-us">
<title>SYSALIASES</title>
<refbody>
@@ -95,9 +94,15 @@
<entry colname="5">A Java interface that encapsulates the additional information
that is specific to an alias</entry>
</row>
+<row>
+<entry colname="1">SPECIFICNAME</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">128</entry>
+<entry colname="4">false</entry>
+<entry colname="5">system-generated identifier</entry>
+</row>
</tbody>
</tgroup>
</table></p></section>
</refbody>
</reference>
-
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs33768.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs33768.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs33768.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs33768.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs33921.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs33921.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs33921.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs33921.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs38369.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs38369.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs38369.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs38369.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
@@ -22,7 +22,7 @@
<refbody>
<section><p><ph conref="refconrefs.dita#prod/productshortname"></ph> includes system tables.</p></section>
<section><p>You can query system tables, but you cannot alter them.</p></section>
-<section><p>All system tables reside in the <i>SYS</i> schema. Because this
+<section><p>All of the above system tables reside in the <i>SYS</i> schema. Because this
is not the default schema, qualify all queries accessing the system tables
with the <i>SYS</i> schema name.</p></section>
<section><p>The recommended way to get more information about these tables
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs39391.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs39391.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs39391.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs39391.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,8 @@
<?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.
+Copyright 1997, 2005 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.
@@ -14,9 +16,6 @@
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="rrefsistabs39391" xml:lang="en-us">
<title>SYSCONGLOMERATES</title>
<refbody>
@@ -85,7 +84,7 @@
<entry colname="1">ISCONSTRAINT</entry>
<entry colname="2">BOOLEAN</entry>
<entry colname="3">1</entry>
-<entry colname="4">false</entry>
+<entry colname="4">true</entry>
<entry colname="5">whether or not conglomerate is a system-generated index
enforcing a constraint</entry>
</row>
@@ -101,4 +100,3 @@
</table></p></section>
</refbody>
</reference>
-
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs40972.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs40972.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs40972.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs40972.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabs79888.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabs79888.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabs79888.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabs79888.dita Thu Jun 30 17:14:39 2005
@@ -2,7 +2,7 @@
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
@@ -108,7 +108,7 @@
<entry colname="1">ACTIONSTMTID</entry>
<entry colname="2">CHAR</entry>
<entry colname="3">36</entry>
-<entry colname="4">false</entry>
+<entry colname="4">true</entry>
<entry colname="5">id of the stored prepared statement for the triggered-SQL-statement
(join with <i>SYSSTATEMENTS. STMTID</i>)</entry>
</row>
@@ -132,7 +132,7 @@
<entry colname="2">BOOLEAN</entry>
<entry colname="3"></entry>
<entry colname="4">true</entry>
-<entry colname="5">whether or not the REFERENCINGNAME, if non-null, refers
+<entry colname="5">whether or not the OLDREFERENCINGNAME, if non-null, refers
to the OLD row or table</entry>
</row>
<row>
@@ -140,16 +140,22 @@
<entry colname="2">BOOLEAN</entry>
<entry colname="3"></entry>
<entry colname="4">true</entry>
-<entry colname="5">whether or not the REFERENCINGNAME, if non-null, refers
+<entry colname="5">whether or not the NEWREFERENCINGNAME, if non-null, refers
to the NEW row or table</entry>
</row>
<row>
-<entry colname="1">REFERENCINGNAME</entry>
+<entry colname="1">OLDREFERENCINGNAME</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">128</entry>
+<entry colname="4">true</entry>
+<entry colname="5">pseudoname as set using the REFERENCING OLD AS clause</entry>
+</row>
+<row>
+<entry colname="1">NEWREFERENCINGNAME</entry>
<entry colname="2">VARCHAR</entry>
<entry colname="3">128</entry>
<entry colname="4">true</entry>
-<entry colname="5">the correlation name or identifier
- from the REFERENCING clause</entry>
+<entry colname="5">pseudoname as set using the REFERENCING NEW AS clause </entry>
</row>
</tbody>
</tgroup>
@@ -160,4 +166,3 @@
a trigger are always in the same schema as the trigger.</p></section>
</refbody>
</reference>
-
Modified: incubator/derby/docs/trunk/src/ref/rrefsistabslilanguageitemsysstatistics.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsistabslilanguageitemsysstatistics.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsistabslilanguageitemsysstatistics.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsistabslilanguageitemsysstatistics.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,8 @@
<?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.
+Copyright 1997, 2005 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.
@@ -14,9 +16,6 @@
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="rrefsistabslilanguageitemsysstatistics" xml:lang="en-us">
<title>SYSSTATISTICS</title>
<refbody>
@@ -62,7 +61,7 @@
<entry colname="1">CREATIONTIMESTAMP</entry>
<entry colname="2">TIMESTAMP</entry>
<entry colname="3"></entry>
-<entry colname="4"></entry>
+<entry colname="4">false</entry>
<entry colname="5">time when this statistic was created or updated</entry>
</row>
<row>
@@ -100,4 +99,3 @@
</table></p></section>
</refbody>
</reference>
-
Modified: incubator/derby/docs/trunk/src/ref/rrefso2.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefso2.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefso2.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefso2.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsql9241891.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsql9241891.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsql9241891.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsql9241891.dita Thu Jun 30 17:14:39 2005
@@ -2,7 +2,7 @@
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
@@ -362,7 +362,7 @@
<row>
<entry colname="col1">ALTER TABLE DROP COLUMN</entry>
<entry colname="col2">SQL92T</entry>
-<entry colname="col3">yes</entry>
+<entry colname="col3">no</entry>
</row>
</tbody>
</tgroup>
@@ -553,12 +553,12 @@
<row>
<entry colname="col1">EXCEPT</entry>
<entry colname="col2">SQL92I</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
<entry colname="col1">INTERSECT</entry>
<entry colname="col2">SQL92I</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
<entry colname="col1">CORRESPONDING</entry>
@@ -683,7 +683,7 @@
<row>
<entry colname="col1">precision for TIME and TIMESTAMP</entry>
<entry colname="col2">SQL92F</entry>
-<entry colname="col3">no</entry>
+<entry colname="col3">yes</entry>
</row>
</tbody>
</tgroup>
@@ -867,7 +867,7 @@
<entry colname="col3">partial support</entry>
</row>
<row>
-<entry colname="col1">Compound character string constantss</entry>
+<entry colname="col1">Compound character string constants</entry>
<entry colname="col2">SQL92I</entry>
<entry colname="col3">use concatenation</entry>
</row>
@@ -905,7 +905,7 @@
<row>
<entry colname="col1">Schema manipulation</entry>
<entry colname="col2">SQL92I</entry>
-<entry colname="col3">yes, to drop a default, set it to NULL.</entry>
+<entry colname="col3">yes</entry>
</row>
<row>
<entry colname="col1">Long identifiers</entry>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj1055824.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj1055824.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj1055824.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj1055824.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj10696.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj10696.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj10696.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj10696.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj1080779.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj1080779.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj1080779.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj1080779.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj1080962.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj1080962.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj1080962.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj1080962.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj1082953.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj1082953.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj1082953.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj1082953.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj1083019.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj1083019.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj1083019.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj1083019.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj11277.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj11277.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj11277.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj11277.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
@@ -57,7 +57,7 @@
<ph>-- Insert two new departments using one statement into the DEPARTMENT table,
-- but do not assign a manager to the new department.</ph>
INSERT INTO DEPARTMENT (DEPTNO, DEPTNAME, ADMRDEPT)
- VALUES ('B11' 'URCHASING' 'B01'),
+ VALUES ('B11', 'PURCHASING', 'B01'),
('E41', 'DATABASE ADMINISTRATION', 'E01')
<ph>-- insert a row with a DEFAULT value for the MAJPROJ column</ph>
INSERT INTO PROJECT (PROJNO, PROJNAME, DEPTNO, RESPEMP, PRSTDATE, MAJPROJ)
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj12362.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj12362.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj12362.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj12362.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj13083.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj13083.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj13083.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj13083.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj13590.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj13590.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj13590.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj13590.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
@@ -20,7 +20,10 @@
<reference id="rrefsqlj13590" xml:lang="en-us">
<title>CONSTRAINT clause</title>
<prolog><metadata>
-<keywords><indexterm>CONSTRAINT clause</indexterm><indexterm>Constraints</indexterm>
+<keywords><indexterm>CONSTRAINT clause</indexterm><indexterm>Constraints</indexterm><indexterm>Storage
+properties<indexterm>for indexes backing constraints</indexterm></indexterm><indexterm>Backing
+indexes<indexterm>specifying storage properties for</indexterm></indexterm><indexterm>Tables<indexterm>specifying
+page size for</indexterm><indexterm>specifying properties for</indexterm></indexterm>
</keywords>
</metadata></prolog>
<refbody>
@@ -42,9 +45,6 @@
constraints include: <ul>
<li>NOT NULL <p>Specifies that this column cannot hold NULL values (constraints
of this type are not nameable).</p></li>
-<li>NULL <p>The opposite of NOT NULL (not really a constraint), it specifies
-that the column can hold NULL values. Specifying NULL is the same as saying
-nothing at all, except when the column is included in a PRIMARY KEY constraint.</p></li>
<li>PRIMARY KEY<indexterm>Primary keys<indexterm>creating</indexterm><indexterm>adding</indexterm></indexterm>
<p>Specifies the column that uniquely identifies a row in the table. The
identified columns must be defined as NOT NULL. </p> <note>If you attempt
@@ -113,7 +113,7 @@
allow one of the columns to contain a value for which there is no matching
value in the referenced columns, per the SQL-92 standard. To avoid this situation,
create NOT NULL constraints on all of the foreign key's columns.</note></p> </section>
-<section><title>Foreign key Cconstraints and DML</title> <p>When you insert
+<section><title>Foreign key constraints and DML</title> <p>When you insert
into or update a table with an enabled foreign key constraint, <ph conref="refconrefs.dita#prod/productshortname"></ph> checks
that the row does not violate the foreign key constraint by looking up the
corresponding referenced key in the referenced table. If the constraint is
@@ -137,11 +137,8 @@
generate non-unique indexes. Therefore, if a column or set of columns has
a UNIQUE, PRIMARY KEY, or FOREIGN KEY constraint on it, you do not need to
create an index on those columns for performance. <ph conref="refconrefs.dita#prod/productshortname"></ph> has
-already created it for you. See <xref href="rrefsqlj20937.dita#rrefsqlj20937/sqlj27363"></xref>.</p> <p><indexterm>Storage
-properties<indexterm>for indexes backing constraints</indexterm></indexterm><indexterm>Backing
-indexes<indexterm>specifying storage properties for</indexterm></indexterm><indexterm>Tables<indexterm>specifying
-page size for</indexterm><indexterm>specifying properties for</indexterm></indexterm> For
-backing indexes, you can specify only page size.</p> <p>These indexes are
+already created it for you. See <xref href="rrefsqlj20937.dita#rrefsqlj20937/sqlj27363"></xref>.</p>
+<p>These indexes are
available to the optimizer for query optimization (see <xref href="rrefsqlj20937.dita#rrefsqlj20937"></xref>)
and have system-generated names.</p> <p>You cannot drop backing indexes with
a DROP INDEX statement; you must drop the constraint or the table.</p> </section>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj13658.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj13658.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj13658.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj13658.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj13733.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj13733.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj13733.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj13733.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj14122.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj14122.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj14122.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj14122.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj14854.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj14854.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj14854.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj14854.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj15147.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj15147.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj15147.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj15147.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj15260.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj15260.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj15260.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj15260.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj15309.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj15309.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj15309.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj15309.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj15446.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj15446.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj15446.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj15446.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj15866.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj15866.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj15866.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj15866.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj16095.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj16095.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj16095.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj16095.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj16221.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj16221.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj16221.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj16221.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj16357.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj16357.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj16357.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj16357.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj16762.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj16762.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj16762.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj16762.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj18730.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj18730.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj18730.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj18730.dita Thu Jun 30 17:14:39 2005
@@ -2,7 +2,7 @@
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj18922.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj18922.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj18922.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj18922.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj19433.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj19433.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj19433.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj19433.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj20204.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj20204.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj20204.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj20204.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj21571.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj21571.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj21571.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj21571.dita Thu Jun 30 17:14:39 2005
@@ -2,7 +2,7 @@
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
@@ -29,8 +29,8 @@
<i> Query</i> INTERSECT [ ALL | DISTINCT ] <i>Query</i> |
<i> Query</i> EXCEPT [ ALL | DISTINCT ] <i>Query</i> |
<i> Query</i> UNION [ ALL | DISTINCT ] <i>Query</i> |
-<i> <xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpression</xref></i>
-<i> </i><xref href="rrefsqlj11277.dita#rrefsqlj11277">VALUES Expression</xref>
+<i> <xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpression</xref></i> | <i><xref
+href="rrefsqlj11277.dita#rrefsqlj11277">VALUES Expression</xref></i>
}</b></codeblock><p>You can arbitrarily put parentheses around queries, or
use the parentheses to control the order of evaluation of the INTERSECT, EXCEPT,
or UNION operations. These operations are evaluated from left to right when
@@ -45,17 +45,18 @@
the duplicates will be eliminated. For example, UNION builds an intermediate <i>ResultSet</i> with
all of the rows from both queries and eliminates the duplicate rows before
returning the remaining rows. UNION ALL returns all rows from both queries
-as the result.</p><p>Depending on which operation is specified, if the number
+as the result.</p><p> Depending on which operation is specified, if the number
of copies of a row in the left table is L and the number of copies of that
row in the right table is R, then the number of duplicates of that particular
-row that the output table contains is:<ul>
+row that the output table contains (assuming the ALL keyword is specified)
+is:<ul>
<li>UNION: ( L + R ).</li>
<li>EXCEPT: the maximum of ( L â R ) and 0 (zero).</li>
<li>INTERSECT: the minimum of L and R.</li>
</ul></p></section>
<example><title>Examples</title><codeblock><b><ph>-- a Select expression </ph>
SELECT *
-FROM FROM ORG;
+FROM ORG;
<ph>-- a subquery </ph>
SELECT *
@@ -76,7 +77,7 @@
VALUES (1,2), (3,4);
<ph>-- a values expression</ph>
-VALUES (1,2,3)</b>
+VALUES (1,2,3);</b>
<b>-- List the employee numbers (EMPNO) of all employees in the EMPLOYEE table
-- whose department number (WORKDEPT) either begins with 'E' or
-- who are assigned to projects in the EMP_ACT table
@@ -114,7 +115,7 @@
-- tag these rows as "new"
SELECT EMPNO, 'emp'
FROM EMPLOYEE
- WHERE WORKDEPT LIKE 'E%''
+ WHERE WORKDEPT LIKE 'E%'
UNION
SELECT EMPNO, 'emp_act'
FROM EMP_ACT
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj21583.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj21583.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj21583.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj21583.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj21908.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj21908.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj21908.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj21908.dita Thu Jun 30 17:14:39 2005
@@ -2,7 +2,7 @@
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj23075.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj23075.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj23075.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj23075.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj24513.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj24513.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj24513.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj24513.dita Thu Jun 30 17:14:39 2005
@@ -2,7 +2,7 @@
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj25228.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj25228.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj25228.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj25228.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj26498.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj26498.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj26498.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj26498.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
@@ -64,7 +64,7 @@
<ph>-- Increase the project staffing (PRSTAFF) by 1.5 for all projects</ph>
stmt.executeUpdate("UPDATE PROJECT SET PRSTAFF = "
"PRSTAFF + 1.5" +
-"WHERE CURRENT OF" + ResultSet.getCursorName())
+"WHERE CURRENT OF" + ResultSet.getCursorName());
<ph>-- Change the job (JOB) of employee number (EMPNO) '000290' in the EMPLOYEE table
-- to its DEFAULT value which is NULL</ph>
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj27281.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj27281.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj27281.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj27281.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj27620.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj27620.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj27620.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj27620.dita Thu Jun 30 17:14:39 2005
@@ -2,7 +2,7 @@
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj27767.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj27767.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj27767.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj27767.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj27781.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj27781.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj27781.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj27781.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj28468.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj28468.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj28468.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj28468.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj29026.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj29026.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj29026.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj29026.dita Thu Jun 30 17:14:39 2005
@@ -2,7 +2,7 @@
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj29840.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj29840.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj29840.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj29840.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj29930.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj29930.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj29930.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj29930.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj30118.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj30118.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj30118.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj30118.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj30435.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj30435.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj30435.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj30435.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj30540.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj30540.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj30540.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj30540.dita Thu Jun 30 17:14:39 2005
@@ -2,7 +2,7 @@
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj31648.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj31648.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj31648.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj31648.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj31783.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj31783.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj31783.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj31783.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj32268.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj32268.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj32268.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj32268.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj32613.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj32613.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj32613.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj32613.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj32654.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj32654.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj32654.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj32654.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj32693.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj32693.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj32693.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj32693.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj32714.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj32714.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj32714.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj32714.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj33215.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj33215.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj33215.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj33215.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj33520.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj33520.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj33520.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj33520.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj33562.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj33562.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj33562.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj33562.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj33602.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj33602.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj33602.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj33602.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj33772.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj33772.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj33772.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj33772.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj33923.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj33923.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj33923.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj33923.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj34148.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj34148.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj34148.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj34148.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj34177.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj34177.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj34177.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj34177.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj35034.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj35034.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj35034.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj35034.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj35981.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj35981.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj35981.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj35981.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj36146.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj36146.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj36146.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj36146.dita Thu Jun 30 17:14:39 2005
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj37836.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj37836.dita?rev=208698&r1=208697&r2=208698&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj37836.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj37836.dita Thu Jun 30 17:14:39 2005
@@ -2,7 +2,7 @@
<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
"../dtd/reference.dtd">
<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+Copyright 1997, 2005 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.
@@ -74,10 +74,11 @@
a GENERATED ALWAYS column, a GENERATED BY DEFAULT column does not guarantee
uniqueness. Thus, in the above example, the <codeph>hi</codeph> and <codeph>salut</codeph> rows
will both have an identity value of "1", because the generated column starts
-at "1" and the user-specified value was also "1". To prevent this, you can
-use the "STARTS WITH" keyword described below. To check for this condition
-and disallow it, you can use a primary key or unique constraint on the GENERATED
-BY DEFAULT identity column.</p></dd>
+at "1" and the user-specified value was also "1". To prevent duplication,
+especially when loading or importing data, create the table using the START
+WITH value which corresponds to the first identity value that the system should
+assign. To check for this condition and disallow it, you can use a primary
+key or unique constraint on the GENERATED BY DEFAULT identity column.</p></dd>
</dlentry></dl></p><p>By default, the initial value of an identity column
is 1, and the amount of the increment is 1. You can specify non-default values
for both the initial value and the interval amount when you define the column
@@ -149,5 +150,14 @@
level can see increment values generated by itself and previous nesting levels,
all the way to the top-level SQL statement that initiated the recursive triggers.
You can only have 16 levels of trigger recursion.</p> </section>
+<section><title>Example</title><codeblock>create table greetings
+ (i int generated by default as identity (START WITH 2, INCREMENT BY 1),
+ ch char(50));
+-- specify value "1":
+insert into greetings values (1, 'hi');
+-- use generated default
+insert into greetings values (DEFAULT, 'salut');
+-- use generated default
+insert into greetings(ch) values ('bonjour'); </codeblock></section>
</refbody>
</reference>