JC wrote:
> I forgot to mention above that I successfully tested the update via the
> view from the DB2 CLP and the DB2 Command Center. I've also been able
> to update from QMF for a view over a single table. The error only
> occurs for the view over the two tables, when the update is attempted
> in QMF.
>
DB2 determines the updatability of a view soley by its' structure.
E.g. a view based on a JOIN is not updatable. The rules are describe )I
think) in teh CREATE VIEW statement. Search for "updatable view"
If you need to update such a "complex" views you can take a look at
INSTEAD OF TRIGGERs. Such a trigger defines a mapping from the view to
the base table (typically the reverse operation from the SELECT).

Cheers
Serge


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab