I would try something like:

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


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

-- test

db2 -td@ -f dd.sql
db2 "select * from KL_Key_LastGen"

KL_EDIT_WHO KL_EDIT_WHEN XXX
-------------------------------------------------- -------------------------- -----------

0 record(s) selected.

[jon@lillebror database]$ db2 "insert into KL_Key_LastGen (xxx) values 1"
DB20000I The SQL command completed successfully.
[jon@lillebror database]$ db2 "select * from KL_Key_LastGen"

KL_EDIT_WHO KL_EDIT_WHEN XXX
-------------------------------------------------- -------------------------- -----------
JON 2003-08-20-15.47.45.490237 1

1 record(s) selected.

You will probably want to capture updates on the table, the same way. I.e. by creating triggers like

NO CASCADE BEFORE UPDATE ON DBO.KL_Key_LastGen

as well


HTH
/Lennart