When you say neither works, does it mean you get an error ?
If so, please post the message
Cheers
Sathyaram
Quote:
Originally posted by janrune
Hi...
I have a simple question for one who is experienced...
In all our tables we have the two fields Edit_Who and Edit_When:
KL_Edit_Who VarChar(30) DEFAULT USER,
KL_Edit_When TIMESTAMP DEFAULT CURRENT TIMESTAMP,
In order to get those updated on each update we have to revert to triggers.
So I wrote two versions neither works...
CREATE TRIGGER KL_Key_LastGen_Upd
AFTER INSERT ON DBO.KL_Key_LastGen
FOR EACH ROW MODE DB2SQL
UPDATE DBO.KL_Key_LastGen SET KL_Edit_Who = USER, KL_Edit_When = CURRENT TIMESTAMP
CREATE TRIGGER KL_Key_LastGen_Upd
AFTER INSERT ON DBO.KL_Key_LastGen
REFERENCING NEW_TABLE AS NEWEMPS
FOR EACH STATEMENT MODE DB2SQL
UPDATE DBO.KL_Key_LastGen K SET KL_Edit_Who = USER, KL_Edit_When = CURRENT TIMESTAMP
WHERE KL_Table_Key IN( SELECT NEWEMPS.KL_Table_Key FROM NEWEMPS)
Anyone care to shed some light on my errors ???
Thanks
JR
|