Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   NULLIF in .FIELD
From:   Kopuuravuri, Ramu


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,


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023