Archives of the TeradataForum

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

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

<-- 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>>