zOs/SQL/EXROWCH2

set current sqlid = 'S100447';
drop    table A540769.r2 ;
create  table A540769.r2 (
-- , r2 timestamp not null generated always
--        for each row on update as row change timestamp
     ROWCHg               TIMESTAMP NOT NULL GENERATED ALWAYS
       FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP
   , tx varchar(500) not null
) in dA540769.Aper15
;
TERMINATOR ? ;
create trigger A540769.r2AftUpd
    no cascade before update on A540769.r2
    referencing New as n old as o
    for each row mode db2sql begin atomic
         set tx = left('old=' || char(o.rowChg)
               || ', new=' || char(n.rowChg) || ', before ' || o.tx
                            , 500)
         ;
    end
?
TERMINATOR ; ?
insert into A540769.r2 (tx) values('1');
insert into A540769.r2 (tx) values('2');
select * from A540769.r2 ;
update A540769.r2 set tx = 'u';
select * from A540769.r2 ;