SQL0206N "O.$COID" is not valid in the context where it is used.

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

re: SQL0206N "O.$COID" is not valid in the context where it is used.

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