Re: journal entries - processing data changes & rollbacks

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.