 |
 |
Archives of the TeradataForum
Message Posted: Thu, 03 Jul 2003 @ 17:48:20 GMT
| Subj: | | Re: Question about insert |
| |
| From: | | Dempsey, Mike |
For future reference...
In reference to:
| | Insert into pmart.fact_sales_temp Select * From pmart.fact_sales
;Insert into pmart.fact_sales_temp Select * From pdata.shopping_trans; | |
| | -- This insert step needs to run in bteq, it will not work as intended in queryman. By placing the ";" in front of the second insert
statement, the optimizer will treat these two insert statements as a "Multi-Statement" insert. ... | |
You can do exactly the same thing in Queryman (SQL Assistant) by using the 'Execute Parallel' menu to submit the query, instead of
using the Execute menu/button.
Mike Dempsey
Teradata Client Tools
| |
