Page 1 of 1
How to check timestamp for inserted or changed row
Posted:
Fri Jul 23, 2010 4:44 am
by Chaitnya
Hi,
Can anyone tell me how to return timestamp for inserted or changed row in table.
Scenario is I have to check on which date the particular row has been inserted in a table.
Thank in advance,
Chaitnya
Re: How to check timestamp for inserted or changed row
Posted:
Fri Jul 23, 2010 9:01 am
by dick scherrer
Hello,
If the table was defined with a timestamp, use that timestamp in a query.
If there is no timestamp in the table, i do not believe you have a way to find a non-recorded date . . .
Re: How to check timestamp for inserted or changed row
Posted:
Wed Aug 04, 2010 1:45 pm
by salltm
In commonly DB2 table design, we shold have a DEL_TMSTP /ADD_TMSTP/ CHG_TMSTP to make sure the data can be traced.
if you don't have any columns like this. Sorry, It is differect to trace the Data change.
Ask DBA for help?
Re: How to check timestamp for inserted or changed row
Posted:
Sat Nov 20, 2010 8:38 am
by RENGANATHAN
create a new column and set current sqlid='timestamp'