I've used teradata sql assistant a long time, but recently found a need to use BTEQ. All is going well but I can't figure out how to get the .export command to overwrite the output file. In the teradata documentation it says use the > symbol.. but it doesn't say where or give an example. So this is what I'm running (pared down for the forum)
.SET WIDTH 254
.EXPORT REPORT FILE=<C:\data\myfile.txt
Select * from MyTable;
.EXPORT RESET
Works just dandy, but the output from each run appends the previous output. Thanks in advance for what is probably the easiest question ever asked on here.. I just can't find it.
.SET WIDTH 254
.EXPORT REPORT FILE=<C:\data\myfile.txt
Select * from MyTable;
.EXPORT RESET
Works just dandy, but the output from each run appends the previous output. Thanks in advance for what is probably the easiest question ever asked on here.. I just can't find it.