Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 06 Aug 2004 @ 15:18:09 GMT


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


Subj:   Re: Query information from Queryman
 
From:   Dempsey, Mike

This may not be what you are looking for but...

If you are running the queries through SQL Assistant/Queryman and therefore have the Date/Runtime/#rows data available in the History window you can easily extract the columns you want by either

a) Using SQL Assistant to issue a query against its own history database, and optionally export the results to a text file.

b) Using Microsoft Access to view the columns you want or to export them from the history database to a text file


Then use Import mode to load that file into your table (Assuming you want it in a database table, and for some reason, you cant simply use the Access History Table.)

Note that if you extract the SQL column you will need to extract only the first part of it (Usually the 'keyword' - maybe extract the first 6 chars - Select/Update/Delete etc.)as it will cause problems in the file layout if you extract any line feed characters.


Mike Dempsey
Teradata Client Tools



     
  <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: 15 Jun 2023