Loading…
LUG 78
Attending this event?
Welcome to Rochester and the 78th LUG meeting - celebrating 25 years!
Wednesday, September 18 • 1:30pm - 2:30pm
Temporal Tables/Sarah A Mackenzie

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

Have you ever wanted to know what data was in your table six months ago? Has data ever been deleted from your table that you now need to retrieve? Maybe you want to know when and who made a change to a row in your table? Temporal Tables, introduced in IBM i 7.3, is a data centric solution that allows you to keep track of the history of your SQL tables. Once enabled, you can use simple SQL queries to ask questions about your data at a specific point in time or over a range of time. This session will explain Db2 for i Temporal Tables and generated fields as well as give many examples that you can use in your applications.

Wednesday September 18, 2019 1:30pm - 2:30pm
025-2 E105 (Main Tent)