i tried to create a trigger , such that whenever there is an insertion into a database, i try to retrieve that row contents and insert into another table.
now how do i access the key value of the current row that was just inserted??
my current trigger is
INSERT INTO EAIUSER.xworlds_events
(NEXTVAL for myseq,'JDBC_X',
the EID is the object key. i tried something like CURRENT.EID .didnt work
cud someone help ?
DB2 VERSION V 8.1 ENTERPRISE SERVER EDITION
FIX PACK 4