var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to crete a temporary table object in trigger?
I have some problems to convert a trigger from Oracle to DB2.
I have two questions regarding DB2 trigger code
1. How to crete a temporary table object in trigger?
In Oracle PL/SQL I do that as follows
CREATE OR REPLACE TRIGGER Test
BEFORE INSERT ON MyTestTable
FOR EACH ROW
TYPE MY_TABLE IS TABLE OF VARCHAR2(20);
MY_ARRAY := MY_TABLE('trial') ;
MY_ARRAY(1) := 'MY_STRING';
How to do this in DB2?
2. How do I know what SQL operation activated the trigger inside the
I mean, I need to know whether an update or insert operation which
activated the trigger?
Please help me.
Many thanks in advance
See my response to a similar post on what you can do in a trigger.