Archives of the TeradataForum

Message Posted: Tue, 26 Oct 2004 @ 23:05:17 GMT

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

Sampath:

When you read the FastLoad documentation, you will see that you can define a NULLIF on each field coming into the utility. When the field contains that value (only one allowed), a NULL is inserted into that column.

As for your second question, the documentation also shows that you can tell the utility what the incoming data value looks like using a format on the insert in the VALUES portion:

     DEFINE   Datein    (char(10))...

     values (:datein   (date, format 'yyyy/mm/dd'));

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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