Re: IBM i 7.3 Temporal tables

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Indeed...

*SELECT * FROM* DEPARTMENT *FOR SYSTEM_TIME AS OF CURRENT TIMESTAMP* -
6 *MONTHS*

https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/sqlp/rbafycrttemporaltable.htm?lang=en

Charles

On Wed, Apr 13, 2016 at 9:15 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

> I've seen a nice slide on this and Mark hits it right on the head.
>
>
> 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
>
>
>
>
>
> From:   "Mark Murphy/STAR BASE Consulting Inc." <mmurphy@xxxxxxxxxxxxxxx>
> To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Date:   04/13/2016 09:02 AM
> Subject:        RE: IBM i 7.3 Temporal tables
> Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
>
>
>
> A journal is significantly more difficult to query, and performance would
> be orders of magnitude better with a database table vs. a journal.
>
> Mark Murphy
> STAR BASE Consulting, Inc.
> mmurphy@xxxxxxxxxxxxxxx
>
>
> -----"Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx> wrote: -----
> To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
> From: "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>
> Date: 04/13/2016 08:45AM
> Subject: RE: IBM i 7.3 Temporal tables
>
>
> What would be the difference between a temporal table and a PF that is
> journaled?
> Wouldn't a journal receiver be able to give you the same result?
>
> Paul