Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Error when loading Tables using TPT
 
From:   Srikant Adem

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016