Archives of the TeradataForum

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

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

I think this is back to front.

You say:

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