V6R1 has another alternative, auto-generated timestamp fields. Syntax would
look something like:
myField TIMESTAMP NOT NULL FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP
You can even make them IMPLICITLY HIDDEN.
That should give you enough search keywords to google successfully.
I've written an article that covers them briefly in January 2009 Centerfield
newsletter:
http://www.centerfieldtechnology.com/publications/archive/Dec08-Jan09.pdf
Page 7 talks about it.
Hth, Elvis
Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com
-----Original Message-----
Subject: RE: Timestamp on a file
Alan,
I believe your only option would be a trigger (Add, Update) to force a
value change.
If you wanted this for NEW records (not update), you could do this with
a view that does not expose that timestamp field. Then, on write to
this view, the missing timestamp would initialize to current_timestamp.
I have not tried this in ages, so my confidence level is low...
Hth,
Eric
-----Original Message-----
Subject: Timestamp on a file
Afternoon everyone
I KNOW that I've seen this (well, I think I have)
Is there a way to define a timestamp on a file that will automatically
change each and every time the record is written/updated WITHOUT any
coding
changes to any programs.
Obviously re-compiles would be needed, but that's all
As always
any responses:- MUCH appreciated
Alan Shore
midrange.com
