All:
I am trying to formulate a DB2 SQL queryVer 7.0,fixpack 3,OS:Win200)
Requirement. Need to pick a 100 records for a particular Column value & change the value.
Query I need:
"update s_contact_xm set x_suppress_reason='CM' where row_id in (Select row_id from s_contact_xm where x_suppress_reason='DD' fetch first 100 rows only)

Suggestions/workarounds appreciated