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,SYSIBMADM
CREATE OR REPLACE TRIGGER SCHEMA1.TRIGGERNAME
NO CASCADE BEFORE INSERT
ON SCHEMA1.TIGGERTABLENAME
REFERENCING
NEW AS NEW
FOR EACH ROW@
------------------------------------------------------------------------------------------
DDL used to create the trigger
CREATE TRIGGER TRIGGERNAME
BEFORE INSERT ON TRIGGERTABLE
REFERENCING NEW AS NEW
FOR EACH ROW
NOT SECURED
BEGIN A
DECLARE V_ts TIMESTAMP ;
set new.name_ts = CURRENT TIMESTAMP ;
IF...
THEN
...
ELSE
...
END IF;
END @
The whole BEGIN...END block is missing