When trying to insert this trigger:
CREATE TRIGGER ad_des_part_jon AFTER DELETE ON DESIGJON.PART_LIST REFERENCING OLD AS o FOR EACH ROW mode db2sql
UPDATE DEFINJON.PART_LIST A SET A.WEIGHT=((SELECT WEIGHT FROM DEFINJON.PART_LIST 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.$COID);
DELETE FROM DEFINJON.$EXT WHERE $COID_REF=o.$COID and $CONAME='DESIGJON.PART_LIST' and $TYPE='CATASS';
ERROR MESSAGE:
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0206N "O.$COID" is not valid in the context where it is used.
SQLSTATE=42703
someone has an idea?
thnx
jon