Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Jan 2014 @ 10:42:22 GMT


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


Subj:   MLoad Error: "6996: Invalid conversion or assignment operation on a Period"
 
From:   Koushik Chandra

Hi,

I've a table which is being loaded through Informatica ETL tool. One column in the table is defined as PERIOD(TIMESTAMP(6) WITH TIME ZONE). There is no such datatype i found in the ETL tool. As the field is straight move from the source(flat file), I've made the datatype CHAR(72) in the ETL Tool.

Now the ETL tool is making the MLOAD script dynamically(Loader Connection) and it's declaring the datatype of the column in the script as CHAR(72).

During MLOAD, the conversion from CHAR to PERIOD should be done appropriately but it is throwing the error : "UTY0805 RDBMS failure, 6996: Invalid conversion or assignment operation on a Period." So MLOAD is not able to convert the data.

Note: We can insert the data manually through SQLA in the same table with same value. That ensure the data is correct and the DDL is also correct.

TD version: 14.10.01.01

Could you please help me regarding this error?


Regards,

Koushik Chandra



     
  <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: 15 Jun 2023