If you want to go down the RCVJRNE route, there's a code example of how
that can be done here:
http://iprodeveloper.com/rpg-programming/retrieve-journal-entry-exit-pro
gram
Cheers,
Carsten
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: 30. oktober 2013 23:28
To: Midrange Systems Technical Discussion
Subject: Re: Log file of file changes
I agree with Joel. .
What Joel is talking about is what is called a Temporal database (Based
on time). Everything is time stamped and you can always see what the
database looked like at any given time. In this case, you are taking one
file.
To make it work you are going to need two time stamp fields, not date
fields, one for start and one for end. The first record written for a
given key always gets the current time stamp and the ending gets a null
or
0001-01-01-00:00:00:00000 value.
When the record is updated the end value is set to current time stamp
and a new record created with current time stamp for start and null for
end.
This sort of thing work best with a primary key being an identity key so
that is record has a unique id.
If you can't do that journal make sense to me.You can also do journaling
in almost real time. Use RCVJRNE and write to your log file.
This communication is intended only for use by the addressee.It may contain confidential or privilegedinformation.
If you receive this communication unintentionally, please inform us immediately and delete this e-mail and any attachments.
Warning: Although we have taken reasonable precautions to ensure no viruses are present in this email, we cannot accept
responsibility for any loss or damage arising from the use of this email or attachments.
midrange.com
