Re: Question on "Non-Mergeable View"

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Fri, 25 Feb 2005 12:02:48 -0500
Message-ID: <38940mF5mstaiU1@individual.net>

DA Morgan wrote:
> nekkalapudi.siva_at_gmail.com wrote:
>

>> I want to make the view mergeable
>>

>
> You will need to use an INSTEAD-OF trigger.
>
> http://www.psoug.org
> click on Morgan's Library
> click on Merge Statement

I don't think he wants to MERGE INTO the view. The problem appears to be one of optimization.

Cheers
Serge

-- 
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Received on Fri Feb 25 2005 - 11:02:48 CST