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 Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023