From teiid-commits at lists.jboss.org Thu Feb 26 17:08:21 2009
Content-Type: multipart/mixed; boundary="===============4698277319022910738=="
MIME-Version: 1.0
From: teiid-commits at lists.jboss.org
To: teiid-commits at lists.jboss.org
Subject: [teiid-commits] teiid SVN: r516 -
 trunk/documentation/reference/src/main/docbook/en-US/content.
Date: Thu, 26 Feb 2009 17:08:21 -0500
Message-ID: <E1LcoOz-0002tW-Ji@committer01.frg.pub.inap.atl.jboss.com>

--===============4698277319022910738==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

Author: shawkins
Date: 2009-02-26 17:08:21 -0500 (Thu, 26 Feb 2009)
New Revision: 516

Modified:
   trunk/documentation/reference/src/main/docbook/en-US/content/procedures.=
xml
   trunk/documentation/reference/src/main/docbook/en-US/content/sql_support=
.xml
Log:
TEIID-355 deprecating the use of select into to target a table.

Modified: trunk/documentation/reference/src/main/docbook/en-US/content/proc=
edures.xml
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/documentation/reference/src/main/docbook/en-US/content/procedures=
.xml	2009-02-26 21:30:22 UTC (rev 515)
+++ trunk/documentation/reference/src/main/docbook/en-US/content/procedures=
.xml	2009-02-26 22:08:21 UTC (rev 516)
@@ -45,7 +45,7 @@
           </para>
         </listitem>
         <listitem>
-          <para>The "INTO" clause will project the dynamic SQL into the sp=
ecified temp table. At runtime with the "INTO" clause specified, the dynami=
c command will actually execute a statement that behaves like a SELECT INTO=
. If the dynamic SQL command creates a temporary table with the "INTO" clau=
se, then the "AS" clause is required to define the table=E2=80=99s metadata.
+          <para>The "INTO" clause will project the dynamic SQL into the sp=
ecified temp table. With the "INTO" clause specified, the dynamic command w=
ill actually execute a statement that behaves like an INSERT with a QUERY E=
XPRESSION. If the dynamic SQL command creates a temporary table with the "I=
NTO" clause, then the "AS" clause is required to define the table=E2=80=99s=
 metadata.
           </para>
         </listitem>
         <listitem>

Modified: trunk/documentation/reference/src/main/docbook/en-US/content/sql_=
support.xml
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/documentation/reference/src/main/docbook/en-US/content/sql_suppor=
t.xml	2009-02-26 21:30:22 UTC (rev 515)
+++ trunk/documentation/reference/src/main/docbook/en-US/content/sql_suppor=
t.xml	2009-02-26 22:08:21 UTC (rev 516)
@@ -824,6 +824,9 @@
     </sect2>
     <sect2 id=3D"into_clause">
       <title>INTO Clause</title>
+      <warning>
+      	<para>Usage of the INTO Clause for inserting into a table has been =
been deprecated.  An <link linkend=3D"insert_command">INSERT</link> with a =
query command should be used instead.</para>
+      </warning>
       <para>
       When the into clause is specified with a SELECT, the results of the =
query are inserted into the specified table. This is often used to insert r=
ecords into a temporary table. The INTO clause immediately precedes the FRO=
M clause.   =

       </para>


--===============4698277319022910738==--