I am not where I can get to my 6.1 machine, but I don't think this works
for RLA.
According to the documentation it also should work for native I/O and update
data.
But (at least at the beginning or release 6.1) it didn't work, we are
waiting for a PDF (or is there already one and we didn't order it?).
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von BMay@xxxxxxxxx
Gesendet: Thursday, 17. September 2009 23:36
An: Midrange Systems Technical Discussion
Betreff: Re: Timestamp on a file
I am not where I can get to my 6.1 machine, but I don't think this works
for RLA. It works great for SQL.
Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi
Young i Professionals
http://www.youngiprofessionals.com
MKirkpatrick@xxxxxxxxxxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/17/2009 04:32 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc
Subject
Re: Timestamp on a file
IBM i 6.1
as-row-change-timestamp-clause:
Using the CREATE or ALTER TABLE:
FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP
Specifies that the column is a timestamp and the values will be generated
by
the database manager. The database manager generates a value for the
column
for each row as a row is inserted, and for every row in which any column
is
updated. The value generated for a row change timestamp column is a
timestamp corresponding to the time of the insert or update of the row. If
multiple rows are inserted with a single SQL statement, the value for the
row
change timestamp column may be different for each row to reflect when each
row was inserted. The generated value is not guaranteed to be unique.
A table can have only one row change timestamp column. If data-type is
specified, it must be a TIMESTAMP or a distinct type based on a TIMESTAMP.
A row change timestamp column cannot have a DEFAULT clause and must be
NOT NULL.
From:
Alan Shore <AlanShore@xxxxxxxx>
To:
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:
09/17/2009 02:05 PM
Subject:
Timestamp on a file
Sent by:
midrange-l-bounces@xxxxxxxxxxxx
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
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
midrange.com
