Trigger

SRE_DAYS_AFTER_UP

Beschreibung

Update-Trigger für die Replikation

Definition

CREATE TRIGGER SRE_DAYS_AFTER_UP FOR SRE_DAYS
INACTIVE AFTER UPDATE POSITION 0
as
begin 
  if ((USER <> 'REPLICATION') and (old.dastatus = new.dastatus)) then 
  begin
    insert into replication (tid,      tablename,  modus, rtid, idname, reptime) 
    values                  (new.daid, 'SRE_DAYS', 2,     56,   'DAID', 'now');
  end
end