>Thanks for answering....
>It still doesn't work....

I take it that you have changed to a before trigger and it still doesnt update those columns. What happens if you try it in a dummie schema. I.e.

CREATE TABLE Dummie.KL_Key_LastGen (
KL_Edit_Who varchar(50),
KL_Edit_When timestamp,
xxx int
)@


CREATE TRIGGER Dummie.KL_Key_LastGen_Upd
NO CASCADE BEFORE INSERT ON Dummie.KL_Key_LastGen
REFERENCING NEW AS NEWROW
FOR EACH ROW MODE DB2SQL
set newrow.KL_Edit_When = current timestamp, KL_Edit_Who = USER

and then insert a row like I did. Do you get the expected result or does it still not work?

>I'm thinking there has to be somethingelse wrong.
>Could it be trying to compile the triggers like it does with
>SQL language stored procedures ???

That should not be the case

>We're having problems with that as well since we don't have a >compiler or it's somehow not been installed ???
>
>On a separate note.... Do we have to purchase the compiler >separate ???

I dont think that there is a compiler shipped with DB2. I didnt see what platform your on, but gcc is availible for free on most platforms

/Lennart


>Thanks.
>JR