MVSFORUMS.com

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

Hi,

I have a table EMPLDTP. I want the info to find when the particular record is updated in table.

Thanks in advance.
Nadh

kolusu · Posted: Wed Jan 24, 2007 6:58 am Post subject:

nadh,

I assume you are talking about DB2 tables here. If so why is this question posted in TSO forum? I can understand if a newbie posted this question in the wrong forum. You have been in this forum long enough to follow the rules. Please follow the rules and post in the approriate forum.

Also another important thing is to SEARCH before posting. Check this link

http://www.mvsforums.com/helpboards/viewtopic.php?t=7563&highlight=audit

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

semigeezer · Posted: Wed Jan 24, 2007 8:24 am Post subject:

If you are refering to an ISPF table, there is no record kept of the row's update time or user or application or anything else. But ISPF tables are not really meant to be shared like that, hence Kolusu's assumption that this might be a relational database you refer to.

If this is an ISPF table that your program manages, you could add a column for that. ISPF table (as a whole) stats do give you last user and update time, but that is about it. Check the services manual for tbstats