CREATE TRIGGER STAT_DAILY_ON_DATA_INSERT
AFTER INSERT ON MY_DATA
REFERENCING NEW AS NEW
FOR EACH ROW
MODE DB2SQL
BEGIN ATOMIC
    UPDATE STAT_DAILY SET DATA_COUNT = DATA_COUNT +  1  WHERE DATA_DATE = NEW.DATA_DATE AND DATA_TYPE = NEW.DATA_TYPE;
    INSERT INTO STAT_DAILY (DATA_DATE, DATA_TYPE, DATA_COUNT)
        SELECT NEW.DATA_DATE, NEW.DATA_TYPE,  1 
        FROM SYSIBM.SYSDUMMY1
        WHERE NOT EXISTS (
            SELECT  1 
            FROM STAT_DAILY
            WHERE DATA_DATE = NEW.DATA_DATE AND DATA_TYPE = NEW.DATA_TYPE);
END