hallo!

i have the following questing:

is it possible to reference the trigger transition tables (OLD_TABLE,
NEW_TABLE) inside a procedure which is called from a statement trigger?

e.g. i need a trigger
create trigger trig_u_a after update on a
referencing NEW_TABLE as new OLD_TABLE as old
for each statement
mode db2sql
begin atomic
values(proc_u_a(new, old));
end

the stored procedure for example should look like

create procedure proc_u_a(IN new tabletype, IN old tabletype)
language sql
....
insert into tab_c select new.col1, old.col1 ... from new, old
....


is this possible?

thanks
andreas lederer