Archives of the TeradataForum

Message Posted: Thu, 30 Jun 2011 @ 09:36:11 GMT

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

<-- Anonymously Posted: Thursday, June 30, 2011 05:19 -->

Hi,

Fastexport does not provide any easy way of having delimiters. You can use the following:

     .EXPORT OUTFILE OUTPUT_FILE1
      MODE RECORD FORMAT TEXT;

     SELECT  TRIM(column_1) (CHAR(10))
             ,',' (CHAR(1))
             ,TRIM(columns_2) (CHAR(20))
             ,',' (CHAR(1))
             ,TRIM(columns_3) (CHAR(10))
             ,',' (CHAR(1))
     from table_name;

This will give you the output as a csv file. Instead of comma, you can have your own delimiters.

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