Archives of the TeradataForum

Message Posted: Thu, 01 Jun 2006 @ 13:39:22 GMT

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

     bteq << !
     .run file = ${in_dir}/logon.btq;
     .export data file = ${in_dir}/output_data.txt, limit=100
     select * from au2.trans;
     .export reset;
     !

     .EXPORT DATA       Sends results to a host file in recordmode.
             INDICDATA  Sends query results that contain indicator variables to a host file.
             REPORT     Sends results to a host file in fieldmode.
             DIF        Output converted to Data Interchange Format.

Please refer to the manual for the detail.

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