Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 26 Jun 2013 @ 08:05:18 GMT


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


Subj:   Re: Export results to a file from Teradata Adhoc tool
 
From:   McCall, Glenn David

Adhoc is designed as a simple mechanism to test the proper setup of the TD ODBC driver utility. It isn't really (IMHO) intended to be a proper client utility and doesn't have the functions you require.

If you really have to use adhoc, you have 2 options:

1) Modify the source code and add the function you need to export the result set (I believe it comes with source code because last time I used it, I had to "make" it).

2) Redirect adhocs output to a file and use that (./adhoc > output.txt

A much better option would be to use the client utility that is intended to support these functions. Specifically try using bteq. I'll leave it to you to read the manual, but have a look at the ".export" command in the manual.


Regards

Glenn Mc



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020