Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Mon, 10 Oct 2005 @ 17:32:12 GMT





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




Subj:   Re: Equivalent of DB2's BIGINT in Teradata
 
From:   Fred W Pluebell



The definition of the column in the table is one thing, the layout of the input to FastLoad is another. FastLoad can do some simple type conversions but won't be able to handle an eight-byte binary field directly.

If you tell FastLoad it's DECIMAL(18) input (e.g. a ten-byte packed-decimal field on the mainframe), you'll need to make sure the DB2 export is also using that format.





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008