QUESTION POSED ON: 26 February 2003
Is it possible to DB2/400 to automatically keep track of the timestamp when the record is inserted or updated? I created the following PF.
FMT PF
.....A..........T.Name++++++RLen++TDpB......Functions++++++++++++++++++
*************** Beginning of data *************************************
0001.00 A R PETEST
0002.00 A PEER 3A
0003.00 A PEEN 10A
0004.00 A PTIM T
0005.00 A PDAT L DATFMT(*ISO)
0006.00 A PTST Z
****************** End of data *************************
When the record is written to the PF, timestamp, date and time are
initialized as follows. I read the documentation, the time/date and timestamp information should be initialized with current date and
time. When I've updated this record with SQL, timestamp is not updating with the current date and time. I wonder if this is even possible with DB2/400 to keep track of time stamp automatically (I mean with out pushing time stamp value by some program).
PEER: AAA
PEEN: AAA
PTIM: 00.00.00
PDAT: 0001-01-01
PTST: 0001-01-01-00.00.00.000000
|
