Archives of the TeradataForum

Message Posted: Tue, 02 Mar 2004 @ 11:54:04 GMT

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

Hi,

You can do this using FastExport.

You need to specify an output format of TEXT, for example

  .EXPORT OUTFILE c:\output.txt
     FORMAT TEXT
     MODE RECORD;

This will output the information in a flat text file format.

Please note that you will need to convert some of the field data types to a CHAR(xxx) to ensure you do not output binary or additional data, such as the length of a VARCHAR field.

Regards

Matthew Winter

EDW Database Administrator
Teradata Certified Master

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