Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 27 May 2008 @ 10:27:47 GMT


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


Subj:   Re: Fastload & pipe delimited file
 
From:   Anomy Anom

<-- Anonymously Posted: Tue, 27 May 2008 09:57 -->

Donna,

I assume the data is defined as vartext?

Your data will be exported as as variable length file and include a two byte record length descriptor at the beginning of every record - try an export without the concatenation of each column.

looking at the BTEQ script it looks to me as though you may have a delimiter after the last column. This would imply another column is on that record - try taking that out if that's the case.

You may have the pipe within you data - try something like <tab>

When using varchar I always err on the large side of caution by defining each column as big as the column can be - eg varchar(256)

You could also try the NOSTOP feature to force through you data - you could then take a proper look at the table once it is loaded up.

Give it a go.



     
  <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: 28 Jun 2020