jrickard@unisystems.biz wrote:
> Hi,
>
> I'm getting an SQL3193N on DB2 v8 (fixpak 11)...
>
> SQL3193N The specified view or materialized query table cannot be
> updated. You cannot LOAD/IMPORT into this view or LOAD into this
> materialized query table.
>
> ...when I try to IMPORT INSERT into my non-updateable view. The view
> has an INSTEAD OF trigger defined on it, and inserts with standard SQL
> work.
>
> It seems to me that IMPORT does an up-front check to see whether the
> view is updateable, without taking into account the trigger.
>
> Has anyone got this to work, or is this a known problem?
Interesting. I don't think this is a known problem. May be worth opening
a PMR. Technically it's not a defect, but I don't think this limitation
was made consciously.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab