Overwrite Export File using .Export in BTEQ
Overwrite Export File using .Export in BTEQ
(OP)
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.
RE: Overwrite Export File using .Export in BTEQ
EXPORT REPORT FILE=<C:\data\myfile.txt
Does not read like that.. I think this has driven me so nuts I can't even type straight
EXPORT REPORT FILE=C:\data\myfile.txt (removed the <) is how it in fact reads. Sorry for any confusion.