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