Archives of the TeradataForum

Message Posted: Thu, 23 Mar 2007 @ 00:08:02 GMT

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

Hello All,

We are using TPT 8.1 and Teradata 6.0. I am trying to pull a Table from DB2 Source to Teradata using TPT windows version. I am getting an error (unable to load) when there is a null value in the field with Column Data Type of Decimal or Date. I am able to pull data when there is a null in the field with Column Data Type of Character.

The error is

     161: W_0_o_DB2MAr21: sending SELECT request
     162: Catalog or message not found.  Parameters are:**** 18:43:10,2,
     163: Catalog or message not found.  Parameters are:****
     18:43:10,VAP_ADD_DATE,?
     ,
     164: Operator(odbcop.dll) instance(1): EXECUTE method failed with status
     = Fatal Error
     165: Execute command failed with status 37
     166: Execute command failed with 37

I used Coalesce and Case to Change the NULL value to dummy value and it worked. But I want to pull null as null value.

Thanks in advance.

Srikant

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