Archives of the TeradataForum
Message Posted: Mon, 05 Apr 2010 @ 15:31:13 GMT
| Subj: || || Multiple Output files from 1 Query |
| From: || || Graham, Fred |
Hi everyone, I am using Teradata SQL Assistant and would like to know if there is a way to create a query that creates multiple output files.
I have created a volatile table that contains Unit_ID, StartDate, and EndDate. I am using that table as an index to pull data on each unit
between the given start and end dates. Because the amount of data for each unit can be quite large, it would be best to have the query create
unique output files for each unit. I was hoping to be able to do this without running individual queries. Any suggestions?