触发器创建sql语句

前触发器
create trigger ratestatus
no cascade before
update of rate on currentrate
referencing old as oldrate new as newrate
for each row
mode db2sql
set newrate.status=
case
    when newrate.rate>=(select max(rate) from ratehistory where id=newrate.id)
           then 'highest'
    when newrate.rate>=(select min(rate) from ratehistory where id=newrate.id)
           then 'lowest'
    when newrate.rate>oldrate.rate
           then 'rising'
    when newrate.rate<oldrate.rate
           then 'droping'
    when newrate.rate=oldrate.rate
           then 'steady'
end

后触发器

create trigger recordhistory
after
update of rate on  currentrate
referencing new as newrate
for each row
mode db2sql
begin atomic