Archives of the TeradataForum

Message Posted: Tue, 27 Mar 2007 @ 20:13:01 GMT

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

Hello All,

I am pulling data from DB2 to Teradata using TPT.

TPT is doing Fastload.

I am getting an error when Column2 contains NULL Values with SourceCoulmn Data type as DATE. It is working fine when it doesn't encounter any Null Values.

     DB2 Source Structure: Column1 CHARACTER (10),
                                       Column2 INTDATE

Teradata Structure E.g.:

     CREATE SET TABLE ABC (
       Column3 VARCHAR (10),
                               Column4 DATE FORMAT 'YYYY-MM-DD' )
     PRIMARY INDEX (Column1);

Fastload does this Insert Statement:

     'INSERT INTO ABC (Column3, Column4) VALUES (:Column1, :Column2);'

Please advise the general process to load data in to Teradata using FastLoad when the Source Date Field contains NULL values.

Currently I made it to work using Coalesce (Column2,'defaultdate') but I need to go back and update them as null.

Another way that I am trying is to make Column4 as Column4 CHAR (10) in Teradata and when inserting, I am trying to transform Column2 to CHAR-- - VALUES (:Column1, :Column2 Char(10)). Could some one correct the Transformation.

Thanks in advance for your suggestions

Srikant

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