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

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