Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 26 Nov 2004 @ 19:45:40 GMT


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


Subj:   Re: Fast Export Decimal problem
 
From:   Fachtna ODonovan

Thanks for all the replies.

The solution that we went for in the end was to put out an indicator out before each of the nullible decimal fields

     Select
      col1
     ,case when decimal_field is null then '?' else ' ' end
     ,decimal_field
     ,col3
     ,col4
     from my_table;

The load utility is then able know which decimal fields are nulls and can load them accordingly.


Thanks

Fachtna



     
  <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