Archives of the TeradataForum

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

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

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>>