Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 20 Mar 2007 @ 10:10:55 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: NULLIF in .FIELD
From:   McCall, Glenn David

I think this is back to front.

You say:

  I have specified NULLIF with blank condition for NOTNULL columns in MLOAD.  

I interpret this as saying you have a column in a table defined as not null.

If you use nullif (e.g. nullif '') in mload then it will replace the empty string with a null when inserting the row into the database.

This will fail because the column is defined as not null.

I am not sure I understand what you are trying to achieve with the nullif as it is not possible to represent a (database) null in a flat file. The ASCII character known as NULL (i.e. ASCII code 0) is not the same thing as a database null. Some people call '' the null string, but it is also known as a 0 lenght string or an empty string - I don't think I have ever heard of it being refered to as NULL - mostly because '' and NULL are not the same thing.

I hope this helps

Glenn Mc

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