'Extract DDL' for a 'Before Insert' trigger does not include the full SQL for recreating the trigger. (4306070)

Chat now with support

Return

Title

'Extract DDL' for a 'Before Insert' trigger does not include the full SQL for recreating the trigger.
Description

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

Sign In Required

You need to be signed in and under a current maintenance contract to view premium knowledge articles.