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

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

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
Resolution

WORKAROUND
none
STATUS
Issue fixed in version 6.3 The latest release can be downloaded here.
Defect ID

TDB-3138

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title