INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

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.
 

RE: Overwrite Export File using .Export in BTEQ

(OP)
I should make a correction here... the line I wrote
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.
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close