Hopefully a dumb question, but is it possible to execute the command "update table tablename set col='val'" and have it commit every 200 rows or so ?
I know the statement is a single UOW and auto-commit will only take effect after the transaction has completed.
I want to update several million rows with the same value so if it fails I only want to roll-back to a sensible point and not right back to the beginning.
If there's a simpler method for doing this, that I've missed, I'd be grateful to know.
Thanks in advance