Dummy updates

Question

How to perform a dummy update on a table to remove any inplace alters.

Answer

UPDATE tab1 SET col1=col1 WHERE 1=1 ; The table name in this example is tab1, the column name is col1. one restriction is that the column chosen must be numeric.

http://www-01.ibm.com/support/docview.wss?uid=swg21674841&myns=swgimgmt&mynp=OCSSGU8G&mync=E