Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 Nov 2010 @ 20:11:11 GMT


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


Subj:   Fastload and unicode data
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, November 17, 2010 14:30 -->

Can anyone help me with loading Unicode data to Teradata from a Windows platform using Fastload (FL), I'm having all sorts of problems trying to get character sets and definitions correct. I'm at the point where Fastload is rejecting the load saying that the first data record is too long (by 16 bytes if that's relevant).

When running FL, I'm specifying the following parameters:

     -c UTF16
     -i UTF8
     -u UTF8

The Define statement is:

      inf1 (varchar(128) )
     ,inf2 (varchar(128))
     ,inf3 (float)
     ,inf4 (float)
     ,inf5 (smallint)
     ,inf6 (char(4))
     ,inf7 (char(4))

The first two columns are unicode, the last two are latin character set.

As far as I can see the data is correct (it was a simple "select *" from the source table) and the define statement matches the target table def'n.


Thanks.



     
  <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: 27 Dec 2016