Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 19 Mar 2007 @ 21:50:40 GMT

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

Subj:   Re: NULLIF in .FIELD
From:   Dieter Noeth

Ramu Kopuuravuri wrote:

  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 = ' ';
     NULLIF   IN_a = '';

  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)), ' ')
     NULLIF(trim(:IN_a), '')

Did you work with Oracle before?


  <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