Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 23 Jun 2013 @ 09:10:41 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Exporting DECIMAL(15,2) from DB2
From:   Bommaiahpalli Siddareddy, Hari Krishna


I am unloading the data from DB2 table. In DB2 Table, the column was defined as Column A DECIMAL(15,2).

After extracting the data, I am trying to load in Teradata Table by using MLOAD script.

In tera also, I created the column in table with DECIMAL(15,2). Not sure but my MLOAD is failing.

But getting 2679 error.

Even I tried by changing the data types. While extracting I converted as Integer, and created teradata column as integer. But data is not loading properly, all data is becoming '0'.

Please help. It really urgent. Appreciate your timely help.



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020