Diff of /incubator/derby/docs/trunk/src/ref/rrefcorrelationname.dita

Parent Directory | Revision Log | Patch

--- incubator/derby/docs/trunk/src/ref/rrefcorrelationname.dita	2005/05/05 15:39:26	168345
+++ incubator/derby/docs/trunk/src/ref/rrefcorrelationname.dita	2005/05/05 15:45:52	168346
@@ -19,14 +19,20 @@ limitations under the License.
  "../dtd/reference.dtd">
 <reference id="rrefcorrelationname" xml:lang="en-us">
 <title>correlation-Name</title>
-<refbody><?Pub Caret1?>
+<refbody>
 <section><p>A <i>correlation-Name</i> is given to a table expression in a
 FROM clause as a new name or alias for that table. You do not qualify a <i>correlation-Name</i> with
-a <i>schema-Name</i>.</p></section>
+a <i>schema-Name</i>.</p><p>You cannot use correlation-Names for updatable
+columns; using correlation-Names in this way will cause an SQL exception.
+For example:<codeblock>SELECT c11 AS col1, c12 AS col2, c13 FROM t1 FOR UPDATE of c11,c13
+</codeblock>In this example, the correlation-Name <codeph>col1 FOR c11</codeph> is
+not permitted because <codeph>c11</codeph> is listed in the FOR UPDATE list
+of columns. You can use the correlation-Name <codeph>FOR c12</codeph> because
+it is not in the FOR UPDATE list.</p></section>
 <section><title>Syntax</title> <codeblock><b><i><xref href="crefsqlj34834.dita#crefsqlj34834"></xref></i></b></codeblock></section>
-<section><title>Example</title> <codeblock><b><ph>-- C is a correlation-Name</ph>
-SELECT C.NAME
-FROM SAMP.STAFF C</b></codeblock></section>
+<section><title>Example</title> <codeblock><ph>-- C is a correlation-Name
+</ph>SELECT C.NAME
+FROM SAMP.STAFF C</codeblock></section>
 </refbody>
 </reference>
-<?Pub *0000000792?>
+<?Pub *0000001921?>