Archives of the TeradataForum

Message Posted: Mon, 02 Apr 2001 @ 21:11:51 GMT

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

Chris,

As others have mentioned, fastexport is working as intended.

To explain it a bit further: fastexport is designed to write out a data file, whereas if you put column headings in the file the idea is that this is a report. This behaviour difference is the same as BTEQ's EXPORT REPORT and EXPORT DATA/INDICDATA - one gives you a report with column headings, page breaks etc whilst the others simply give you a flat file. Fastexport has no 'export report' equivalent.

There have been numerous discussions, both here and at Partners etc about fastexport having a csv output option, which could also allow th eoptional writing out of column headings. But, it doesn't do it now.

If you need that now, you could try using BTEQ's 'export report' option, make sure you switch off the page breaks and you may want to remove the spaces between columns. You may be exporting too high a volume for bteq to really handle (or rather doing this with bteq may take too long), which only leaves you with the option of cludging the sql in a fastexport script to write the column headers out first. That may be worth a try.

Regards,

Dave

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