Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Fast export with | delimited
From:   DWellman


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
           ,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.



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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023