Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 19 Mar 2007 @ 19:22:50 GMT


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


Subj:   NULLIF in .FIELD
 
From:   Kopuuravuri, Ramu

Hi,

I have specified NULLIF with blank condition for NOTNULL columns in MLOAD. But target table still have null values and those record's logged in to error, seems NULLIF condition is not working.

     .FIELD IN_a        * VARCHAR(1) NULLIF   IN_a = ' ';
     .FIELD IN_b        * VARCHAR(14);
     .FIELD IN_c        * VARCHAR(6) NULLIF   IN_c = ' ';

And I try to use this NULLIF in INSERT clause like

     ,NULLIF(cast(:IN_a as CHAR(1)), ' ')
     ,NULLIF(cast(:IN_b as CHAR(1)), ' ')

Thanks in advance,

Ramu.



     
  <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