Re: Row and Statement based Trigger Question

JohnO wrote:
> The deletes are only going to be purge/archive operations, rather than
> business transactions. The first one is going to delete the millions
> as it will be several years worth. Subsequent ones will be annual so
> will still be pretty big, but not quite so bad.
If that's the case why don't you use batch process. Triggers are meant 
to to be active database objects. I wouldn't use them for maintenance
tasks.

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab