Quote:
Originally posted by janrune
It is defined as
|
Oops....
It is defined as :
CREATE TRIGGER DBO.KT_Key_Table_Upd
NO CASCADE BEFORE INSERT ON DBO.KT_Key_Table
REFERENCING NEW AS NEWROW
FOR EACH ROW MODE DB2SQL
set newrow.KT_Edit_When = current timestamp, newrow.KT_Edit_Who = USER
It doesn't work on the existing table, but it works just fine on
a new one.. ???
That's strange...
Is there a way to make sure there is no trigger besides "DROP TRIGGER xxxx" ???
Thanks
JR