var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Trigger Declare
I know that some sql procedure statement I can used in trigger, but I got error, when I try this:
CREATE TRIGGER NEW_TRIG_TEST
AFTER INSERT ON FH04T18
FOR EACH ROW MODE DB2SQL
DECLARE l_proces varchar(50) DEFAULT 'TRIGGER';
DECLARE l_param varchar(50) DEFAULT 'USE';
is it possible to used DECLARE statement in trigger?
Did you get the message from DB2 ?
Visit the new-look IDUG Website
, register to gain access to the excellent content.
You must use declare variables within BEGIN ATOMIC ... END in triggers
Thank you for zor help now it is OK.
I have another problem with DECLARE EXIT HANDLER.
Is it possible to do this in trigger?
I think u cannot use condition handlers within triggers.