Voltar
-
Título
'Extract DDL' for a 'Before Insert' trigger does not include the full SQL for recreating the trigger. -
Descrição
In the Object Explorer, right-click a 'Before Insert' Trigger | Extract DDL does not generate the full create trigger script. i.e It doesn't create the SQL that runs when Before Insert trigger is fired off. e.g.:
Toad produces:
SET CURRENT PATH = SYSIBM,SYSFUN,SYSPROC,SYSIBMADMCREATE OR REPLACE TRIGGER SCHEMA1.TRIGGERNAMENO CASCADE BEFORE INSERTON SCHEMA1.TIGGERTABLENAMEREFERENCINGNEW AS NEWFOR EACH ROW@------------------------------------------------------------------------------------------DDL used to create the triggerCREATE TRIGGER TRIGGERNAMEBEFORE INSERT ON TRIGGERTABLEREFERENCING NEW AS NEWFOR EACH ROWNOT SECUREDBEGIN ADECLARE V_ts TIMESTAMP ;set new.name_ts = CURRENT TIMESTAMP ;IF...THEN...ELSE...END IF;END @The whole BEGIN...END block is missing -
Resolução
-
ID do defeito
TDB-3138