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