Archives of the TeradataForum

Message Posted: Fri, 12 Nov 2004 @ 20:58:17 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

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


	<Prev	Next>		<<First	<Prev	Next>	Last>>