I created this trigger years ago. So I don't know if there were such
restrictions on before trigger that time or if I reused triggerdefinitions
created for other more complex solutions. Today I would fill that file with
the complete data for import.
If the problem persists and the trigger may cause the problem, I will
redesign the solution.

Klemens

"Serge Rielau" <srielau@ca.eye-be-em.com> schrieb im Newsbeitrag
news:c0d408$9cl$1@hanover.torolab.ibm.com...
> Klemens,
>
> Not the answer you are looking for but:
> Why does youe trigger come back to update the same row?
> Shouldn't this be a before trigger?
>
> Cheers
> Serge
>
>
>
> --
> Serge Rielau
> DB2 SQL Compiler Development
> IBM Toronto Lab