Archives of the TeradataForum

Message Posted: Wed, 11 Oct 2006 @ 19:51:57 GMT

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

Hi Fachtna:

I wouldn't think your volume is all that large. Have you considered using BTEQ to do this export?

You could use the .foldline n1 n2 where n1 and etc are the column numbers where you want to have the carriage return.

You can also use (title '') /* 2 single quotes for no title at all */

For my time and effort this would be so much easier using BTEQ instead of FastExport which is great for large volumnes of data but a bit inflexible for anything that looks like a report as output.

Please say hello to everyone at AIB for me.

Best regards,

Mike Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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