Archives of the TeradataForum

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

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

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>>