Update Data in one column of a DB2 Table using data in another column

 

UPDATE DATA IN ONE COLUMN OF A DB2 TABLE USING DATA IN ANOTHER COLUMN 
 
There are instances when you wish to add a new column in a table and initialize it 
with data from a column which already exists in the table
 
UPDATE table SET Column1 = Column2
 
In the above query 
 
table      - Table in which update is to run
Column1    - Column which needs to be updated
Column2    - Column whose value is to be used to populate data in COLUMN1