Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to show the query in export file using BTEQ?

Status
Not open for further replies.
DataAnalyst

DataAnalyst

Technical User
Nov 14, 2002
2
US

Hi ,

I would like my select query to be displayed alongwith the results in my BTEQ Export file. What is the BTEQ option for this?

Thanks.

 
Sort by date Sort by votes
There's no option for that ;-(
Just write the query to the file before the .EXPORT.
BTEQ doesn't overwrite an existing file, it appends to it.

Dieter
 
Upvote 0 Downvote
How do I get BTEQ messages wirtten to a Windows files without using an .export file? Or is that required?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teamalone
  • Locked
  • Question
How to export multiple files using teradata tpt
Replies
0
Views
167
Teamalone
Teamalone
multipledatabases
  • Locked
  • Question
How to bulk import a CSV or a TXT file trough command into a Teradata database
Replies
1
Views
280
Miguel93
Miguel93
Samm2020
  • Locked
  • Question
Oracle to Teradata for data source setup
Replies
1
Views
146
johnherman
johnherman
jholl
  • Locked
  • Question
Create Volatile Table in Teradata is showing 0 rows being processed
Replies
0
Views
123
jholl
jholl
micjohnson382
  • Locked
  • Question
Teradat 13.10. Need to split the string with a delimiter.
Replies
0
Views
148
micjohnson382
micjohnson382

Part and Inventory Search

Sponsor

Back
Top