Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 27 May 2008 @ 15:03:55 GMT


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


Subj:   Re: Fastload & pipe delimited file
 
From:   Poston, Donna

Hi Mike,

The data was exported by another group and I don't think it was setup correctly. Based on how the data was exported, neither vartext nor text will work with the fastload some of the columns were cast as character and the text was treated as one concatenated column having pipe delimiters separating each column. The BTEQ export was defined as the example below.

     EXPORT OUTFILE /xx/xxxx/xxxx/xxxxxxx/ MODE RECORD FORMAT TEXT;

Being that FastExport utility does not allow the definition of vartext with pipe delimited data, what is the correct way to define this in BTEQ?

Would the correct way be to define the Export file as 'EXPORT DATA OUTFILE /xx/xxxx/xxxx/xxxxxxx/' and define each data type exported as VARCHAR?


Thanks much,

Donna



     
  <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