Why would you bother doing that?

First of all, TABLEUPDATE() does not require the use of RVs. It requires row/table buffering of tables/cursors.

You must not be using row/table buffering. Please don't tell me you are using SCATTER/GATHER.


>We wrote a routine which mimics the TABLEUPDATE (because we are not using RV's). What we found was that if varied. The smaller the set of updates, the faster our routine was over TABLEUPDATE. When you got into updating thousands of rows, the TABLEUPDATE became faster.