Attending this event?
Wednesday, April 8 • 2:00pm - 3:15pm
Temporal Tables – Time Travel with Db2 for i

Sign up or log in to save this to your schedule and see who's attending!

What are temporal tables? A new feature in Release 7.3! Temporal tables are traditional data (physical) files or SQL Tables linked with a history table with the same structure as the base file/table. When updating or deleting a row the row before manipulation is automatically stored in the history table. In this way history tables can be used for auditing purposes. The main advantage of however of a temporal table is, it can be queried for any timestamp in the past (after the creation date). So for reprinting the inventory report for the last month, simply the temporal system time of the current job must be set and the program must be executed.

avatar for Birgitta Hauser

Birgitta Hauser

Fresche Solutions
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany.She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works as... Read More →

Wednesday April 8, 2020 2:00pm - 3:15pm
(E) Ashland
Feedback form isn't open yet.

Attendees (2)