Posted by --CELKO-- on 06/10/06 23:48

Put the working data into a working table with an index on it and try
this:

UPDATE Imitmidx
SET activity_cd = 'O',
activity_dt = '2006-06-01',
prod_cat = 'OBS'
WHERE item_no
IN (SELECT item_no FROM WorkingData);

You can also add constraints for data scrubbing to WorkingData.

[Back to original message]