Archives of the TeradataForum

Message Posted: Fri, 07 Apr 2006 @ 11:07:43 GMT

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

'*' is the character that will be substitute with null if it is present in the input file....

NULLIF is used for special conversions. When another system uses a special combination to represent unknown data values, you can test for them and convert them to NULL in the Teradata database.

For example:

If you attempt to place a zero (0) into a DATE field, you will get the following error:

#3520 A constant value in a query is not valid for column colname.

So you must use NULLIF to convert the zero in NULL...

Andrea Cappelli
NCR Italia
Teradata Professional Services
Teradata Certified Implementation Specialist V2R5

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