Archives of the TeradataForum

Message Posted: Wed, 08 Oct 2009 @ 00:35:59 GMT

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

If it's a relatively small amount of data here's a bteq solution.

The TPT DC can output vartext but only with the SQL Selector which uses single session field mode like BTEQ report.

     .logon dbc/user,password;
     .set session respbuflen max1mb;
     .set titledashes off;
     .set separator ',';
     .set width 65531;
     * increase or limit the rows,columns.  columns defaults to 100 .set retlimit 1000,2048;
     .export report file=reportfile; select cols from table; .export reset; .logoff; .quit

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