Archives of the TeradataForum
Message Posted: Thu, 23 Mar 2007 @ 00:08:02 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|