>Hi Tim,
> Thanks for your response. I'm not clear on what you're suggesting, could you explain? My code is updating a single row at a time, like this:
>
>update 1 row
>commit the change
>
>so there is no issue of multilocks or multiple changes per commit.
>
>Thanks, Chaim

You have to set multilocks on to use buffering. If not, it's writing directly to the file--no buffering. If you plug in your own values to the code and try it, you'll see what I mean, using TABLEUPDATE and TABLEREVERT.