Create trigger

[c***@hotmail.com]

CREATE TRIGGER DB2INST1.ATT_BD
NO CASCADE BEFORE
DELETE ON DB2INST1.AType
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
UPDATE Cache_Control
SET ccc_version = ccc_version + 1
WHERE (ccc_code = 'ATyye');
END^

Please correct my triggle,
Coz... it is not working..

[c***@hotmail.com]

I Fixed...

CREATE TRIGGER DB2INST1.ATT_AD
AFTER
DELETE ON DB2INST1.AType
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
UPDATE Cache_Control
SET ccc_version = char(integer(ccc_version) + 1)
WHERE (ccc_code = 'AType');
END^

Update on the other table only can be done AFTER DELETE.
ccc_version data type is character.. so in this case, I have to CAST ccc_version.

Anyway, This trigger sound?
I think I start to like DB2.....:>