Wie wäre es mit dem Merge-Statement?

merge into zieltable a
using (select f1, f2, f3 from myfile fetch first 100 rows only) b
on a.key = b.key
when matched update set Status = 2