create trigger "demoadm".jer_trg_u_deny update of er_id
on "demoadm".dwe_journal referencing old as o new as n
for each row
when ((n.er_id != o.er_id ) )
(
-- $Archive: /DB/Proc/jer_ddl.sql $ $Revision: 4 $
-- $Author: Rohloff $ $Modtime: 8.11.99 10:21 $
execute procedure "informix".n_v_error('Kein Aendern jer-Id erlaubt!'
));
HTML-Autor: Rohloff, Datenbank: demodb, Datenstand: 31.05.00 17:07