Midrange News for the IBM i Community


Posted by: clbirk
temporal tables
has no ratings.
Published: 11 May 2017
Revised: 07 Sep 2017 - 2414 days ago
Last viewed on: 16 Apr 2024 (2622 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

temporal tables Published by: clbirk on 11 May 2017 view comments(1)

the other night got a demo of temporal tables on the ibm i.  Available in V7R3. The ability to have versioning without really any program changes or databases to maintain the system does it for you and you can go and ask for the table results as of a particular date and voila.

It is something to consider no doubt.

 

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: bobcozzi
Site Admin ****
Chicagoland
www.cozTools.com/qryfile
Comment on: temporal tables
Posted: 6 years 9 months 1 days 23 hours 57 minutes ago
Edited: Thu, 07 Sep, 2017 at 09:20:19 (2414 days ago)

They are a great feature to add to IBM i in v7r3. Some of our customers are upgrading to v7.3 to get that feature. It does require that the files are journalled, and it uses its own journal to create the temporal information. After you do one or two of them and we see how performance is, I thin it'll be something we use a lot.