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