Archives of the TeradataForum
Message Posted: Fri, 12 Nov 2004 @ 20:58:17 GMT
Subj: | | Re: New to BTEQ |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Friday, November 12, 2004 15:53 -->
.LOGTABLE YOUR_LOG_TABLE ;
DROP TABLE DROP_BEFORE_CREATE; /** Even though this is not shown as a supported support-command in the manual ***/
Create table .... Your table script; /* ANY INTERMEDIATE TABLE THAT YOU WANT TO CREATE / DROP */
Insert into your table ... Select * from another_table; /** select in the insert-select combo statement is considered a integeral command
of insert(?) for you cannot issue a stand-alone select in this place ***/
BEGIN EXPORT ;
YOUR EXPORT STATEMENTS ....
END EXPORT;
---------------------
.... For additional commands that is supported in the support-section refer to the TD manual
|