>When an updatable view is based on a table that is buffered with OPT 3, how does the tableupdate() work? If I issue table update on the view, am I just updating the buffer of the base table, or is the tableupdate() on the view updating the base table. If the tableupdate() on the view is updating the buffer on the base table i would assume that I still need to issue the tableupdate() on the base table. Am I thinking about this correctly? Confused and befuddled.
>
>TIA.
>
>John.

I think that you need only be concerned with buffering the view, which is automatic and that you'd issue =tableupdate() against the view only. That's how I've done it. I don't even have the base tables in the DE and it seems to work just fine but I'm sure that there might be better thoughts on this.

Steve