SENTHIL MURUGAAN Warnings : 1 New User
Joined: 12 Jan 2013 Posts: 32 Location: India
|
|
|
|
Hello All,
We have created a DB2 Triggers to log all the deletion action on each rows from X table.
[CREATE TRIGGER TST.GX
AFTER DELETE ON TST.X
REFERENCING OLD AS O
FOR EACH ROW MODE DB2SQL
INSERT INTO TST.XD
( ID_X,
DELETEBY,
DELETEDT,
DELETEHMS)
VALUES
( O.ID_X,
SESSION_USER,
CURRENT DATE,
CURRENT TIME)]
But when we tried to delete rows from table X thru both SPUFI (Manual) and BATCH job execution, we could see both entries "SESSION_USER" values are same as developer id.
Kindly please advise how to store an either PLAN NAME/JOB NAME value in log table to trace the deletion log done by either user or application batch?
Thanks |
|