Re: Trigger while reading row?

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Mon, 04 Nov 2002 12:53:11 -0500
Message-ID: <3DC6B407.7050208@ca.ibm.com>

Quite a party in the NG....

The problem with your formula is in teh word AFTER. After the qualification an dthe Set clause, Before triggers, Update, the RI, or after trigger processing?
As you see there are five distinct spots where one might want to get information back.
teh later two being fairly disturbing since teh affects might be beyond teh scoep of the relation being dealt with.

Cheers
Serge

-- 
Serge Rielau
DB2 UDB SQL Compiler Development
IBM Software Lab, Toronto

Visit DB2 Developer Domain at
http://www7b.software.ibm.com/dmdd/

Received on Mon Nov 04 2002 - 11:53:11 CST