Archives of the TeradataForum

Message Posted: Thu, 30 Jun 2011 @ 09:34:38 GMT

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

Hi,

Using Fastload mode will not include delimiters, so what you're seeing is to be expected.

As far as I'm aware, there is no functionality 'built in' to FastExport to produce a delimited output file.

Typically, this is done in your select statement or an OUTMOD/ACCESS MODULE routine.

If using the select statement to do this you 'll need something like:

     SELECT col1
           ,cast('|' as char(1)) as sep
           ,col2
           ,cast('|' as char(1)) as sep
     ...

You'll also need to use MODE RECORD and FORMAT TEXT.

Remember to CAST any numeric columns to CHAR or VARCHAR (actually, i think you may need to use CHAR for everything, otherwise you might end up with two-byte length fields in the 'middle' of you output).

Try that and see what happens.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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