Is it possible to activate a DELETE-Trigger when loading data with the replace-option ? In the manual it says about the replace-option: ... deletes all existing data from the table, ...
So, I did the following:
create trigger ADU.BESTANDDATUM after delete on ADU.UTADU_ADRESSE
for each statement mode db2sql
update ADU.UTADU_DYN_ATTRIBUT set (WERT_INT) = month(current timestamp) where (NAME, ART) = ('ADU_BESTAND_DATUM_MONAT', 11) ;
db2 LOAD FROM UTADU_ADRESSE.IXF OF IXF REPLACE INTO ADU.UTADU_ADRESSE STATISTICS YES AND INDEXES ALL NONRECOVERABLE
-> The trigger wasn't activated, so I think it must be a SQL-DELETE to work. Or is it possible to activate a trigger on a LOAD ???