MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » February 2013

RE: journal entries - processing data changes & rollbacks



fixed

But wouldn't the DR after image contain the before image of the record?

Same with the UR?


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Friday, February 01, 2013 2:51 PM
To: Midrange Systems Technical Discussion
Subject: Re: journal entries - processing data changes & rollbacks

Guess it depends on why you're looking at the changes...

If you want to catch stuff that gets changed then changed back, you'll
probably want to look at all the entries.

Charles


On Fri, Feb 1, 2013 at 3:04 PM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:

I am looking for changes to - say - customer records.

Is it reliable to look at the oldest and newest pair of journal records
for a given file/RRN combination?

For example, a customer's favorite color changed today several times -
from GREEN to red to blue to ORANGE.

Is it reliable to only look at the GREEN (oldest journal record) and the
ORANGE (newest journal record) to find what the current favorite color is?

Or can the rollbacks get me into trouble with this logic?

I think I am OK - if ORANGE changed to yellow with a rollback, I think
that the last journal record would still show ORANGE still, so I should be
OK.

Anything I am overlooking?



______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs
Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact