Archives of the TeradataForum

Message Posted: Thu, 11 Aug 2016 @ 14:39:06 GMT

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

Hello Surajit,

Can you try below, and see if this is of any help.

     filename: test.txt

     .logon /,;
     .export file=C:\ab.txt
     select * from testdb.testtable;
     .export reset;
     .os copy C:\ab.txt
     C:\ab__%date:~-4,4%_%date:~-7,2%_%date:~-10,2%_%time:~0,2%-%time:~3,2%-%time
     :~6,2%_ff.txt
     .os del C:\ab.txt
     .quit;

On windows commandline:

     bteq


Thanks,

Sandeep.

GANGA SANDEEP KUMAR

 
 
 
 


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