Archives of the TeradataForum

Message Posted: Fri, 09 Mar 2007 @ 13:44:31 GMT

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

Hi,

very simple:

     .LOGTABLE user.Err_Table_FE;
     .LOGON user,password;
     .BEGIN EXPORT SESSIONS 4;
     .EXPORT OUTFILE \\.\pipe\mypipe_001;
     SELECT * FROM dwkb.Posted_Transaction where Post_date >= 1070101;
     .END EXPORT;
     .LOGOFF;

that's all folks

JIRI BASLER
Data Warehouse Systems
Data Warehouse
Strategy and Finance

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