View Single Post
  #13 (permalink)  
Old 08-22-03, 18:34
janrune janrune is offline
Registered User
 
Join Date: Aug 2003
Location: Austin, Texas
Posts: 12
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
__________________
JR Andreassen
janrune_NOSPAM@io.com
Reply With Quote