Updating Netezza With Dummy Values

update data set a = sub.DummyValue
from (
Select id,
'HH'||row_number() OVER(ORDER BY id ) DummyValue  from data a 
) sub
where data.id = sub.id;