Temporal Table + SQL Tricks for Spool Files

Speaker:
Simon Hutchinson

Tuesday, September 19, 2023 - 2:00pm to 4:30pm

Temporal Tables – Looking Back Into Your Data’s Past
We all work in environments where data is changing, often rapidly. At times it would be nice to know what the data looked like an hour, a day, or even a week ago. With conventional files and tables this is hard, that might even involve restoring data from journals. SQL Temporal Tables alleviates all of that work. They allow you to view the data as it was at any time, and allows many people to view the data at different times all at the same time.
(COMMON PowerUp 2023 rating: 4.92/5.00)

Tricks with Spool Files using SQL
In the past few releases and TRs IBM has introduced a number of SQL views and table functions that allow anyone to do things to spool files that they would have had to use APIs or complex programming. Become the superstar at your company with the knowledge on how to do all of this with just a few SQL statements.
(COMMON PowerUp 2023 rating: 4.79/5.00)

QUSER

Zoom

Zoom, MN 99999

United States

December 17, 2024 - 2:00pm	QUSER - December 2024, Marina Schwenk, Everbrite
January 21, 2025 - 2:00pm	IBM Flashsystems, Steven McIver, Service Express
April 15, 2025 - 2:00pm	QUSER April 2025 - Audit Journaling with Navigator for i, Ann Wilkerson, IBM

Main menu

Temporal Table + SQL Tricks for Spool Files

Upcoming Events

Useful Links

Contact Us

Main menu

You are here

Temporal Table + SQL Tricks for Spool Files

Upcoming Events

Useful Links

Contact Us