Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 13 Jun 2012 @ 10:17:55 GMT


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


Subj:   History data Modification
 
From:   Anomy.Anom

<-- Anonymously Posted: Wednesday, June 13, 2012 03:48 -->

Hi Experts,

I need to change two data types of columns and add one new column in some of the history tables and modify the data in the history tables (for the three columns) after mapping with master tables

Existing Columns

     Store_cd  from current char(5) to Integer
     Deprtment_cd from current char(3) to Byteint.

New Column

     Section_cd Byteint

Can you kindly let me know what best approach should be followed for this change...

Many Thanks in advance...


Regards



     
  <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