Last update

eskaysem · #1 (**permalink**) 10-20-03, 21:27

Hi,
Is there any way that i can get the info as to who did the last update on a table? Do i need some rights, even if i've created the table.

Thanks!

sathyaram_s · #2 (**permalink**) 10-21-03, 03:36

AFAIK, you cannot find this information from DB2 ...

The option is to have an additional column,say, LAST_UPDATED in your table ...

HTH

Sathyaram

Quote:

Originally posted by eskaysem
Hi,
Is there any way that i can get the info as to who did the last update on a table? Do i need some rights, even if i've created the table.

Thanks!

Marcus_A · #3 (**permalink**) 10-21-03, 03:38

Or create a trigger that logs the last update info you want onto another table.

Internet Services

Web Development

Digital Marketing

Consumer Tech