SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 12:09 PM
| ||||
| ||||
 IMPORT incompatible with INSTEAD OF triggers? 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? Jeremy Rickard      |
|
02-27-2008, 12:09 PM
| ||||
| ||||
| Re: IMPORT incompatible with INSTEAD OF triggers? 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 |
Linear Mode
