Hello!

I would like to create insert-trigger on table A1, that will update the value in table A2. The value is intermed. I should update only 1 cell in A2, not column..
How can I do it?

for example,


CREATE TRIGGER My_INSERT
AFTER INSERT ON A1

FOR EACH ROW MODE DB2SQL

BEGIN ATOMIC
....

SET ???? = intermed;
END@

Thanks!

What is "intermed"?
From where it came? A column of table A1?

Does "only 1 cell" mean "only 1 row"?
If so, you should specify WHERE clause in your update statement in your trigger.

Thanks for answer!