Omni Banner


Time Travel with DB2 for i - Temporal Tables on IBM i 7.3
Scott Forstie, DB2 for i Business Architect


Tuesday June 21st 2016

Scott Forstie

Casey's Restaurant and Bar
415 E. North Avenue (IL-64), East of I-355
Lombard IL

5:00 Registration
6:00 Dinner
7:00 Presentation

meals | register | cancel | directions

With IBM i 7.3, DB2 for i has added a time machine into the database. No, you won't be able to submit your jobs under the "DeLorean_time_machine" subsystem, instead, DB2 for i has added Temporal Table Support, a way for you to tell the database to automatically keep track of the history of your SQL table. Once this data-centric history is enabled, you can use SQL to ask time-based questions (queries.) If you have ever needed to know the contents of a table at a specific point in time or over a time range, DB2 for i Temporal Table Support makes it easy to accomplish.

This session will explain DB2 for i Temporal Table Support and include working examples. It's time to retire older and less effective solutions to solving this important business requirement. Step up to IBM i 7.3 and use Temporal Tables in DB2 for i.

This session will also include details for using the new DB2 for i Generated Column Support for auditing row level changes.

Scott Forstie, DB2 for i Business Architect

Scott Forstie joined IBM in 1989 and is a Senior Technical Staff Member who has worked on the development of IBM operating systems for his entire career. As the DB2 for i Business Architect, Scott is responsible for everything related to the database on IBM i. In addition to his development responsibilities, Scott is a frequently published author and speaker at industry events. Scott can be found on Twitter @Forstie_IBMi and via email at forstie@us.ibm.com.

 
Dinner Options
Food and Drink are ala carte from caseysrestaurant.com

June Dinner Meeting Registration
Please make your reservations by Monday June 20th 2016.

To register, please do these 2 things...
1) Please submit your information using the form below to express your preferences.
2) Please pay for your registration on The Omni User Store by clicking the store link.
Thanks in advance!


First name:
Last name:
Title:
Company:
Address 1:
cc billing address
Address 2:
City:
State:
Zip:
Telephone:
Email:

Registration Options:

Please choose options and click Submit Information, and then please pay for your member or non-member dinner meeting on The Omni User Store at the link below the Submit Information button. 2016 Omni Memberships will be verified at the check-in table.
$15 Members
$40 Non-Member

LUG Affiliation:
Omni
WMCPA
MUGNI
QUSER
Southwest Michigan
Gateway/400 Group
Other:


To register, please do these 2 things...
1) Please submit your information by clicking the "Submit Information" button below.
2) Please pay for your registration on The Omni User Store by clicking the store link.
Thanks in advance!

Please click the button below to submit your information...

And, please pay for your registration on The Omni User Store

Please invite your friends and associates to join you at the Omni Dinner Meeting. Send them a message to tell them you'll be attending for education, networking, and so much more. For some, it might be a great reason to reconnect with a phone call. Omni appreciates everything you do to spread the word about your best value in IBM i on Power Systems education!
Dinner Meeting Cancellation Policy
Full credit will be issued for cancellations made before 9:00 am Monday June 20th 2016.
After 9:00 am Monday June 20th 2016, cancellation credit depends on meeting attendance.
All cancellations must be made by using the web cancellation feature below (the preferred method) or, if you must, by calling (630) 953-6312 and leaving the name(s) of those unable to attend.

images/Cancel.gif

Dinner Meeting Directions

The event will be held at Casey's Restaurant and Bar at 415 E. North Avenue (IL-64), East of I-355 in Lombard, IL


map
Click here for a map!



For more information
email questions to Jerome Hughes or leave a message on the OMNI line at (630) 953-6312



events | membership | by-laws | board | links | downloads | home

2021 Midwest Road, Suite 200 Oak Brook IL 60523
www.omniuser.org

opinions craved!
email webmaster
630.953.6312

© 2002-2016 The Omni User