Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 24 Jun 2013 @ 10:30:03 GMT


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


Subj:   Re: Exporting DECIMAL(15,2) from DB2
 
From:   Bommaiahpalli Siddareddy, Hari Krishna

Hi,

Thanks for reply.

While extracting from DB2, I made it as IFNULL(COLUMNA, '00') So the NULL values are replaced with 00.

While loading, I checked for 00 and replaced with NULLs. It went fine. So no need of data conversion required. When I changed the data types thru CAST, I didn't get the data properly into tera table.


Thanks,

Hari



     
  <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: 24 Jul 2020