Remark:
If i comment the 'DELETE' line, it works fine...
I'm not that familiar with db2 triggers so maybe it's just something stupid...
thnx

jon

When trying to insert this trigger:

CREATE TRIGGER ad_des_part_jon AFTER DELETE ON DESIGJON.PART_L IST REFERENCING OLD AS o FOR EACH ROW mode db2sql
UPDATE DEFINJON.PART_L IST A SET A.WEIGHT=((SELE CT WEIGHT FROM DEFINJON.PART_L IST WHERE $COID IN (SELECT $COID FROM DEFINJON.$EXT WHERE $COID_REF = o.$COID)) - o.WEIGHT) WHERE A.$COID IN (SELECT $COID FROM DEFINJON.$EXT WHERE $COID_REF=o.$CO ID);
DELETE FROM DEFINJON.$EXT...