zOs/SQL/CRETRIP2

set current sqlid = 'S100447';
create trigger gdb9998.twk077a1Update   no cascade before
               update of WK077PART, WK077KEY
    on gdb9998.twk077a  referencing New as New
    for each row mode db2sql
         set WK077PART = MOD(new.WK077KEY, 3)
;
commit;
create trigger gdb9998.twk077a1Insert   no cascade before insert
    on gdb9998.twk077a  referencing New as New
    for each row mode db2sql
         set WK077PART = MOD(new.WK077KEY, 3)
;