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/procedures.xml =================================================================== --- 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 specified temp table. At runtime with the "INTO" clause specified, the dynamic command will actually execute a statement that behaves like a SELECT INTO. If the dynamic SQL command creates a temporary table with the "INTO" clause, then the "AS" clause is required to define the table’s metadata. + <para>The "INTO" clause will project the dynamic SQL into the specified temp table. With the "INTO" clause specified, the dynamic command will actually execute a statement that behaves like an INSERT with a QUERY EXPRESSION. If the dynamic SQL command creates a temporary table with the "INTO" clause, then the "AS" clause is required to define the table’s metadata. </para> </listitem> <listitem> Modified: trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml =================================================================== --- trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml 2009-02-26 21:30:22 UTC (rev 515) +++ trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml 2009-02-26 22:08:21 UTC (rev 516) @@ -824,6 +824,9 @@ </sect2> <sect2 id="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="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 records into a temporary table. The INTO clause immediately precedes the FROM clause. </para>