Re: Temporal database feature on IBM i?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Rob,

Yeah, I think when dealing with temporal tables, having a "current as of
now" view would be almost mandatory.

Charles

On Mon, May 11, 2015 at 9:35 AM, <rob@xxxxxxxxx> wrote:

> Charles,
>
> I found that link interesting.
> Application Time Period tables...
> Worked with an application in which the pay rate table had a composite key
> of employee number and date.  Made querying interesting.  Think of getting
> a list of employees pay rates for your department.  Especially if someone
> keyed in a pay rate adjustment coming up in the future.  Not impossible,
> just something to be aware of.
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.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.
>
>